Last name, first initial

[smithkd]

I have cells that use the structure Last name, First name. I need a formula that will extract the last name, give a comma, and then the first initial. For example if the cell reads Smith, John; I want a formula to show Smith, J.

Thank you,

Kevin S

 

[Fluff]

Hi & welcome to MrExcel.
How about
=LEFT(A2,FIND(",",A2)+2)

 

[smithkd]

Hi & welcome to MrExcel.
How about
=LEFT(A2,FIND(",",A2)+2)

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.