Monday, June 6, 2011

yogi_Extract Numerics From Strings Containing Text And More

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
p0490 said ...
Extract / truncate characters (more)
is there a general solution if the source data contains a decimal ?
the source data would be:
+30.9 mg
-20,8 F (comma replaces the decimal)
the output should be:
30.9
-20.8
------------------------------------------------------------