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)

Hossein wrote:

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

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



"Hossein" wrote:

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