Trying to match the first six characters of a text string to text characters
in a data table. I'm trying to use the VLOOKUP Function, but I keep getting
the contents of the second to last cell in my designated column. I'm having
a problem both with truncating the text string, and also using text to search
for things. Anyway to convert similar text characters to unique numbers?
Looking for any suggestions