Clean Excel Data With TRIM and SUBSTITUTE « Contextures Blog
You have two Excel lists, and you’re trying to find the items that are in both lists. You know there are matching items, but your VLOOKUP formulas can’t find them. ... If TRIM function alone doesn’t solve the problem, you can try adding the SUBSTITUTE fun...