How do I separate first name and last name using Excel? (Power Surveys)

In Excel, you can separate First Name and Last Name using the Left, Right, and Find functions on your CSV file.

Example

I want to upload a CSV file with separate First Name and Last Name so I can pipe this information on my study rather than using the full Name.

Detailed Steps

On your CSV file containing the full name you can use the Left function, Right function and Find function to spit a full name to the first name and last name:

1. Enter this formula 2 cells to the right of the full name  =LEFT(A1,FIND(" ",A1,1)-1) to create the column for the first name.
   
   
   
   Note: In this example you must leave an empty column for the AlternateID as this sample export did not have any information in that field.
    
2. Enter the formula  =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))  in another blank cell to the right, in the image example it would be D1.
    
3. Copy your formula to the rest of the cells in those two columns by selecting the cells C1:D1, and click the Home tab, then click on the Fill button and select Down. 

This will then give two separate columns with first and last names.

Note: Your columns should always be in order: Name, Alternate ID, then the extra information you are adding (in this case it was first name and then last name)

More Information

Read this article to learn more about Export Data.