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

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

Thanks!

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.

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"reannie" wrote in message
...
I have an e-mail list which is just all the e-mail addresses seperated by
comas, one after the other. Like this: , ,
...

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

Thanks!

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.
--
Top Notch Admin


"Herb Tyson [MVP]" wrote:

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.

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"reannie" wrote in message
...
I have an e-mail list which is just all the e-mail addresses seperated by
comas, one after the other. Like this: , ,
...

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

Thanks!

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.


On 5/17/05 6:50 PM, "Michael_Corral" wrote:

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.
--
Top Notch Admin


"Herb Tyson [MVP]" wrote:

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.

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

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

Thanks!

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

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"Daiya Mitchell" wrote in message
.. .
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.