Remove Non Numbers

Google Sheets: Remove Non‑Numbers/Non‑Alphanumerics with REGEXREPLACE + ARRAYFORMULA FORMULA: =REGEXREPLACE(A1, "[^a-zA-Z0-9]", "") This episode shows how to clean text in Google Sheets by removing all non-letter and non-number characters using REGEXREPLACE. It explains the differences between regex functions (MATCH, EXTRACT, REPLACE) and then builds a REGEXREPLACE formula that targets anything not in the ranges a–z, A–Z, or 0–9 using a caret inside square brackets, replacing matches with an empty string (""), and notes that the source cells may need to be formatted as plain text. It also highlights that the method removes punctuation like decimal points, which can affect currency values. Finally, it demonstrates wrapping the formula in ARRAYFORMULA to process an entire column at once (e.g., B3:B) with a single formula. 00:00 Why Clean Non Numbers 00:45 Regex Tools Overview 01:12 Build Regexreplace Pattern 02:33 Replace With Nothing 03:10 Fix Formatting Gotchas 03:22 Currency And Label Caveats 04:02 Arrayformula For Whole Column 04:38 Wrap Up And Subscribe