Skip to main content
Solved

Reformatting Names

Forum|alt.badge.img+5

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!

Best answer by Justin_Barrett

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

View original
This topic has been closed for replies.

2 replies

Justin_Barrett
Forum|alt.badge.img+21

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

    Forum|alt.badge.img+5

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


    This worked great thank you Justin!!!

      Terms & ConditionsAccessibility statement