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

Hope this helps.

Pete

On Sep 2, 7:11*pm, 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? :-)- Hide quoted text -

- Show quoted text -