Create a simple automation for adding text to a cell of text. Really easy example is to create a lot of email subject lines from one single cell of text.
Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Sheet Resources
Featured Formulas
Video Transcript
<div>0:00 So in this video I'm going to show you a really easy automation trick that's going to 10x your output. Really, ah, this is going to help you write text in Google Sheets, but at an incredible rate.<br>0:12 So, it's very similar to what I've done with SheetLord.
This is a site where Learn how to filter data effectively with the WHERE clause in your queries. Opens in new tab you can enter one keyword, Google Sheets, or let's say digital marketing, and you see all of these URLs change.<br>0:24 So all of these URLs are looking at this one B2, and I want to show you how this can be used multiple ways.<br>0:31 So right here we're going to write email subjects, and we're going to write email subjects with one topic, but we're going to write a ton of email subjects all at the same time.<br>0:39 So we can say digital marketing is our topic, and we want to write some email subjects that have some text.<br>0:45 So, what we're going to do is something very simple, is equal.
And then whatever cell we're referencing here, we're using B1.<br>0:56 We're going to use an ampersand, and we're going to add a quote, and then a space, and do with this one simple trick.<br>1:08 And now, end quote, and hit enter. here. Now I can do this again, equals. But I can put the text in the front.<br>1:16 One simple trick for add a space, question, uh, quote, and then ampersand is sort Discover how to sort your data in Google Sheets for better organization. Opens in new tab of like concatenating or combining text, B1.<br>1:30 And so now I have two different subjects, or two different texts, right, and these are equal.
Email subject variations, but using exactly the same cell.<br>1:40 So now I can change this to better Google Sheets, with one simple trick, one simple trick for better Google Sheets.<br>1:49 We can add another equal sign here, b1 ampersand in quotes, space in seven digits. Seven days or less, equals b1 ampersand without spending a dime, equals b1 ampersand quote without any effort, or let's just.<br>2:24 Do this one effortlessly.
There, and see, so we can write any sort Discover how to sort your data in Google Sheets for better organization. Opens in new tab of length in this b1 and it can be added.<br>2:37 So more customers from digital marketing with this one simple trick, one simple trick for more customers from digital marketing, right?<br>2:48 So we can see the variations here. So we're writing all of these variations based on this one exact cell, and I think there's a really cool automation or optimization and a really amazing use of Google Sheets if you've never done this before, if you've never done a formula Understand the syntax rules to write formulas correctly in Google Sheets. Opens in new tab before.<br>3:06 We're just adding equal sign. We're adding b1 ampersand using AI.
And of course, we're not using AI. We're just using some simple b1 ampersand while you sleep.<br>3:28 That's pretty cool. More, better retention rate while you sleep using AI. Effortlessly, right? So now we're adding really cool things.<br>3:40 We can add b1 ampersand, maybe some emojis. Equals b1 ampersand.<br>4:05 Ooh, that's cool. And even if we have nothing here, we have all of the examples here.<br>4:36 We could put a little fun thing here as equals, if, now if b1, blank, enter something. We'll put a quote.<br>4:56 Enter something in b1.
So if we don't have anything here, we'll say enter something in b1. We'll add a emoji up.<br>5:08 Yeah, there we go. Okay, and now. That message disappears. So a little bit of extra here, if formula Understand the syntax rules to write formulas correctly in Google Sheets. Opens in new tab for you.<br>5:19 And now we have all of these awesome, awesome email subjects. Cool. Hope you enjoyed that one.</div>