Results 1 to 9 of 9

Extract Numbers from String

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2016
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Extract Numbers from String

    So, I am trying to extract numbers from a Measurements column for product that we sell. I want to extract all numbers from the Left up until text starts and I want to extract all numbers from Right until text starts.

    I started with the following Formulas as follows:

    =LEFT(T2,LEN(T2)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},T2&"0123456789"))-1)
    &
    =RIGHT(T2,LEN(T2)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},T2&"0123456789"))-1)

    However, those formulas work for some fields & not for others. I have attached the file I have been working on.

    Any help would be greatly appreciated.
    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. [SOLVED] Extract numbers only from string
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2015, 06:43 AM
  2. How to extract numbers from a string
    By Ian99099 in forum Excel General
    Replies: 4
    Last Post: 02-28-2015, 11:22 AM
  3. Extract numbers from a string
    By keepers123 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-17-2013, 09:02 AM
  4. Extract numbers from a string
    By mkhan123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-03-2011, 03:22 PM
  5. Extract last 4 numbers from string
    By DarkBeer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2010, 11:16 AM
  6. Extract numbers from a string
    By andyiain in forum Excel General
    Replies: 6
    Last Post: 09-06-2006, 07:10 AM
  7. [SOLVED] Extract numbers from a string ?
    By Jello in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-03-2005, 07:06 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