Display characters present after a specific character

[srikanth7]

Hi,

Can anybody help me how to get this done. I want excel to display
characters when after a specified point. Like I have a huge list of
email addresses and I want to display domain names on the next cell.
Excel should display the characters present after @ symbol.

 

[Ragdyer]

Try this:

=RIGHT(A1,LEN(A1)-FIND("@",A1))

 

[Srikanth]

Thank you very much. It worked perfect!!

 

[Ragdyer]

You're welcome, and thanks for the feed-back.