Hi,
I could use some help with extracting two different set of numbers from a cell that contains both numbers and text. Not sure if this helps but the number on the right will have 1-6 digits, the number on the left will have a minimum will have a minimum of 3 digits with no maximum. I attached a spreadsheet of the data and the two columns that will display the result of extracting the two numbers.
This site kind of acknowledges cells with more than one number but doesn't necessarily show how to extract either number: http://chandoo.org/wp/2012/06/19/ext...om-text-excel/
Bookmarks