G
Guest
Guest
I am trying to do a simple comparison of data between two spreadsheets using vlookup. This formula works except in cases where the formatted cell contains a leading carrot (downloaded from another source). If I remove the carrot the vlookup formula works. I need an easy way to format the cells (over 1,000) without the carrot. I've tried everything I could think of. Any help would be greatly appreciated. Thanks.