What does the data look like? Perhaps you can use the Data--Text to Columns
feature.
************
Anne Troy
www.OfficeArticles.com
"H00tenanny" wrote
in message ...
I've got a list in excel that has email addresses, but each cell also
has other information. There are thousands, and I don't want to edit
each cell. Is there a formula that recognizes the address only
/net, etc., or am I stuck editing each one out?
Thanks for your time.
--
H00tenanny
------------------------------------------------------------------------
H00tenanny's Profile:
http://www.excelforum.com/member.php...o&userid=28287
View this thread: http://www.excelforum.com/showthread...hreadid=478528