extract numbers

[ahhhmed]

How can we extract numbers from cells that contain both text and numbers and put the numbers in separate cell?

 

[oldchippy]

Hi ahhhmed,


Try searching for "Extract numbers from text" in the search box top right, you will find a number of examples

 

[Deepanshu Bhalla]

Assuming a value is entered in cell A1 Try the formula below in cell B1

=SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*ROW(INDIRECT("1:"&LEN(A1))),0),ROW(INDIRECT("1:"&LEN(A1))))+1,1)*10^ROW(INDIRECT("1:"&LEN(A1)))/10)

 

[Luke M]

Following oldchippy's advice, there's an article here:

http://chandoo.org/wp/2012/06/19/extract-numbers-from-text-excel/