February 26, 2019

5 Lesser-Known Excel Functions You Should Know About

5 Lesser-Known Excel Functions You Should Know About
This is not a post on how to use the CONCAT function or how to make a pivot table. There has been plenty written about those useful Excel features.

This post is about 8 functions that you might not know about because they don’t get as much attention in the PPC world.

They are just as useful as the CONCAT function depending on what you’re doing.

Let’s talk about how to use functions really quick before we jump into exact functions.

Excel Functions 101

Excel functions are preset formulas that allow you to quickly carry out a calculation or, in a lot of cases that I have outlined below, a change to text.

You start every function with an equals sign and the name of the function. Excel will outline the needed parameters after that.5 Lesser-Known Excel Functions You Should Know AboutIf you are interested in more about functions, check out this post which features a deep dive on functions.

1. TRIM Function

Have you ever needed to remove extra spaces in your text? Then the TRIM function is your answer.

I use this the most when I am removing the plus signs from broad match modified keywords. There seems to always be a pesky space at the beginning of the word. (I see this the most in data that I pull over from AdWords Editor.)

Use the Replace feature to remove the plus signs in the words.5 Lesser-Known Excel Functions You Should Know About5 Lesser-Known Excel Functions You Should Know About

Then enter =TRIM(your cell) in a new column and drag to apply to as many cells as needed.5 Lesser-Known Excel Functions You Should Know About5 Lesser-Known Excel Functions You Should Know About

You can see that the New Keywords column doesn’t have a space at the beginning of the cell.

You can also use this function to remove double spaces.

You’ll want to make sure you copy and paste the data as values only before continuing to manipulate the data.

2. PROPER Function

Do you ever need to capitalize every word in an ad? Don’t do it by hand, use the PROPER function!

Add a new column beside the data that you want to capitalize and apply the PROPER function.5 Lesser-Known Excel Functions You Should Know About

3. LOWER Function

When it comes to manipulating text in Excel, you definitely need to know about the LOWER function. This allows you to easily make all text lowercase.

You’ll want to make a new column beside existing data and make sure to copy/paste the values before doing anything else.5 Lesser-Known Excel Functions You Should Know About

4. UPPER Function

The opposite of the LOWER function is the UPPER function. This function will capitalize all of the text that you select.

5 Lesser-Known Excel Functions You Should Know About

5. EXACT Function

Have you ever had many cells of text that you needed to compare to one another? It would take hours to do this manually, and even then you might miss small details, but with the EXACT function, you can know if your text samples are exactly the same.

It’s easiest to compare side by side, but it’s not necessary if your sheet isn’t set up that way.

Enter the =EXACT function and select the two cells you want to compare.
5 Lesser-Known Excel Functions You Should Know About

The function will say FALSE unless everything is the same, including capitalization and punctuation.

Conclusion

Excel functions are a great way to quickly tweak text. Hopefully, these functions will be great additions to your Excel toolbox for tweaks to keywords and ad text.

If you’re interested in learning more about functions and features in Excel and how they can assist in day-to-day PPC work, we recommend these posts:

Did I forget one of your favorite lesser-known Excel functions? I’d love to hear what it is in the comments below!

 

5 Lesser-Known Excel Functions You Should Know About 5 Lesser-Known Excel Functions You Should Know About 5 Lesser-Known Excel Functions You Should Know About

Powered by WPeMatico

Get Free Site Analysis
Featured Services

What our customers say…

Click On Solutions
Reviewed from Google

5 out of 5 stars

Robert F. Martin
Robert F. Martin

5 out of 5 stars

posted 1 month ago

The guys at this company are stand up gentlemen. Their character has shown they are true to their words and will work with the skills they have to make the most out of your web development needs. They have been able to establish a brand worth working alongside. They have made great impressions on the internet, and will help your search engine optimization through their continued presence on the web. Their graphic skills and knowledge of back-end processes in different software give your company the knowledge needed to reach the audience you are seeking.

aleex dokem
aleex dokem

5 out of 5 stars

posted 2 months ago

They did a great job with my husbands' new site for his business; everything looks super clean, and it's a website that will last years vs. one that will end up looking outdated 18 months from now. The responsiveness of the site and the way that it flows looks awesome, and it's truly a great first impression for anyone coming to learn more about the business. Definitely recommend working

Antonia Montay
Antonia Montay

5 out of 5 stars

posted 2 months ago

Amazing work from these web and marketing geniuses! they built an incredible website and a powerful marketing campaign that took our business to the next level. Strongly recommend...they are driven and helpful!

AB Aaron
AB Aaron

5 out of 5 stars

posted 2 months ago

Because nothing seems too difficult for them to handle, and they do so with patience, an intrinsic understanding of how to make whatever work as well as it can, and with expedience!They bring expert creativity to their projects and can offer a myriad of suggestions to help us look the best we can, and to help our site functionality!

Benedict Robinson
Benedict Robinson

5 out of 5 stars

posted 1 week ago

They are experts!!! Very easy to deal with and we will continue to use them!Thanks guys!