combining two cells

[Michelle]

I have a list of names (one column of first names, and one
column of last names). I want to get the initials for the person.

For example:

A B
John Doe

A2=JD

 

[Gary''s Student]

=LEFT(A1,1) & LEFT(B1,1)

 

[Teethless mama]

=LEFT(A2)&LEFT(B2)

 

[Michelle]

Thank you very much. This was exactly what I was looking for.