Dear friends,
I know this should be easy, just use the find (space) and replace (no space). But it is not working for this particular file I'm using. I copied the data from HTML, so that might explain it. But I still don't know how to remove the space so that the data (in column A) becomes numbers and not text.
attached is a sample file.
Thanks in advance!
find and replace worked for me.
Just click in one of the cells and put your cursor beside a number, hold down shift and hit the right arrow key once, now copy that then open find and replace, paste that to the find what and leave replace empty, then hit replace all.
it might not be a standard keyboard space, that is why this will work.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
too late
Thanks Sam! It works!
You’re welcome, glad I could help. And thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks