",6,99)
This assumes that no address is longer than 99 characters (including
stmp:)


ultra_xcyter wrote:
I am using Excel 2003 and I have a spreadsheet that I need to format.
The spreadsheet contains about 10,000 email addresses;however, all the
email addresses have 'smtp' in front of it so it looks like this:


I need to remove the 'smtp' in front of each email address, but I don't
feel like doing it one-by-one since there are 10,000 email addresses.

Is there a way to do this all in one shot or at least in batches?
Thanks for any advice.


--
ultra_xcyter
------------------------------------------------------------------------
ultra_xcyter's Profile: http://www.excelforum.com/member.php...fo&userid=9946
View this thread: http://www.excelforum.com/showthread...hreadid=570902