Results 1 to 5 of 5

Extract numbers from a the left and to the right of a string

Threaded View

T86157 Extract numbers from a the... 01-08-2017, 09:06 PM
T86157 Re: Extract numbers from a... 01-08-2017, 09:11 PM
Tony Valko Re: Extract numbers from a... 01-08-2017, 09:19 PM
T86157 Re: Extract numbers from a... 01-08-2017, 09:51 PM
Tony Valko Re: Extract numbers from a... 01-09-2017, 10:38 AM
  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Extract numbers from a the left and to the right of a string

    Hi,

    I could use some help with extracting two different set of numbers from a cell that contains both numbers and text. Not sure if this helps but the number on the right will have 1-6 digits, the number on the left will have a minimum will have a minimum of 3 digits with no maximum. I attached a spreadsheet of the data and the two columns that will display the result of extracting the two numbers.

    This site kind of acknowledges cells with more than one number but doesn't necessarily show how to extract either number: http://chandoo.org/wp/2012/06/19/ext...om-text-excel/
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Is there a formula that will extract the numbers to the left of the cell
    By benji1973 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2015, 10:11 AM
  2. [SOLVED] Extract numbers only from string
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2015, 06:43 AM
  3. How to extract numbers from a string
    By Ian99099 in forum Excel General
    Replies: 4
    Last Post: 02-28-2015, 11:22 AM
  4. Extract numbers from a string
    By keepers123 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-17-2013, 09:02 AM
  5. [SOLVED] Sum numbers left of a character from within a string
    By BarryTSL in forum Excel General
    Replies: 14
    Last Post: 04-17-2012, 01:11 PM
  6. Extract Data to right and left of numbers
    By chl in forum Excel General
    Replies: 1
    Last Post: 03-18-2010, 02:19 PM
  7. extract numbers with specific text from right or left
    By darkhangelsk in forum Excel General
    Replies: 2
    Last Post: 08-15-2009, 02:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1