Monday, November 26, 2012

yogi_Remove Extraneous Characters Such As Space ~ * # From Columns Of Numbers

                                          Google Spreadsheet   Post  #895

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Nov 26, 2012
user Jesper Hasteen said:(!category-topic/docs/spreadsheets/mgY5cx74-GA)
I'm importing information (just with copy/paste) from another program and they have written spaces in the numbers.
Google sheets doesn't recognize these as numbers because of the spaces, I tried removing them with find and replace all " " but that only removes spaces in words, not numbers.
Because I have so many of these numbers I can't do it manually so is there another way?

This is what the imported info looks like (obviously without dividing them into cells here):
Market Transaction 213 500 345.26 2 725 244 440.47
Transaction Tax -315 000.62 2 511 744 095.21

following is a solution to a bit more generalized problem in that the proposed solution will remove most extraneous characters such as space ~ # * etc.