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
Bookmarks