Forum Discussion
Remove Letters
Looking for a formula to remove the letters from this string (leaving the X). Number of digits and spaces will vary. CYL TM DUMP 10.5 X 4.5 X 60SPC ...
Exactly as previous, just more straightforward
=REDUCE(
"",
MID(A1, SEQUENCE(LEN(A1)), 1),
LAMBDA(a,v, a & IF(OR(v = {"0","1","2","3","4","5","6","7","8","9",".","X"}), v, ""))
)
is this in excel? there appears to be a few spaces between some of the characters.