SOLVED

Separate first and last name from a field.

Contributor

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.

3 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 User

 

 

best response confirmed by ADumith (Contributor)
Solution

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 yes you're quite right, my mistake.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)