You're welcome. Excel is easy to use. Just some things that don't have
built in functions to solve. This actually could have been done on a
worksheet using some of the text parsing functions people have built and then
using the Data | Sort feature and then concatenating the results back into a
string. But that would have been a lot more manual work for you. Having a
variable number of state IDs in the cells was also something that I thought
about and it would have complicated the worksheet solution.

By the way, that is a very generic solution. It would work on any text
contained in a single cell, including variable length strings like perhaps a
list of names or colors or such. I think that it could be improved by coding
up a different sort, say a heap or shell sort, but for short lists, the
simple bubble works fine enough.

"David" wrote:

> Wow. And here I was thinking that Excel was easy to use. But I've pasted
> this code into the VB [takes me back] editor and run it, all in the correct
> manner purely by fluke, and it worked fantastically. Thank you.
>
> David
>
>
>
>