Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Reformatting Names

Topic Labels: Formulas
Solved
Jump to Solution
1369 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Arthur_Jones1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi I’m looking for a formula to convert a field from First Name Last Name to Last, First. “Steve Smith” to Smith, Steve". I see a lot of people have ways to go the other way…

thanks!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Arthur_Jones1! :grinning_face_with_big_eyes: Here’s a formula that will do the job:

IF(Name, RIGHT(Name, LEN(Name) - FIND(" ", Name)) & ", " & LEFT(Name, FIND(" ", Name) - 1))

Screen Shot 2020-12-04 at 11.59.04 AM

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Arthur_Jones1! :grinning_face_with_big_eyes: Here’s a formula that will do the job:

IF(Name, RIGHT(Name, LEN(Name) - FIND(" ", Name)) & ", " & LEFT(Name, FIND(" ", Name) - 1))

Screen Shot 2020-12-04 at 11.59.04 AM

This worked great thank you Justin!!!