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.
------------------------------------------------------------------
following is a solution to a bit more generalized problem in that the proposed solution will remove most extraneous characters such as space ~ # * etc.
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.
No comments:
Post a Comment