Forum Discussion

bofus's avatar
bofus
Copper Contributor
May 12, 2023

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                                                ...
excel
Patrick2788's avatar
Patrick2788
Silver Contributor
May 12, 2023

bofus 

A 365 solution:

=LET(
    n, LEN(A1),
    arr, MID(A1, SEQUENCE(n), 1),
    REDUCE("", arr, LAMBDA(a, v, a & IF(OR(v = "x", v = " ", v = ".", ISNUMBER(v * 1)), v, "")))
)

Resources