Excel 2003 - How to extract domain names frm email

Hi,

I got a list of customers emails and would like to extract their domain names frm the email list.

If I'm gonna used the RIGHT function, the result wouldn't be correct since different domains have diff chars length.

Example as follows:-

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

==> How do I extract the domain name after the @.

Your help is highly appreciated. tq.

=MID(A1, FIND("@", A1) + 1, 255)

Hi bebas78,

The following formula will do the job (just change the starting reference from A2 to suit):

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

HTH

Robert