Isolating Email addresses

[H00tenanny]

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 [email protected]/net, etc., or am I stuck editing each one out?

Thanks for your time.

[Jezebel]

There's no formula that recognises addresses as such, but there are
techiques you can use depending on what the 'other information' is that your
cells contain. If they are all like [email protected]/net, use Data > Text to
Columns and specify / as the delimiter: you'll end up with the email address
in column 1 and the 'net' bit in column 2.

Another approach is to use the Find() worksheet function to locate the
character that separates the address from the rest, then use Left(), mid()
or Right() to extract the part you want.



"H00tenanny" <[email protected]> wrote
in message news:[email protected]...
>
> 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
> [email protected]/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
>

[Anne Troy]

What does the data look like? Perhaps you can use the Data-->Text to Columns
feature.
************
Anne Troy
www.OfficeArticles.com

"H00tenanny" <[email protected]> wrote
in message news:[email protected]...
>
> 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
> [email protected]/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
>

[Richard Buttrey]

On Sat, 22 Oct 2005 22:33:45 -0500, H00tenanny
<[email protected]> wrote:

>
>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
>[email protected]/net, etc., or am I stuck editing each one out?
>
>Thanks for your time.

Do the email addresses in the text string have a space at the
beginning and end of the address? If so it would be fairly trivial
matter to edit them out using a VBA macro.

If there was any unique character at the beginning and end of the
address then a combination of two or three text slicing functions
could achieve the same thing.

If either of these apply, please say and no doubt a solution can be
provided.

HTH



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

[H00tenanny]

Thanks for your help. The Data > Text funtion worked great!

A typical cell would contain "[email protected] (Sherry Holt) (Jan 7 96), Score = 1.000"

and some had < preceding the address and > at the end with no spaces, but that was easy to remove using the find and replace with nothing function. Again, thanks, you've saved me loads of time!