Hi Jason,

How about a spreadsheet formula like:

IF(AND(LEN(A1)0,LEN(B1)0),LEFT(A1,1)&B1,"")

Just copy it down for more cells than you are ever likely to have and you
will see the merged name appearing as soon as you enter data in cols A and
B.