Forum Discussion
Solved
edit cells to add trailing space
I have numbers in column. In order for the VLOOKUP to work, there needs to be a space at then end of the numbers in the column. Since I am working with 5k lines of data, individually updating them is not reasonable. Is there a way to bulk update to add a space at the end of multiple cells.
So the lookup value has a trailing space but the first column of the lookup range does not?
If that is correct:
Let's say your formula looks like =VLOOKUP(B2, lookup_range, 2, FALSE)
You can change that to =VLOOKUP(--B2, lookup_range, 2, FALSE)
That should take care of the trailing space...
4 Replies
It might be possible to avoid that, please tell us more about the setup and what you want to look up.