Tips & Tricks 202 – Remove Alphabets from a String

To remove alphabets from a string, for a single cell

=CONCAT(TEXTSPLIT(A2,CHAR(SEQUENCE(26,,97)),,,1))

Using REGEX

=REGEXREPLACE(A2, "[a-zA-Z]", "")

To remove alphabets from entire range

=BYROW(A2:A10, LAMBDA(a, CONCAT(TEXTSPLIT(a,CHAR(SEQUENCE(26,,97)),,,1))))

using REGEX

=REGEXREPLACE(A2:A10, "[a-zA-Z]", "")

The Excel file for this tips can be downloaded from Tips & Tricks 202 – Remove Text from a String