Hello,

I imported an Excel spreadsheet containing a column of identification numbers that are 6 digits in length. When I tried to set up an index/match formula using the values in that column, I got a "no match" error. After a little research, I discovered there is a single quote at the beginning of each ID number. I've run into this in Excel when using text vs numbers. I need to remove the single quote but the replace function does not recognize the character. Any suggestions?

Thanks!