TRIM formula

B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
K

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 :)
------------------------------­------------------------------­----------------
 
Top