Here is my Equation

In Sheet 2, column 3, is First name: i would like for only the first
character of the name to come up
and for the column 2, for only the first four characters to show.

=VLOOKUP(R1,Sheet2!$A$2:$G$1138,3,FALSE)&"
"&VLOOKUP(R1,Sheet2!$A$2:$G$1138,2,FALSE)

Can you help me? :-)