In Part 1 of our Excel for sourcing series we showed you how to combine data into one column. Now let’s say you want to do this in reverse. You have a worksheet, export or research list full of names that looks like this with the full name in one column.
But you need them in separate columns in order to import into your database, do a mass mailing or print name tags for an event. If your anything like most people you create a new column and start typing or copy and pasting. However time is of the essence in sourcing and that is just a waste of it. So we’re going to use the “Text To Columns” function found under the Data tab in Excel.