VLOOKUP and single Characters

[Sean NWIC]

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?

 

[Jacob Skaria]

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

 

[Sean NWIC]

How can I make them all Capital letters?

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

 

[Pete_UK]

Put UPPER( ... ) around the formula that Jacob gave you.

Hope this helps.

Pete

 

[Jacob Skaria]

=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