Extracting numbers out of a cell in Excel

[EddyBronxe]

Hello,
I have list of customer numbers (please see the attached sample of data I have). These numbers contain 'numbers' as well 'text'. Is there a way to use some kind of formula that will automatically remove the text from the cells and will give me the 'only' number part of the cell.

Very much appreciate your help in advance,
Thank you!

 

[XOR LX]

Hi.

It doesn't appear that your attachment is visible. Perhaps you could give a few example strings in the post?

Regards

 

[Rick Rothstein]

Hello,
I have list of customer numbers (please see the attached sample of data I have). These numbers contain 'numbers' as well 'text'. Is there a way to use some kind of formula that will automatically remove the text from the cells and will give me the 'only' number part of the cell.

Very much appreciate your help in advance,
Thank you!

Your picture did not come through. Why don't you just paste some representative samples of your text and indicate the number you want returned from them.