|
For my reporting, I have to link two spreadsheets using vlookup based on customer names. Somehow when it is downloaded from system, one of the spreadsheets has got part of the customer names in a quotation mark while the other sheet hasn’t. This makes the vlookup ineffective. My question is: is there a quick way to remove the quotation mark as I have many line items and it is impractical to remove them manually. Thanks for your help. |
