Excel 2003

[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

 

[Dave Peterson]

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)

 

[Guest]

Another option - splitting text to columns:
http://office.microsoft.com/en-us/excel/HA011498511033.aspx