Mixed Column of Text & Numbers - want to replace text with 'null', but keep numbers

[jase71ds]

I have a mixed alpha/num column.
I want to keep all numbers (which Power Query correctly identifies and places to the right of the cell).
All of the text (again, correctly identified as text, and therefore left justified) I want to replace with 'null'

NOTE. The text is extremely varied, so I can't just do a find and replace.

Any help is appreciated.
Thanks.
Jase.

 

[mole999]

maybe > https://www.mrexcel.com/forum/excel-questions/94820-istext-vba.html from 15 years ago

 

[jase71ds]

Thanks.
I figured out a hack-work-around. I have another column that has a number 1 in those same rows where text occurs, so I'm just filtering out the other columns one's. Probably a horrible hack, but it is working.

 

[mole999]

you could use =ISTEXT() or =ISNUMBER()

 

[sandy666]

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"raw", type number}}),
    #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"raw", null}})
in
    #"Replaced Errors"[/SIZE]

with formula:

=IFERROR(A1*1,"null")