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
t4hwmd
e6qa80
Just desire to say your article is as astonishing. The clarity to your post is simply nice and that i can think you are knowledgeable in this subject. Fine with your permission let me to grab your RSS feed to stay updated with imminent post. Thank you 1,000,000 and please continue the gratifying work.
s4xc0n