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
------------------------------------------------------------
No comments:
Post a Comment