Excell attendance with vlookup

[tkingaz]

I have a spreadsheet that I am trying to remove the first and last character when a student slides their card to check in to my office. when scanned it get this %11568?. I want to see 11568 and have vlookup look up the 11568 and put the student name in. This code is in B column, that reads the A column of "%11568? ,
B column =IF(A6="","",IF(LEN(A6)>6,VALUE(LEFT(A6,LEN(A6)-1)),A6)) returns %11568?
C column =IF(B5="","",VLOOKUP(B5,'Name list'!$A$2:$B$889,2,FALSE)) returns N/A

 

[AhoyNC]

Try this to return the number.
This will return a number, if your student number is formatted as text and not numeric it will return N/A. If you are looking up text then change formula to:

=IF(A6="","",MID(A6,2,LEN(A6)-2))

Excel Workbook
	A	B
6	%11568?	11568
Sheet