隨筆 - 12  文章 - 0  trackbacks - 0
          <2018年11月>
          28293031123
          45678910
          11121314151617
          18192021222324
          2526272829301
          2345678

          常用鏈接

          留言簿(103)

          隨筆檔案

          文章檔案

          jQuery

          搜索

          •  

          最新評論

          閱讀排行榜

          評論排行榜

          Here's a "cheat" for the comma that you want:

           

          When you hard code the data validation list, instead of a comma in your entry (Boston, MA) , use this key combination: Alt+0130

           

          It will display a comma in the data validation list, as you requested, BUT, it isn't a "real" comma, so it will be ignored if you search for the string - Boston, MA - in the other parts of the spreadsheet...Or if you try to use the ouput of the data validation selection to lookup matching values elsewhere in your workbook...

           

          But if you are hard-coding your data validation list, I assume that you aren't planning to use it to reference other places in the workbook, right?

          posted on 2018-11-27 14:16 萍水相逢 閱讀(169) 評論(0)  編輯  收藏

          只有注冊用戶登錄后才能發表評論。


          網站導航:
           
          主站蜘蛛池模板: 镇安县| 佛冈县| 项城市| 商南县| 横峰县| 虹口区| 什邡市| 弥勒县| 绍兴市| 遂川县| 江都市| 东莞市| 汝南县| 城固县| 新河县| 米泉市| 庄浪县| 织金县| 东安县| 五河县| 托克逊县| 汝州市| 宣化县| 东莞市| 涟水县| 花莲县| 蓝山县| 扎赉特旗| 同仁县| 缙云县| 嘉禾县| 中宁县| 卓资县| 株洲市| 武功县| 高雄县| 台南市| 海城市| 都昌县| 泰顺县| 沂水县|