| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating custom list with a comma in it
I need to sort a list of cities. I know how to creat a custom list however
there seems to be a bug in it. I am hoping somebody knows how to work around this Creating this list is simple: CHICAGO BALTIMORE PHILADELPHIA DALLAS WASHINGTON The problem comes when the same city is in multiple states so that the cell actually says: COLUMBUS, OH COLUMBUS, GA PORTLAND, OR PORTLAND, ME because internally the item separator is a comma, the custom list changes these entries to: COLUMBUS OH COLUMBUS GA PORTLAND OR PORTLAND ME Obviously when you do a data sort it doesn't find any of these values. I tried creating the list programatically using the addCustomList but it did the same thing. I've run out of things to try. Any help would be appreciated. Peter Richardson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
| custom list | Excel Discussion (Misc queries) | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Threaded Mode
