TRIM formula
 

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

Ex.



TRIM to:

itpnet.com

TRIM formula
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"XL" wrote in message
oups.com...
I need Help trimming all the words before the the @ sing in a email
address

Ex.



TRIM to:

itpnet.com

TRIM formula
 

Thanks Bob that worked

TRIM formula
 

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" wrote in message
oups.com...
I need Help trimming all the words before the the @ sing in a email
address

Ex.



TRIM to:

itpnet.com

TRIM formula
 

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. TO


Thanks

XL

TRIM formula
 

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. TO


Thanks

XL

TRIM formula
 

On 10 Mar 2006 07:29:18 -0800, "XL" wrote:

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. TO


Thanks

XL


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

Rgds
Richard Buttrey
__

TRIM formula
 

Edit / Replace

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

"XL" wrote in message
ups.com...
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. TO


Thanks

XL