VLOOKUP and single Characters

  • Thread starter Thread starter Sean NWIC
  • Start date Start date
S

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? :-)
 
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
 
How can I make them all Capital letters?


Jacob Skaria said:
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
Click to expand...
 
=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
 
Back
Top