For a vlookup_value I concatenate a cell and text string. The lookup value becomes "Total ABC", LEN=9. The value from the array is "Total ABC", LEN=9. But comparing these 2 cells, they are not EXACT. How can I find the difference between the two so I can concatenate the correct lookup value?

Thanks,
Brad