How To Split Text in Microsoft Excel

There's nothing worse and no bigger headache than when you receive an excel spreadsheet full of contact information and find that contact names are entered in one column. It makes mail merges an absolute NIGHTMARE!

In this PA Pages tutorial video, we show you how to use a simple formula to split text into separate columns so that you can clean it up and ensure names are always right.