Forum Discussion
Excel is reading data differently with spaces vs without spaces
I have sheet 1 that is reading data from sheet 2 (the data includes spaces), but for some reason when I delete the spaces on Sheet 1 it pulls different data from sheet 2. Here is the formula I'm usi...
ChrisMendoza How do I do that with my vlookup formula?
I was thinking below, but have not tested. I was really just showing a method to remove " " (spaces) in a string.
VLOOKUP(SUBSTITUTE($A3, " ", ""),Sheet1!$A2:$T$18748,9)