The problem I'm having is i'm converting data, and my data has random spaces after it which TRIM() does get rid of. However, once it's trimmed, I need to use VLOOKUP to convert the data to a numerical value for the new database, however it doesn't seem to work. Is there another way to do this?