Excel can be really useful if you apply the correct formula to the correct data set.
One of the great functions in Excel is LEN. One of its many uses I find is creating the right title and meta descriptions that meet search engines’ character counts.
Let’s say that Google allows 70 characters for your Title and 155 characters for your description.
We can use Excel to count exactly how many characters we are typing and warn us if we go over that limit. How ool is that?.
In the following formula I have used the IF and the LEN formula to get Excel to warn me if the number of characters is too long, and if it is under the threshold of the number of characters to count how many characters I have typed.
Let’s take a look.
The logic of the formula is –
If the length of D3 is greater than 70 characters then return “Too Long”, if it is not over 70 characters return the number of characters typed. The formula is repeated with the threshold of characters set at 155 for the page description.
Job done. A useful tool for SEO- Or has many others uses- what would you this formula for?.
Let me know in the comments below….
Want to Learn More Formulas?
Join the Excel Formulas Crash Course. If you want to learn SUMIFS, SUMPRODUCT, OFFSET and 40 other day to day formulas, then consider Chandoo’s Excel Formula Crash Course.
It has 31 lessons split in to 6 modules and makes you awesome in Excel formulas.