Hi All,
I have an excel sheet consists of company name. I am trying to use " Text to Column" in excel. I want them to split based on the " space." I am unable to get the proper result. I had done all the possibility. Please check the attachment file.
Thanks & Regards
M. Sathish Kumar
I am wrong, again.
Please try with the attachment excel.
I found the issue. Invisible character 160 is between the cells. In B2, put =substitute(a2,char(160)," "), copy downwards.
Then copy the result, paste values over your original text, and Text to Columns with a space delimiter.
Alternatively, you can select the space out of the original text and paste that single space into the delimiter of Text to Columns. (It's not a normal space)
Last edited by daffodil11; 08-22-2013 at 05:36 PM.
Sometime if can't do the "Text to Column" due to this kind of problem.
You can try copy the "SPACE", paste in to other option and choose both space and other.
It can solve it easily.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks