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
Thank you,
Kevin S