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     www.energyefficientbuild.com.    Nov 26, 2012
user Jesper Hasteen said:(https://productforums.google.com/forum/#!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.