UpSheets Support Center

Contact Us

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

UpSheets gives you the option to either load:

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))