How do I sort a list of words separated by comas?

[Guest]

I have an e-mail list which is just all the e-mail addresses seperated by
comas, one after the other. Like this: (e-mail address removed), (e-mail address removed),
(e-mail address removed)...

Is there a way to easily get it into alphabetical order?

Thanks!

 

[Herb Tyson [MVP]]

I would use Find/Replace to change the commas to paragraph marks, use
Table - Sort to sort them (this command works on any selected list, not just
on tables), then change the paragraph marks back into commas.

Find what:,

Replace with:^p

Select the list and choose Table - Sort

then swap the Find what and Replace with field contents.

 

[Guest]

Instead of the paragraph mark, I would use the tab character and then copy
the whole thing and past into Excel and then sort, I think it can all be done
in just under a minute if you do it this way.

 

[Daiya Mitchell]

You might do it that way, but it makes far more sense to just do it in Word,
which will also take under a minute.

 

[Herb Tyson [MVP]]

Besides... we're pretty sure the person asking has Word. ;-)