Formulas > =SUBSTITUTE()
How to Use SUBSTITUTE() in Google Sheets
Description
How To Actually Use SUBSTITUTE() in Sheets
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Try SUBSTITUTE yourself
In the range A1:A10, replace the word 'apple' with 'orange' in each cell. Your formula should be placed in cell B1 and dragged down to B10.
Hints (2)
-
Remember to reference the correct cell in your formula.
-
Use double quotes for the text you want to replace.
Better Sheets Tutorial
Get Twitter Handles Easily by changing URLS to @
Change Urls to @ using Substitute()
How to Add YouTube Thumbnails
Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey
Embed a Headline in a Website from Google Sheets
One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!
1 Simple Formula to Make Writing Tweets Easier or Make $1,000
Create a hook writing sheet with SUBSTITUTE(). Create an engine to write tweet upon tweet upon tweet. Bundle up 100 hooks/formats and sell it. Go ahead, make sweet tweets in a sweet sheet.
Build a Better ChatGPT Prompt Builder
In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.
NEW TOOL Parse Spintax for Content Spinning
Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.
Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need.
Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need.
- Spin randomly to get one variation
- Spin text for all variations
- Spin text for all variations including duplicates
Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.
Run 100 ChatGPTs at One Time
Create a ChatGPT prompt inside a sheet, edit that prompt with a single input 100 times over. In this case we're creating a twitter thread prompt and replacing the topic 100 times. so you can use 1 prompt to run 100 ai calls, and then we go further
We make it better.
We add a checkbox and another prompt to take the output of the 1st prompt and run it again. And we can do that 100 times too. So each horizontal row can be it's own ChatGPT.
You can get the ai Apps Script in this video's sheet or in the sheet connected to the GPT-4 upgrade: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4
We make it better.
We add a checkbox and another prompt to take the output of the 1st prompt and run it again. And we can do that 100 times too. So each horizontal row can be it's own ChatGPT.
You can get the ai Apps Script in this video's sheet or in the sheet connected to the GPT-4 upgrade: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4
Create a ChatGPT Cheat Sheet Spreadsheet
Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.
Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script
Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script
One Weird Google Sheet Formula for Bulk Publishing With AI
'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!
Build Your Own AI Writer in Google Sheets
Create your own AI writer with these google sheets tips and tricks and code.
SubSpyHub Subreddit Scanner
I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.
SearchLord: One Sheet to Search Them All
I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord
In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.
In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.
More related tutorials
Transcript-matched member videos for SUBSTITUTE(). Click through to watch.
Write Apps Script to Create a New Google Sheets Formula
Add Title Case to Google Sheets
Learn Google Sheet Formulas The Hard Way
Learn more about the SUBSTITUTE() formula:
Generate a SUBSTITUTE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SUBSTITUTE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SUBSTITUTE() formula