随笔 - 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 萍水相逢 阅读(153) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航: