excel-university.com
VLOOKUP Hack #8: Extra Spaces
Here’s a VLOOKUP question for you: What happens when the lookup value includes extra spaces? For example, a few trailing spaces, or leading spaces, or, extra spaces in the middle of the text …