Forum Discussion

Iron Contributor

Jun 23, 2022

Solved

Separate first and last name from a field.

Hello everyone, I have one column called FullName, so I'm need to separate the first and last names into separate columns. How can I do that in SharePoint? Thank you in advance.

SharePoint Online

ADumith
Jun 28, 2022
Hello @RobElliot ,
I am sorry to contradict you, but it is possible.
Here are the formulas for those who need them.

First Name
LEFT(FullName,FIND(" ",FullName)-1)

Last Name
RIGHT(FullName,LEN(FullName)-FIND(" ",FullName))

I hope it is helpful.

Have a good one,

ADumith

Iron Contributor

Jun 28, 2022

Hello @RobElliot ,
I am sorry to contradict you, but it is possible.
Here are the formulas for those who need them.

First Name
LEFT(FullName,FIND(" ",FullName)-1)

Last Name
RIGHT(FullName,LEN(FullName)-FIND(" ",FullName))

I hope it is helpful.

Have a good one,

JenGleason

Copper Contributor

Oct 03, 2024

I had to adjust slightly for sharepoint online but this worked:

First Name (=LEFT([Full Name], FIND(" ", [Full Name]) - 1)
Last Name (=RIGHT([Full Name], LEN([Full Name]) - FIND(" ", [Full Name]))