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