Return the part of the e-mail address after @

[Rosie]

I have a huge list of e-mail addresses in an excel
spreadsheet and I need to take the part of the e-mail
address after @ into a seperate cell

Eg: A1 contains '(e-mail address removed)', using a formula or
some other technique I need 'jblog.com' to appear in B1.

Hope someone can help!

 

[Andy Brown]

Rosie,

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

Or Data -- Text to Columns -- @ as separator.

Rgds,
Andy

 

[rosie]

Perfect thanks Andy, it worked a dream