Hi all,
I have a a column with data. Some of the cells are visually numbers in a text format, like 4 684,252. Others are values. Usually i use replace under Find & Select. Find " " and replace with "". That dosent work in this file and i cant figure out why. Anybody who has a solution? The file contains about 25 K of rows so it canīt be done manually.
Really hope someone can help me with this.
/Masun
go to your first blank one (row 13) and copy that space using ctrl c, then past that into the find and leave the replace blank. Then hit replace all and that should do it for you.
Last edited by Sam Capricci; 03-16-2015 at 08:32 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
You can use formula to remove spaces
=--SUBSTITUTE(A2," ","")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you guys. It worked fine!
/Masun
Thank you for you feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks