Formulas > =SUBSTITUTE()
How To Use SUBSTITUTE() Function in Google Sheets
Description
How To Actually Use SUBSTITUTE() in Sheets
<pre>SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])</pre>
13 Better Sheets Tutorials
SubSpyHub Subreddit Scanner
I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.
ISBLANK()
IF()
HYPERLINK()
SUBSTITUTE()
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.
SUBSTITUTE()
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!
SUBSTITUTE()
IF()
ISBLANK()
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.
FIND()
SUBSTITUTE()
IFERROR()
SPLIT()
INDEX()
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!
SUBSTITUTE()
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
SUBSTITUTE()
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.
SUBSTITUTE()
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
IF()
ISBLANK()
SUBSTITUTE()
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
SUBSTITUTE()
IF()
SWITCH()
ISBLANK()
CONCATENATE()
+2 more
Get Twitter Handles Easily by changing URLS to @
Change Urls to @ using Substitute()
SUBSTITUTE()
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.
SUBSTITUTE()
JOIN()
Build Your Own AI Writer in Google Sheets
Create your own AI writer with these google sheets tips and tricks and code.
SUBSTITUTE()
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.
SUBSTITUTE()
ENCODEURL()
FILTER()
IFNA()
Learn more about the SUBSTITUTE() formula:
Count text characters in a string
Google Sheets use Len and Substitute to count comma separated elements in a cell.
Generate a SUBSTITUTE() formula for your needs with AI
Google Sheets Formula Generator
Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.
Asa
Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.