Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to devide a text in to two culemns. for instance:
A B C
______________ ______ ________
510100 Fix salary 510100 Fix salary
Hossein Ali Hossein Ali

Is there any way (formula, macro,...) to make this?
Thanks,
Hossein
 
Is the first field always everything before the first space character and the
second character everything after the first space character:

=trim(left(a1,search(" ",a1)-1))
and
=trim(mid(a1,search(" ",a1)+1,255))
(make that 255 big enough to handle the biggest string)
 
Back
Top