Extract Number

[ekhawaja]

Hello!

Looking for a formula that only pulls out number values from the cell:

Have	Want
06356A	6356​
00388A	388​
00791A	791​
03732a	3732​
E20074	20074​
00717A	717​
SES2357	2357​

 

[Fluff]

How about

Fluff.xlsm
	A	B
1	Have	Want
2	06356A	6356
3	00388A	388
4	00791A	791
5	03732a	3732
6	E20074	20074
7	00717A	717
8	SES2357	2357
Data

Cell Formulas
Range	Formula
B2:B8	B2	=--TEXTSPLIT(A2,CHAR(SEQUENCE(26,,65)),,1,1)

 

[alansidman]

An alternative with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Have", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Numbers", each Text.Select([Have],{"0".."9"})),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Have"})
in
    #"Removed Columns"