Removing ' from cells

Khari Shiver

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!

Christian G.

IF you make a column with =VALUE([Imported data]@row) as formula, it willconvert the text to number.

you can then copy/paste that elsewhere

Christian G.

IF you make a column with =VALUE([Imported data]@row) as formula, it willconvert the text to number.

you can then copy/paste that elsewhere

Khari Shiver

Thank you!

Khari