Can I upload Full Name instead of First / Last Name?

Question

Accepted Answer

UpSheets gives you the option to either load:

First Name and Last Name; or
Full Name

If you have a full name field in your spreadsheet that you wish to split into columns, you can use the Text to Columns feature in Excel or a formula as below to separate the Full Name into First/Last.

These formulas would split the value "Mary Smith" in cell A2 into "Mary" and "Smith". You can place them in new columns and copy them down to apply to all of your data.

First Name: =LEFT(A2,FIND(" ",A2,1)-1)

Last Name: =RIGHT(A2,LEN(A2)-FIND(" ",A2,1))

Related questions