
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 04, 2020 10:15 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 04, 2020 12:00 PM
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))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 04, 2020 12:00 PM
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))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 04, 2020 01:24 PM
This worked great thank you Justin!!!
