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?

Find more posts tagged with

Formulas

Accepted answers

RossL

@Dean Arvan

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

All comments

RossL

@Dean Arvan

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.