Ah, concatenate. How I love you! I use you for proofreading. I use you to generate statistics. I use you to write code. I use you to enable easy sorting. And, of course, I use you for formatting text. As… Read moreSpecific functions: Concatenate

Sooner or later, if you have a long string of text, you might want to actually do something with it. There are all sorts of things that can be done with a string of text! But if you go browsing… Read moreFavorite functions: Text manipulation

So what happens if the brief descriptions in the list of possible functions isn’t enough? Most spreadsheets provide some sort of additional description and/or help file to, in theory, help someone use their functions. These help files are usually very… Read moreFunctions: Help files

So, now that you know about functions, how do you use them? First off, if you already know the name of the function, and what parameters it takes, you can just type it in the same way you’d type in… Read moreFunctions: Finding the one you want

Functions are one of the big things that separate a spreadsheet from a paper ledger. I mean, you can do arithmetic functions on a piece of paper pretty easily. You can use highlighters or different pens to change the “format”… Read moreFunctions