Given a column of cells each with text in the format:

LAST NAME, FIRST NAME

..... like "Jones, Bob" and "Johnson, David", is there a quick excel
function/method that will convert and then write them to a different
column such that:

(first initial)(last

.... so "Jones, Bob" becomes " and "Johnson, David"
becomes "?

TIA