Forum Discussion
why does my xlookup return a space at the front of the results - excel Win 10
I have done Xlookup and the result has come through correctly EXCEPT it has randomly placed a space at the front of the result. So i was expecting "VT19756-01-50-" but i got " VT19756-01-50-" ...
Well how bizarre i just accidentally worked it out - it was the format of the cell - it was on accounting and when i moved it to general all fixed lol
will Leave this up in case it randomly happens to someone else
will Leave this up in case it randomly happens to someone else
Peta_Stolle77 Thanks Pete, I have been trying to fix that same error for months and never noticed that the formatting was wrong. post found almost TWO years after you posted it.
