Replace Numbers with Asterisks

Replace Numbers with asterisks Mask Digits in Google Sheets with REGEXREPLACE (and ARRAYFORMULA for Whole Columns) The script shows how to mask any digits (0–9) in Google Sheets text by replacing them with asterisks using the REGEXREPLACE formula. It explains that REGEXREPLACE needs three parts: the text to modify, a pattern in quotes to find what to replace, and the replacement character (such as "*") in quotes. The pattern used is "[0-9]" to match any single digit without listing each number. It also demonstrates customizing the replacement (e.g., multiple asterisks) and how to apply the masking to an entire column without copying down by wrapping the formula in ARRAYFORMULA and referencing a range like B3:B. 00:00 Mask Digits Overview 00:22 Regex Replace Basics 00:44 Build the Formula 01:11 Match Any Digit 01:41 Replace With Asterisks 01:58 Auto Fill With Arrayformula 02:46 Wrap Up And Subscribe