Separate first and last name from a field.

%3CLINGO-SUB%20id%3D%22lingo-sub-3544952%22%20slang%3D%22en-US%22%3ESeparate%20first%20and%20last%20name%20from%20a%20field.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544952%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20column%20called%20%3CSTRONG%3EFullName%3C%2FSTRONG%3E%2C%20so%26nbsp%3BI'm%20need%20to%20separate%20the%20first%20and%20last%20names%20into%20separate%20columns.%20How%20can%20I%20do%20that%20in%20SharePoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3544952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3545497%22%20slang%3D%22en-US%22%3ERe%3A%20Separate%20first%20and%20last%20name%20from%20a%20field.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3545497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1244439%22%20target%3D%22_blank%22%3E%40ADumith%3C%2FA%3E%26nbsp%3Byou%20won't%20be%20able%20to%20do%20this%20just%20in%20SharePoint%2C%20you'll%20need%20to%20use%20a%20flow%20in%20Power%20Automate%20to%20do%20this%20with%20a%20couple%20of%20split%20expressions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

1 Reply

@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