How to Remove Apostrophes in Front of Numbers?

Hi all,

My problem is SS has put in apostrophes in front of numbers after importing from excel. I have a column that is comprised of both text and numerical values. I've tried using a value function to remove the apostrophes. This works for the numerical values but shows errors on any cell containing text. Does anyone have advice for an IF statement I could use to both delete the apostrophes and keep the cells with text in them how they're supposed to be?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!