Using LEFT Function with Countif



I receive a data from other parties that is formatted inconsistently. The column of interest is labeled Target Months and ranges from things like "36 Mo.", "12 mo" and "1Mo" etc. I am only interested in the number since I know it is referring to months. Using the LEFT function I can strip out the 36 and 12, however doing operations such as trying to add the cells results in "3612" instead of 48.

They are being treated as text and I need them treated as a number. How can I ensure they are treated as numbers?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!