Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Reformatting Names

Topic Labels: Formulas
Solved
217 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

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
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))
``````

2 Replies 2
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))
``````

4 - Data Explorer

This worked great thank you Justin!!!