How to Separate an email address

[Bert Kinney]

Hi,


I have found a formula to separate an email address but would like it to
leave the @

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

For example, this formula takes (e-mail address removed) and returns no.com

Is there a way to make it return @no.com


Thanks,
Bert

 

[Don Guillett]

try
=RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1)

 

[Guest]

So close...

=RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1)

Add 1

 

[Bert Kinney]

Thank you Don and Jim, that worked perfectly.