In this video, I'm going to show you a really easy automation trick that's going to 10x your output. Really, uh, this is going to help you write text in Google Sheets, but at an incredible rate. So, it's very similar to what I've done with Sheet Lord. This is a site where you can enter one keyword, Google Sheets, or let's say digital marketing, and you see all of these URLs changed. So, all of these URLs are looking at this one B2. And I want to show you how this can be used multiple ways. So right here, we're going to write email subjects. 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. So we can say digital marketing is our topic, and we want to write some email subjects that have some text. So what we're going to do is

something very simple is equal sign. And then whatever cell we're referencing here, we're using B1. We're going to use an amperand and we're going to add a quote and then a space and do with this one simple trick. And now end quote and hit enter. Now I can do this again equals but I can put the text in the front. One simple trick for add a space question uh quote and then amperand is sort of like concatenating or combining text B1. And so now I have two different subject or two different text, right?

And these are email subject variations but using exactly the same cell. So now I can change this to better Google Sheets with one simple trick. One simple trick for better Google Sheets, we can add another equal sign here. B1 amperand in quotes space in 7 days or less equals B1 amperand without spending a dime equals B1 amperand quote without any effort. Or let's just do this one effortlessly there and see. So we can write any sort of length in this B1 and it can be added. So more customers from digital

marketing with this one simple trick, one simple trick for more customers from digital marketing, right? So we can see the variations here. So we're writing all of these variations based on this one exact cell. And I think this is a really cool automation or optimization and really amazing use of Google Sheets if you've never done this before. If you've never done a formula before, we're just adding equal sign. We're adding B1 amperand using AI. And of course, we're not using AI. We're just using some simple B1 amperand while you sleep. That's pretty cool. more better tension rate while you sleep using AI effortlessly. Right? So now we're adding really cool things. We can add B1

ampersand maybe some emojis. Secret revealed equals B1 ampersand faster. Ooh, that's cool. And even if we have nothing here, we have all of the examples here. We could put a little fun thing here as equals if now if B1 is blank enter something we'll put a quote 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. Yeah, there we go. Okay. And now that message disappears. So little bit of extra here if formula for you. And now we have all

of these awesome, awesome email subjects. Cool. I hope you enjoyed that one. You're watching Better Sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how-tos, get more out of your Google Sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is going to be your next Google sheet.