Extract first name

jgneely72151

How do I extract the first name if the Name field lists the name as Last, First order?

SSFeatures

Hi @jgneely72151, try this formula:

=RIGHT(Name@row, LEN(Name@row) - FIND(",", Name@row))

It looks for a comma, and then returns the contents from the right side of the comma.

Hope this helps!

jgneely72151

This was very helpful but my list is a little more complicated than just last name, first name.

Many of the names in the list has multiple names following the comma and what's happening is that your formula is extracting everything following the comma. This is great but honestly, what I'm after is the reversal of the last name, first name to just first name last name. Is that doable?

Here are some examples of what's in my list:

last, first middle

last, first middle1 middle 2

I'm so sorry for not be clear.