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

If this post helps click Yes
---------------
Jacob Skaria


"Sean NWIC" wrote:

How can I make them all Capital letters?


"Jacob Skaria" wrote:

Try

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

If this post helps click Yes
---------------
Jacob Skaria


"Sean NWIC" wrote:

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? :-)