ExcelBanter - How to get the number from text?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get the number from text? (https://www.excelbanter.com/excel-worksheet-functions/219560-re-how-get-number-text.html)

Teethless mama

How to get the number from text?

=TEXT(LOOKUP(10^10,MID(A1,1,ROW(INDIRECT("1:"&LEN( A1))))+0),"000")

"JJ" wrote:

I have data as this format: 025BNN, 033WGN, I want to get only the numbers
from the text. how can i do that? thx.

All times are GMT +1. The time now is 04:06 AM.