Hi need help with email and text

[Django Cell]

Hi everyone,

I hate to just ask for help right off the bat, but this thing I am trying to accomplish is a bit frustrating. I really enjoy the youtube videos on excel and I hope I get some relief! Thanks.

My Q:

I have like 300 email addresses on spreadsheet. I would like to create a formula on another sheet where I can just pull the domain names of the emails and not the whole text.

e.g.

johnsmith@yahoo.com
JamesSmith@mac.com
tomsmith@cnn.com


I would like to pull just the "@yahoo.com" and every other email domain name. I am not quite sure how to do this. Is there a formula to strip the information starting from "@" character and ending at the last text character?

Help!


Thank you

 

[circledchicken]

Hi,

Try the following:

• =RIGHT(A1,LEN(A1)-SEARCH("@",A1,1)+1)
• =MID(A1,SEARCH("@",A1,1),LEN(A1)-SEARCH("@",A1,1)+1)

 

[Ruddles]

Welcome to the forum!

Don't be worried about asking for help - I think most people find this forum because they need help and it's probably the best and friendliest place to start. I'm sure you'll bookmark it and come back, and then maybe you'll be able to pass the favour on to someone else who needs it.

 

[Django Cell]

Hi,

Try the following:

• =RIGHT(A1,LEN(A1)-SEARCH("@",A1,1)+1)
• =MID(A1,SEARCH("@",A1,1),LEN(A1)-SEARCH("@",A1,1)+1)

Thank you. Thank you. Thank you!
It worked. Thanks for the welcome. I will come back and try to add and help when I can.