Tuesday, September 4, 2012

yogi_ Extract Into Column C Only Numbers From Srings In Column A Corrupted With Other Superfluous Characters

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #732   Sep 04, 2012     www.energyefficientbuild.com.

user meph2u said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/wpLgBqwMfNE)
Getting rid of letters
I am getting data from an external source that should be numeric but sometimes has one or two letters (or spaces) at the beginning, in the middle or the end such as:
A889

8B26
89I22_
B82A6
7C2_2Q
6789Z
Is there any way to get rid of the letter and spaces and leave the remaining numbers in number format?
--------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem