How to extract digits from a string that contains numbers and text (+ convert them to values)

Here are some samples - all I want are the digits in a new cell and for those digits to be values:

170, 191FF

47FF, 54FF

762SS, 22FF

751, 53FF +5d (but I don't want any number that has a "d" with it - "5d")

It's gets complicated if I use IF statements to look for every possible combination of letters that may appear. I'm wondering if an easier approach is to look numbers and extract them as values to a new cell.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

The challenge would be that even stripping the letters would still generate a text value due to the comma being there. You would need to parse each entry into its own column to be able to treat them as actual numbers (after stripping the letters).

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.