TRIM formula

[XL]

I need Help trimming all the words before the the @ sing in a email
address

Ex.

(e-mail address removed)

TRIM to:

itpnet.com

 

[Bob Phillips]

=mid(A1,find("@",A1)+1,255)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[XL]

Thanks Bob that worked

 

[Ken Wright]

Data / Text To Columns / Delimited / Tick other and put an @ in the box -
Hit Next a couple of times, select the firts column and choose 'Do Not
import'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[XL]

I have one more Trim I need to do with the imported email address.

I need to trim of the > at the end of each email address

ex. (e-mail address removed)> TO (e-mail address removed)


Thanks

XL

 

[XL]

I have one more Trim I need to do with the imported email address.

I need to trim of the > at the end of each email address

ex. (e-mail address removed)> TO (e-mail address removed)


Thanks

XL

 

[Richard Buttrey]

I have one more Trim I need to do with the imported email address.

I need to trim of the > at the end of each email address

ex. (e-mail address removed)> TO (e-mail address removed)


Thanks

XL

=LEFT(A1,LEN(A1)-1)

Rgds
Richard Buttrey
__

 

[Ken Wright]

Edit / Replace

Regards
Ken.................