Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Would someone please help. Thanks.
I want the following 3 items in a data validation list. Note they have commas in the items. Apple, Kiwi, and Orange Strawberry, Mango, and Banana Pineapple, Banana, and Orange I can't get data validation to display the comma in the item because it takes the comma as a seperator for a new item. So typing the above show the following list: Apple Kiwi and Orange Strawberry Mango and Banana Pineapple Banana and Orange I have to be able to type these items directly into the DV list, not into cells where DV uses a cell reference. Can this be done? Thanks again. |
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 |