extract numbers from string

[adamasmay]

I want to extract numbers from string.

Example tyouy890ty --> I want output = 890

Please guide me about it.

[cytop]

A very common request, with just as many ways to do it - VBA or Formulas.

For example: https://www.educba.com/extract-number-from-string/

Or look at the 'Similar Threads' list below

[CheeseSandwich]

I have the below saved as my preferable way to do it without having to add any references to the VBE:

Please Login or Register  to view this content.

The above will include characters like: *+,-./

If you wanted to remove those '*+,-./' then you could use

Please Login or Register  to view this content.

The below is a reference as to what characters are being kept/ removed:
https://docs.microsoft.com/en-us/off...acter-set-0127

[kvsrinivasamurthy]

If Textjoin function is available
ARRAY formula
=TEXTJOIN("",TRUE,IF(ISNUMBER(FIND(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"0123456789")),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),""))