software

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

Ex.
TRIM to:

itpnet.com=mid(A1,find(quot;@quot;,A1) 1,255)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;XLquot; gt; wrote in message oups.com...
gt; I need Help trimming all the words before the the @ sing in a email
gt; address
gt;
gt; Ex.
gt;
gt;
gt;
gt; TRIM to:
gt;
gt; itpnet.com
gt;
Thanks Bob that workedData / 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 :-)
------------------------------*------------------------------*----------------quot;XLquot; gt; wrote in message oups.com...
gt;I need Help trimming all the words before the the @ sing in a email
gt; address
gt;
gt; Ex.
gt;
gt;
gt;
gt; TRIM to:
gt;
gt; itpnet.com
gt;
I have one more Trim I need to do with the imported email address.

I need to trim of the gt; at the end of each email address

ex. gt; TO Thanks

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

I need to trim of the gt; at the end of each email address

ex. gt; TO Thanks

XLOn 10 Mar 2006 07:29:18 -0800, quot;XLquot; gt; wrote:

gt;I have one more Trim I need to do with the imported email address.
gt;
gt;I need to trim of the gt; at the end of each email address
gt;
gt;ex. gt; TO
gt;
gt;
gt;Thanks
gt;
gt;XL=LEFT(A1,LEN(A1)-1)

Rgds
Richard Buttrey
__

Edit / Replace

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

quot;XLquot; gt; wrote in message ups.com...
gt;I have one more Trim I need to do with the imported email address.
gt;
gt; I need to trim of the gt; at the end of each email address
gt;
gt; ex. gt; TO
gt;
gt;
gt; Thanks
gt;
gt; XL
gt;