Okay, try this:

=IF(LEN(C2)=2,C2&"Z",LEFT(C2,3))&LEFT(A2,1)

assuming you have a header row so that your data begins in row 2.

Hope this helps.

Pete

On Jul 25, 1:21*am, Darlie Mary
wrote:

The entire last name is in Column C and the first name is in Column A.- Hide quoted text -

- Show quoted text -