Splitting domain from Email Addresses

[That Excel Guy]

Hi - Trying to cleanup some free form user company name entries by using the domain off the user's email address to build a lookup list & standardize the company name.

Does anyone know how you would write a formula to extra the domain from an email address?

All I really want to do is delete all before the @ character.

 

[Richard Schollar]

Try:

=REPLACE(A1,1,FIND("@",A1),"")

 

[Willem!]

Hi,

Try

strDomain = Split(strEmail, "@")(1)

(source; to extract the first part of a string change the (1) to (0) )

HTH

Edit: well... Richard's idea is even simpler....

 

[ravishankar]

Hi
If D5 has the email ID, try this formula
=MID(D5,FIND("@",D5,1)+1,100)
Ravi

 

[That Excel Guy]

I knew you guys wouldn't let me down!

Thanks Richard - worked like a charm!