Convert Last, First Name to First Last Name

Zee Cheok

I have a contact list of Last Name, First Name; i.e. Doe, John. I would like to create a helper column with First Name Last Name; i.e. John Doe. Is there a formula to do that?

Thanks in advance!

Danielle Arteaga

Hi, Zee. Someone may have a more elegant solution, but here's what I suggest:

Name is the column with your current data.

In the "Last Name" column, you want this formula: =LEFT(Name@row, FIND(",", Name@row - 1)

In the "First Name" column, you want this formula: = RIGHT(Name@row, LEN(Name@row) - FIND(",", Name@row))

Then, in the "Full Name" column, you want this formula: =[First Name]@row + " " + [Last Name]@row (make sure there is a space between your open and closed quotation marks)

Danielle Arteaga

Hi, Zee. Someone may have a more elegant solution, but here's what I suggest:

Name is the column with your current data.

In the "Last Name" column, you want this formula: =LEFT(Name@row, FIND(",", Name@row - 1)

In the "First Name" column, you want this formula: = RIGHT(Name@row, LEN(Name@row) - FIND(",", Name@row))

Then, in the "Full Name" column, you want this formula: =[First Name]@row + " " + [Last Name]@row (make sure there is a space between your open and closed quotation marks)

Zee Cheok

This works! Thank you much!