Return the part of the e-mail address after @

R

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!
 
A

Andy Brown

Rosie,

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

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

Rgds,
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Excel - Wich Function should I use? 1
How do I do an e-mail mail merge using an Excel spreadsheet? 0
Remove e-mail address from general text field. 2
Index/Match Functions to Return Concatenated Response 4
Mail Merge query 1
Runtime error 2147467259 (80004005) method return address of object envelope failed 2
Can UDF return a customized hyperlink? 3

Top