You can remove your all your alphabet character in Google Sheets by using this formula:
=REGEXREPLACE(A4,"[A-z]","")
my explanation
REGEXREPLACE = the function that provided by Google Sheets library (it doesn't exist in Microsoft Excel)
A4 = your cell that contain paragraph you want to remove the alphabet
"[A-z]" = will find regular expression that meet this criteria, the criteria is find all character between A (uppercase) until z (lowercase)
"" = replacing the regular expression with nothing, or delete it.
0 Response to "How to Remove Alphabet Character in Google Sheets"
Posting Komentar