How to Fix WhatsApp Number Errors in Google Sheets

0:00 I've shown you before how to create a WhatsApp number link in your spreadsheet . We're going to use https: wa. me slash the number . But if you're copying and pasting WhatsApp numbers into Google Sheets like this, you have this like plus one, you're going to end up with this. I'm going to show you how to fix this error very quickly. So we're going to select these errors, which are all the numbers and they've added this equal sign because in Google Sheets with a plus sign, it thinks you're doing math, but we're not. We're just, we have a phone number . So we're going to do command F and we're going to click these three buttons here. We're going to make sure we have our selected range . Okay. Specific range selected. And we're going to put an equal sign and a plus sign here. And we're going to replace it with nothing.

0:45 Make sure you also search within formulas, because unfortunately these will all turn into formulas and not just text. Click Replace All . And now, You will see these are all the regular numbers without that plus sign. But you'll still have some errors with these spaces and hyphens. So let's get rid of those as well. So select those as well. Command F again and click the three more options. We want to take this hyphen, replace it with nothing, also search for the informals just in case, click replace all , and then the final thing we want to do is add a space here and find, make sure replace all is not a space, it's nothing, and click replace all and we now have done, we have our whatsapp links available, our errors are all fixed, these are the real numbers, these are numbers

1:30 with the country code and whatsapp rules. It'll work with them totally fine. If you're looking to get more out of your Google sheets than you ever have before, consider subscribing here on YouTube to better sheets.