Working with text using the functions LEFT, RIGHT and MID
The LEFT, RIGHT and MID functions are extremely powerful and can save you hours of …
Linda
Fixing “blank” cells in Excel that have something in them (i.e. clearing zero-length strings)
I was recently asked about an issue where a cell would appear empty, but for …
How to create an interactive invoice in Excel using Data Validation and VLOOKUP
Goal? To automatically populate information in a document, e.g. an address field in an invoice …
Different Functions for Rounding in Excel
I couldn’t find a decent article outlining the differences between the various rounding functions in Excel… so I …
