could someone provide me with a formula that will do a vlookup with a MID formula but where there are sometimes spaces.
MD9 Look this up ME1 with no spaces
so my VLOOKUP would be something like:
to return the number 123456
but where the cell has a space in this one: 'ME1 2'
MD9 Look this up ME1 2 with a space
It returns an error.
Thanks in advance