Reformatting Names

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!

Welcome to the community, @Arthur_Jones1! :smiley: 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

1 Like

This worked great thank you Justin!!!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.