QA Tips – Separate first name and last name in a CSV file

  1. Open the CSV file.
  2. Create two new columns for the First Name and Last Name.
  3. For the First Name, use the formula =LEFT(A1,FIND(” “,A1,1)-1).
  4. Replace A1 with the cell where the Contact Name is located.
  5. For the Last Name, use the formula =RIGHT(A1,LEN(A1)-FIND(” “,A1,1)).
  6. Replace A1 with the cell where the Contact Name is located.
  7. Save the CSV file.

Leave a comment

Your email address will not be published. Required fields are marked *