Ever wanted to know how to count the characters in a cell, or combine the text in two cells in Excel? What about how to identify duplicates in Excel? Whether for a content creation project or planning a holiday, Excel is my best friend. Even when you’re working with words, ways of measuring the details can be very helpful in ensuring a set of content is exact. Here are the formulas and shortcuts I regularly use and find useful (produced in an Excel spreadsheet, of course):
Useful Excel Formulas* and Tips**
*The cell references such as “B3” refer to the cell you want to analyse and should be changed accordingly.
**Most of these work in any version of Excel; the instructions are specific to Excel 2007.
I’m a linguaholic; I’m obsessed with language and linguistics. I love working with words and producing perfection. My other passions are cooking, kickboxing and my family, so you may see them appear in one form or another here.