All,
I am having big problems removing spaces.
I have copied a HTML table into excel. a typical cell might contain a number and spaces infront and behind it.
E.G Cell A1 contains " 10000 ", 8 characters (2 spaces)
I used the TRIM command and it does not work as the cell A1 still contains 8 characters instead of 5.
Note the numbers are stored in General format.
Any ideas?
David32
Try the CLEAN() Function also
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
One common problem copying from html to Excel is the prevalence of non-breaking spaces in html. These are ascii character 160 and they are, unfortunately, not removed by the CLEAN function. Try a Find/Replace on your worksheet (select A1 then hit Ctrl+H) and in the Find What box hold down your Alt key and from the numeric keypad type 0160. This should insert the character 160. Leave the Replace With box empty and hit Replace All to remove all of these characters from your sheet.
Richard
Richard Schollar
Microsoft MVP - Excel
Some of us create a tiny macro:
and pin it to Ctrl+Shift+H (i.e. "looks like" Ctrl+H)
Sub Clear_Spaces() Selection.Replace " ", "" End Sub
For just such irritations...
found answer elsewhere, sorry for post
Last edited by wombleuk; 03-17-2014 at 10:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks