hi all,
I am working on a task by using a simple vlookup but the cells seem to have an apostrophe before the works i am looking up and this is returning an N/A result for some of the cells.
what can i do to get rid of the apostrophe for the vlookup to work?
I am working on a task by using a simple vlookup but the cells seem to have an apostrophe before the works i am looking up and this is returning an N/A result for some of the cells.
what can i do to get rid of the apostrophe for the vlookup to work?