Splitting text to columns in Excel

For the best skip trace results, first and last names should be in separate columns. If your list has the full name in one column, you can split it in a few clicks.

Resources

→ Microsoft - Split text into different columns with the Convert Text to Columns Wizard

→ How To Use Lead Sherpa's Integrated Skip Tracing Tool

Steps

1. Make sure there's an empty column to the right of the column you want to split.
2. Click the heading of the column with the full names to select it.
3. Click Data → Text to Columns.
4. Choose Delimited and click Next.
5. Check Space, uncheck Tab, and click Next.
6. Click Finish, then OK.
7. Add a heading for the new column (for example, Last Name), then skip trace the file.

Questions? Email support@leadsherpa.com.

To see us do it, watch this YouTube video.