Using Excel To Take Apart and Consolidate Text


I deal with a lot of information, for my job, for my classes, and for Girl Scouts. When I get information in a form that is readable, but not quite usable, I have the option to re-type it…or I can put Excel on the task and let it do the work.

Most people assume that Excel, as a spreadsheet, is just for crunching numbers. Truth be told, I use Excel more for text manipulation than I ever do for numbers. Today I am going to show you how to put text together — and take it apart — using Excel.


Open Loops 4/3/2015


On Fridays I pull the best of my blog readings to share with readers. Topics can come from anywhere, and cover anything. This week I highlight articles on

  • Robert Fulghum’s take on Girl Scout cookies
  • A single question that can help you avoid impulse purchases
  • A guide to concise writing
  • Keeping collections from becoming clutter
  • Weight loss mythbusting
  • …and more!