隨筆 - 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)  編輯  收藏

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


          網站導航:
           
          主站蜘蛛池模板: 边坝县| 田东县| 凤翔县| 彭山县| 菏泽市| 左贡县| 高阳县| 周口市| 宿迁市| 铅山县| 文昌市| 宁陕县| 葵青区| 苏尼特右旗| 晋宁县| 晋州市| 门源| 左贡县| 上思县| 浮梁县| 大城县| 西丰县| 赞皇县| 双流县| 喀喇沁旗| 黄浦区| 安泽县| 旬邑县| 扬州市| 横山县| 嘉兴市| 达州市| 司法| 常州市| 巫山县| 桃园县| 北宁市| 井冈山市| 东平县| 东兰县| 古丈县|