Ask Experts Questions for FREE Help !
Ask
    Annhelpmehomewk's Avatar
    Annhelpmehomewk Posts: 5, Reputation: 1
    New Member
     
    #1

    Aug 25, 2013, 03:01 PM
    spreadsheets
    I am having with this marco what is wrong with this formula in excel
    ~00120457879~ =1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$8), 1)),0),COUNT(1*MID(A1,ROW($1:$8),1)))

    I need to extract the number in between the two symbols
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Aug 25, 2013, 03:32 PM
    First, that doesn't appear to be a macro, just a formula.

    Second is that all in one cell? Is all you need to do is extract a number from between the tildes in another cell?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Aug 26, 2013, 03:50 PM
    This is the formula I use for that:

    =LOOKUP(99^99,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&123456789 0)),ROW(A$1:INDEX(A:A,LEN($A1)))))


    This will extract the first numeric string it finds within the long string found in A1. In your string, it effectively pulls out the number.

    you'll need to format the cell with this formula to display numbers as 11-digits since once it is converted to a real number, the leading zeros will disappear.
    Annhelpmehomewk's Avatar
    Annhelpmehomewk Posts: 5, Reputation: 1
    New Member
     
    #4

    Sep 15, 2013, 01:04 PM
    Thanks but I manage to get my macro to work... thanks again
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #5

    Sep 15, 2013, 01:52 PM
    Quote Originally Posted by Annhelpmehomewk View Post
    Thanks but I manage to get my macro to work.... thanks again
    There is a difference between a macro and a formula. You need to learn what that difference is.
    Annhelpmehomewk's Avatar
    Annhelpmehomewk Posts: 5, Reputation: 1
    New Member
     
    #6

    Sep 15, 2013, 09:36 PM
    Quote Originally Posted by ScottGem View Post
    There is a difference between a macro and a formula. You need to learn what that difference is.
    True

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Linking two spreadsheets in Sharepoint [ 2 Answers ]

We have two spreadsheets in Sharepoint. They are maintained by two different people. We would like to incorporate the second spreadsheet as a worksheet in the first spreadsheet and link to the second spreadsheet. THe goal is to make sure that the changes in the second worksheet/spreadsheet to...

Printing works spreadsheets [ 1 Answers ]

How do I get rid of the numerical list and the alphabetical list on the side and top of the spread sheet when I print it

Can anyone tell me if Iwork spreadsheets is better than Microsoft spreadsheets? [ 1 Answers ]

I've been using Microsoft spreadsheets for a long time now but I'm trying to find a better program and one with more formulas. I heard about a program called Iworks but was wondering it anyone has used this program to find out if it is any better than Microsoft.

Do spreadsheets talk? [ 1 Answers ]

What are the steps that a spreadsheet uses to communicate with other spreadsheets?

Viewing spreadsheets in different views [ 7 Answers ]

I am an intermediate level MS Excel user. I often use my spreadsheet and would like to see different views at the click of a button. By this, lets say I have columns A through Z. I know I can manually MOVE, say columns C, G, L, and P to be the first 4 columns, into position A,B,C,D. And I can...


View more questions Search