+ Reply to Thread
Results 1 to 4 of 4

Extracting Numbers from Text

Hybrid View

  1. 10-04-2013, 04:34 PM #1
    KCHCEXCELME
    KCHCEXCELME is offline
    Registered User
    Join Date
    10-04-2013
    Location
    Alpharetta, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Extracting Numbers from Text

    Hello,
    I have a task at work in which I am trying to pull basic unit of measure for a group of particular items. This is how it looks....

    True Stock Code PH09 - Product Format
    210 KV Neo/Pedi Std Elbow ET 20 ea/box
    1900 KV Neo/Pedi MAC Cath ET 5 ea/box
    34156 KMGD OneStepQC KC100SterilWrp480apps/pkg
    34173 KMGD OneStepQC KC300SterilWrp144apps/pkg
    34192 KMGD OneStepQC KC100SterilWrp480apps/pkg


    I would like to pull out just the numbers 20ea/box, 5e/box, 480apps/pkg and so on and so forth....
    Any idea on how this can be done in excel?
    Reply With QuoteRegister To Reply
  2. 10-04-2013, 05:16 PM #2
    tehneXus
    tehneXus is offline
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Extracting Numbers from Text

    Hi,

    please check the attached file for a VBA solution, start the macro with the button: GetNum.xlsm
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES
    Reply With QuoteRegister To Reply
  3. 10-07-2013, 01:29 PM #3
    KCHCEXCELME
    KCHCEXCELME is offline
    Registered User
    Join Date
    10-04-2013
    Location
    Alpharetta, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Extracting Numbers from Text

    BASE QUANTITY.xlsm

    Thanks, tehneXus for the help!
    Everything looks good however now the data has expanded a little more. I was trying to tinker with the Macro you created however, I was unsuccessful. I have attached the data sheet I am using. Is there anyway to split multiple columns up. For instances if you look at Column B and C on Tab labeled TEST. Is there anyway to take the last numbers(quantities) from the descriptions?
    Reply With QuoteRegister To Reply
  4. 10-09-2013, 11:38 AM #4
    tehneXus
    tehneXus is offline
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Extracting Numbers from Text

    like this? # BASE QUANTITY.xlsm #
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] extracting numbers from a string of text and numbers
    By ScottLor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2013, 04:47 PM
  2. Extracting numbers and text from inconsistent text/number formatted string
    By Brandivil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-25-2013, 01:46 PM
  3. [SOLVED] Extracting Numbers from text
    By hoventim in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-11-2012, 09:08 AM
  4. Extracting Numbers from Text and turning the numbers into rows of data
    By gregddd1 in forum Excel General
    Replies: 17
    Last Post: 03-03-2010, 06:55 PM
  5. Extracting numbers from text
    By bmind in forum Excel General
    Replies: 6
    Last Post: 02-23-2010, 11:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1