Extracting out of a emai address string

[harpscardiff]

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.

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

Andy.

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

[harpscardiff]

Thanks for the reply.

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

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

Andy.

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

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

Andy.

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

[harpscardiff]

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.

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