Excel 2003
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 |
Excel 2003
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 |
Excel 2003
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 |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com