Now that I’ve talked about how to keep references from being relative, and the sort of tricks that allows you to do, I’m going to talk about a fun little trick that relative formulas let you do quickly and easily:… Read moreIncremental formulas

A few weeks ago, when I was talking about switching the locations of two sets of cells, I mentioned the importance of using cut instead of copy, because unless you specified otherwise references in spreadsheets are relative.

miIf you go into the “Date & Time” category in the function selection menu of any spreadsheet program you’ll find a lot of options, but there’s only a few I use on a regular basis. These functions are consistent over… Read moreFunctions for dates and times

Now that I’ve discussed the text functions len() and find(), it’s time to get back to how to convert numerical text to numbers. Example 1: Stripping characters off the ends (e.g. $ and %). If you have a piece of… Read moreChanging variable-format text to numbers