Extracting out of a emai address string
 

Hi,

I'm trying to extract the domain name/company name of an email address
string. So anything after the "@" and before the "."

I've got 400 emails and i've got to catergorise them by company.

Your help is much appreciated.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354

Extracting out of a emai address string
 

Hi
Try this:
=MID(A2,SEARCH("@",A2)+1,SEARCH(".",A2)-SEARCH("@",A2)-1)

Andy.

"harpscardiff"
wrote in message
news:harpscardiff.2954io_1149865806.8229@excelforu m-nospam.com...

Hi,

I'm trying to extract the domain name/company name of an email address
string. So anything after the "@" and before the "."

I've got 400 emails and i've got to catergorise them by company.

Your help is much appreciated.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354

Extracting out of a emai address string
 

Thanks for the reply.

I've tried it, works for some and not for others. theres no obvious
pattern?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354

Extracting out of a emai address string
 

Hi
I suppose this could happen if the name before the @ contained a period?

Andy.

"harpscardiff"
wrote in message
news:harpscardiff.2955wp_1149867612.5751@excelforu m-nospam.com...

Thanks for the reply.

I've tried it, works for some and not for others. theres no obvious
pattern?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354

Extracting out of a emai address string
 

Try this:
=MID(A2,SEARCH("@",A2)+1,SEARCH(".",A2,SEARCH("@", A2))-SEARCH("@",A2)-1)

Andy.

"harpscardiff"
wrote in message
news:harpscardiff.2955wp_1149867612.5751@excelforu m-nospam.com...

Thanks for the reply.

I've tried it, works for some and not for others. theres no obvious
pattern?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354

Extracting out of a emai address string
 

spot on Andy, worked like a charm.

Not compulsory, any chance you can explain whats going on in the
formula?

I understand the Mid, but the rest, i didn't know it was possible.

Cheers.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354

Extracting out of a emai address string
 

Hi

=MID(A2,SEARCH("@",A2)+1,SEARCH(".",A2,SEARCH("@", A2))-SEARCH("@",A2)-1)

The MID function uses 'cell', followed by 'start address', followed by
'number of characters to return'.
The 'cell' is A2.
The 'start address' is 'find the position of @ and add 1'.
The 'number of characters' is 'find the position of . after the @'

Hope this helps! It may be useful for you to use a very simple example and
then select each part of the formula in the formula bar and press F9 to view
its results.

Andy.

"harpscardiff"
wrote in message
news:harpscardiff.2957ap_1149869404.5548@excelforu m-nospam.com...

spot on Andy, worked like a charm.

Not compulsory, any chance you can explain whats going on in the
formula?

I understand the Mid, but the rest, i didn't know it was possible.

Cheers.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=550354