Mid and isnumber

Discussion in 'Excel' started by annbc, Aug 26, 2013.

  1. annbc

    annbc

    Joined:
    Aug 26, 2013
    Messages:
    4
    Likes Received:
    0
    Any ideas what is wrong with this formula =1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$10),1)),0),COUNT(1*MID(A1,ROW($1:$10),1)))

    This is in column A ~00085965233~

    I need to extract only the true number 85965233
     
    annbc, Aug 26, 2013
    #1
    1. Advertisements

  2. annbc

    annbc

    Joined:
    Aug 26, 2013
    Messages:
    4
    Likes Received:
    0
    Thanks for all your help using the function (Mid, right and left) will work.
    However my problem is that my string of numbers in column A: will not always be the same at times it could be 12 digits or 8 or 6. I don't want to have to keep changing the formula line by line that is why I need to use "true"
     
    annbc, Aug 26, 2013
    #2
    1. Advertisements

  3. annbc

    Luck

    Joined:
    Dec 28, 2017
    Messages:
    8
    Likes Received:
    1
    =MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$10),1)),0),COUNT(1*MID(A1,ROW($1:$10),1)))ctrl,shift,enter
     
    Luck, Dec 28, 2017
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.