Excel 2016 or newer

=TEXTJOIN(“”,TRUE,IFERROR((MID(A2,ROW(INDIRECT(“1:”&LEN(A2))),1)*1),””))

Then copy that column to a new column – selecting values only

Then note the error/note talking about numbers stored as text, and fix that.

 

REF: https://trumpexcel.com/extract-numbers-from-string-excel/#Extract-Numbers-from-String-in-Excel-Formula-for-Excel-2016