Forum Discussion
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.
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,
4 Replies
ADumith you won't be able to do this just in SharePoint, you'll need to use a flow in Power Automate to do this with a couple of split expressions.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserHello @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,- 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]))
