⛏️ Extract or Remove Numbers or Text from a Cell (Google Sheets) @SheetsNinja

Uploaded October 2025 | Updated September 2026, 1 week ago

Ever have a cell containing both text and numbers and need to extract or remove one or the other? I walk through several sample scenarios in this video to give you a good foundation to start using regex to level up your Google Sheets game.

If you're struggling with making this work for your scenario, try asking ChatGPT or Gemini for the regex expression that will work for what you're trying to do.

Documentation:
Quick Guide: support.google.com/a/answer/1371415?hl=en
Full Documentation: github.com/google/re2/blob/main/doc/syntax.txt

⛏️ Extract or Remove Numbers or Text from a Cell (Google Sheets)

Effortlessly Transfer Excel File Data into Google Sheets with Apps Script

How to Add Checkboxes #googlesheets #shorts

➤ Automatically Share File with Google Form Respondents

Autofill or Copy Formulas Down in Google Sheets Mobile App

6 Pranks in Google Sheets to Drive Your Coworkers or Friends Nuts

Highlight Search Result Rows from Text (Google Sheets)

How to Add Placeholders in Google Sheets Tables

$How to Create a Slack Webhook and Post from Apps Script In todays video, Ill show you how to create a webhook in Slack so you can post messages to Slack from Google Apps Script. ***SLACK LINKS*** Create a new app: https://api.slack.com/apps Message Formatting: https://docs.slack.dev/messaging/formatting-message-text Block Kit Builder: https://app.slack.com/block-kit-builder ***** Sample Google Apps Script to Post Message to Slack ***** function sendMessageToSlack() { let webhookURL = WEBHOOK_URL; let name = Sheets Ninja; let body = { blocks: [ { type: section, text: { type: mrkdwn, text: `Hey, Slack!nnThis is a test message.nnThanks ${name} for your contributions!` } } ] } let params = { method: POST, content-type: application/json, payload: JSON.stringify(body) } UrlFetchApp.fetch(webhookURL, params); }$

▼ Easily Add DROPDOWNS from a Range (Google Sheets)