Home |
Search |
Today's Posts |
#8
![]() |
|||
|
|||
![]()
Yeah, I thought about that early on, but I wanted to avoid using
another area. My simplest solution so far is to abandon commas alltogether and us "/" instead. So and item would look like this... Apple / Orange / Pear Luckily none of my items include that delimiter. I can then use that character easily in search and count routines and the user can easily edit the DV list directly in the dialog box. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation list selection question | Excel Worksheet Functions | |||
Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions |