Regextract formula to extract numbers

[pto160]

I have Excel 365. They just added the REGEXTRACT formula to my Excel. I am using the formula to extract numbers. Is there a way to extract all numbers from a text string, not just the first group of numbers?

Book1
	A	B	C
1		What I am getting	What I like
2	456ER	456	456
3	123ER98Z8	123	123988
4	ZC45RT3A1	45	4531
Sheet1

Cell Formulas
Range	Formula
B2:B4	B2	=REGEXEXTRACT(A2,"\d+")

 

[ExcelToDAX]

How about:

=TEXTJOIN("",TRUE,TEXTSPLIT(REGEXREPLACE(A2, "[^\d]+", "|"), "|"))

 

[Fluff]

Another option

=CONCAT(REGEXEXTRACT(A3,"\d+",1))

 

[pto160]

Thank you so much everyone. These formulas work great.

 

[Fluff]

Glad we could help & thank for the feedback.

 

[Peter_SSs]

A single function option

=REGEXREPLACE(A2,"\D",)

 

[pto160]

Thank you so much Peter_SSs. This works great. This will save me a lot of time.

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.