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 [email protected] and returns no.com

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


Thanks,
Bert

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

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

--
Don Guillett
SalesAid Software
[email protected]
"Bert Kinney" <[email protected]> wrote in message
news:[email protected]...
> 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 [email protected] and returns no.com
>
> Is there a way to make it return @no.com
>
>
> Thanks,
> Bert
>
>
>

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 [email protected] and returns no.com
>
> Is there a way to make it return @no.com
>
>
> Thanks,
> Bert
>
>
>
>

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 [email protected] and returns no.com
>>
>> Is there a way to make it return @no.com
>>
>>
>> Thanks,
>> Bert