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