How to extract only numbers from text.(Microsoft Excel)

Japanese version.

This section shows how to extract only numbers from a mixed string of numbers and non-numbers.

TextResult
A-00050005
1234-XXXX_567812345678
Contents

Procedure

The CONCAT, MAP, MAKEARRAY, LEN, LAMBDA MID, IFERROR, and NUMBERVALUE functions are used in the formulas.

=CONCAT(MAP(MAKEARRAY(1,LEN(text),LAMBDA(row,col,MID(text,col,1))),LAMBDA(v,IFERROR(NUMBERVALUE(v),""))))

---

Tips(Microsoft Excel)