My Sticky Gadget

Bajuyuli baju muslim anak perempuan

How to Remove Alphabet Character in Google Sheets

You can remove your all your alphabet character in Google Sheets by using this formula:


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