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!
Bookmarks