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...