Removing ' from cells

Khari Shiver
Khari Shiver ✭✭✭✭✭
edited 11/07/22 in Formulas and Functions


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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!