It’s common to receive mailing lists spreadsheets where the format of the name column is a full name with first and last name together in one cell, e.g. [Thomas Smith]. Our Batch Search tool requires name to be broken up into two columns of First Name and Last Name.

Here is tutorial on how you can separate full names into columns using Microsoft Excel spreadsheet formulas.

Sample Spreadsheet With Formulas
I’ve created a sample spreadsheet you can download and use for you list. The formulas are already applied to the spreadsheet columns.
Download Spreadsheet »

To use this method you will need:

  • Microsoft Excel