Results 1 to 12 of 12

Version Incompatibility for a Number Extraction Formula?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2020
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    176

    Version Incompatibility for a Number Extraction Formula?

    I have a formula that will extract the only the first consecutive string of numbers in an alphanumeric string. Here is what the data in the cells I am referencing looks like:
    7 MPH (28.0%)

    Here is the formula I am using to extract only the numbers before the MPH (in this case, 7):
    =LEFT([@[OVER LIMIT]],MATCH(FALSE,ISNUMBER(--MID([@[OVER LIMIT]],ROW($1:$94),1)),0)-1)
    In Excel 2019, this works perfectly. The problem is that I have Excel 2013 at work, and it just gives me a "#N/A" error. It doesn't make any sense to me because the LEFT, MATCH, and ISNUMBER all exist in Excel 2013. Does anyone have any idea why this may be failing to work in an older version of Excel? If it's any help, I incorporated this formula into a macro, which works perfectly in Excel 2019, but when I run it in Excel 2013, I get "Run-Time Error '438': Object doesn't support this property or method", and the line with the formula above is highlighted when debugging.

    Any help is much appreciated!
    Last edited by applehugger; 08-23-2021 at 11:56 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Names Extraction Version 2?
    By wedzmer in forum Excel General
    Replies: 3
    Last Post: 02-01-2019, 03:46 AM
  2. Formulas not working in higher version, 2010 Version to 2013 version
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2015, 09:09 PM
  3. number extraction
    By suhabthan in forum Excel General
    Replies: 5
    Last Post: 06-10-2015, 06:45 AM
  4. [SOLVED] Base Number Extraction
    By jr_smith in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-30-2012, 10:53 AM
  5. Number Extraction
    By armansoor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2011, 04:03 PM
  6. Replies: 1
    Last Post: 03-01-2008, 11:05 PM
  7. Version Incompatibility
    By JUnk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 11:05 AM

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