Most of you are aware of how useful Excel is to store contact details.  A lot of email management software allows you to import information from an Excel spreadsheet, but it has to be in a certain format.

Let’s say that you have a table containing data that you’ve taken from Outlook and exported it into Excel.  You now want to transfer this data into Constant Contact (for example), but some of the columns have more than one field in them i.e. the first name and surname are together in the same column.  How do you separate them in one go, without having to do each one individually?

That’s where the Text to Columns button comes in – below is a quick video to show you how to use it 🙂

I would just like to point out that the names used in the above example were randomly generated from a name generator website and have nothing to do with me or OutofhoursAdmin (apart from the very first name of course) 🙂