Recent posts

Create Sheets From Cell Values

2 minute read

This is one of my favourites and I use it all the time. Type a bunch of sheet names in a list of cells, select those cells then run this macro.

Word Count From Cells

less than 1 minute read

There’s no built in way to count the number of words in Excel, but using the following formulas will get it done.

Extract Nth Word From A String

less than 1 minute read

If you need to get the nth word in a text string (i.e. a sentence, phrase, or paragraph) you can so with a clever (and intimidating) formula that combines 5 ...