Friday, July 6, 2012

yogi_Extract Numbers For Specified Parameters Embedded In A String

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #610   Jul 7, 2012

user HeyyKelly said:
How to separate numbers from test in Google spreadsheet??
Hello again, here's a mock spreadsheet I just made.  I want Columns D and E to be filled with the respective numbers shown in the text in Column C to make the information more readily readable and organized.  However, the lengths of the numbers aren't the same so I need help with finding a function than can extract this information instead of me doing a copy and paste. Hope this helps.  Thanks again