Incidentally in the US when placing the surname first we would
normally place a comma and space after the surname, to show that
the order is different.

D2: =B2 & ", " & LEFT(C2, 1)

"Lance" wrote in reply to J.E. McGimpsey...
You are a Legend .. Thank you very much ; )