View Single Post
  #2   Report Post  
Springbok
 
Posts: n/a
Default

Hi,

Assume appears in A1. In B1 I would insert the
following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1))

Cheers,
Jon

"David M" wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,

is the existing data and I want to create a new column with just the msn.com
string.