TRIM formula

  • Thread starter Thread starter XL
  • Start date Start date
X

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
 
=mid(A1,find("@",A1)+1,255)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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 :-)
------------------------------­------------------------------­----------------
 
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
 
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
 
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
Click to expand...


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

Rgds
Richard Buttrey
__
 
Back
Top