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.
