Using Excel To Take Apart and Consolidate Text

Using Excel To Take Apart and Consolidate Text

In this document, I discuss my fondness for spreadsheets, particularly Excel, and how I use it not for number crunching, but for text manipulation. I share how Excel can be a powerful tool for consolidating or splitting up text. I provide a detailed walkthrough on how to put text together using the ampersand (&) as a concatenation tool. Then, I demonstrate how to pull text apart using the Text To Columns tool. This tool is especially useful when you need to extract specific information from a chunk of text. I conclude by emphasizing that Excel is not just for numbers and can save you from having to manually retype text.
pareto housecleaning

Applying Pareto To Housecleaning

I've talked about the 80/20 principle before. Formally known as the Pareto principle, it says that 80% of the results will come from 20% of your effort. Today I want to apply this rule to housecleaning.
Recipe Cheat Sheet

My Recipe Cheat Sheet

I have a tendency to make the same recipes frequently. I know the steps to make the food, but not necessarily the exact proportions. Yes, I could look them up, but just having a list with my bare-bones information was all I really needed.
The Whys of Productivity: Writing Things Down

The Whys of Productivity: Writing Things Down

It doesn't matter which system you look at: Daytimer, Filofax, 7 Habits, GTD, Do It Tomorrow, Bullet Journal...every system insists that you write things down. Each system differs on how and where you should write them down, but they all want you to get it down on paper (or electrons).