I need to do a right function up to the @ symbol in an email

[Jeffrey Green]

Somebody@Company.com
Bill@CompanyB.com

I need to pull the characters from the right until the @ symbol
so I am left with Company.com, CompanyB.com

Thanks

 

[lwilt]

just use InstrRev for the @ symbol to find where it occurs and then a MID function to pull out what you need.

 

[JazzSP8]

Hi

Try

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

HTH

 

[Jeffrey Green]

thanks but ???
lol

 

[SteveO59L]

=right(a1,len(a1)-find("@",a1))