i have a cell containing text like this
Ph(Off):* 5754112-5750441 ,* Cell:*0300-8406693*******,* Fax(Off):* 5712685*
ii want to seprate them into different cell though which every word or number contain his own cell
like
A1 = Ph(Off):* 5754112-5750441 ,* Cell:*0300-8406693*******,* Fax(Off):* 5712685
then i want it in this way
B1 C1 D1 E1 F1 G1
Ph(Off): 5754112-5750441 Cell: 0300-8406693 Fax(Off): 5712685
any solution ?
Text to Column
Seperator is ""
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello syedfahadjalali,
Try the attached WorkBook.
Also see the "Please consider" note at the bottom of this post.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks