Using LEFT Function with Countif
Hello,
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?
Tags:
Best Answer

If you put the Left function inside a Value function the it will convert the text to a number.
Answers

If you put the Left function inside a Value function the it will convert the text to a number.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!