Use

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) &", " & LEFT(A1,1)

This assumes only one space inbetween first and last name.

--
If this helps, please remember to click yes.


"sross002" wrote:

I have a full name in A1 but I want it to read as: Full Last Name, First
Name Initial.

For example, I would like to convert John Appleseed (a1) to Appleseed, J

Thank You in advance.