How to Separate an email address
 

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 and returns no.com

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


Thanks,
Bert

How to Separate an email address
 

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

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

--
Don Guillett
SalesAid Software

"Bert Kinney" wrote in message
...
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 and returns no.com

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


Thanks,
Bert

How to Separate an email address
 

So close...

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

Add 1
--
HTH...

Jim Thomlinson


"Bert Kinney" wrote:

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 and returns no.com

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


Thanks,
Bert

How to Separate an email address
 

Thank you Don and Jim, that worked perfectly.

--
Regards,
Bert Kinney MS-MVP Shell/User
http://bertk.mvps.org


Jim Thomlinson wrote:
So close...

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

Add 1

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 and returns no.com

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


Thanks,
Bert