How can I get first letter and last name together

[muzzy]

If I have this? Please Help

	A	B	C
1	Last Name	First Name	What I Need
2	Santiago	Ann	Asantiago
3	Schuster	Mario	Mschuster
4	Singh	Tommy	Tsingh
5	Taylor	Sam	Staylor

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[NeonRedSharpie]

=left(b2,1)&lower(a2)

 

[muzzy]

Sorry How can I do the same thing just with 4 letters go into the last name like (ASANT)

 

[Special-K99]

=left(b1,1)&left(a1,4)