Thx for the reply, full name does not always have the middle initial.

"Teethless mama" wrote:

Assuming full names always included middle initial, then try this:

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


"Talladega" wrote:

Hi,

I have hundreds of cell containing full names starting with their first
name. I need a formula to display Last Name, First name and Middle Initial.
Ex: Johnny K. Walker should be Walker, Johnny K.

Thxs,