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