XLookup Returning Values for Alpha and Special Characters but not Numbers

I created a table with numbers, alpha, and special characters. When I run the XLookup function, it only returns the values for the alpha and special characters.

I ran a MID function to separate the characters from a string and then wanted to reference the table against each character to return a value. When I do the XLookup on the table without the MID function, it does work.

What am I missing in the MID function that only the numbers won't work?