Unable to remove the "space" at the end of text in a cell
I've tried using Trim and also Text to Columns. Some cells in the food column have spaces at the end of the text and I can't figure out how to remove them. Trim and Text to Columns will remove some, but strangely not all of them. Any suggestions? I'm actually using this as a .csv file which excelforum will not permit me to upload but I've saved it here as an xlsx which seems to have the same issue.
Thank you
The space is a non-breaking space, CHAR(160).
one way to remove it using a help column
Or use CTRL+H
Please Login or Register to view this content.
enter ALT+0160 via numeric keypad
replace with nothing.
That is space with char(160). To remove automatically, use Find And Replace (Ctrl-H)
* First, at one cellthat contains space, press F2
* Hold shift, left arrow, Ctrl-C (Copy the space), Esc
* Ctrl-H
Find what: press Ctrl-V (past the space)
Replace with: Leave blank (type nothing)
Replace All
Hope this help!
Highlight the column
Quang PT
Duplicate post!!!!
Wow -- you guys rock. I used the first solution which works perfectly. Thank you, sincerely!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks