I am trying to vlookup 2 sheets but because some of the cell have extra space
hence formula isnt working. I tried to eliminate the space by data €“ text €“
delimited €“ check space, but the cell is types as eg USA €“ Mobile, USA €“
Landline etc, and the above text function will also separate the USA and €“
and mobile & landline.....
Any advise? Thanks