How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Need help with a =mid function in Excel Here is the function

This answer was rated:

Need help with a =mid function in Excel

Here is the function that I am working on:

{=MATCH(TRUE,ISNUMBER(1*MID(H3,ROW($1:$12),1)),0)}

The problem that I am having is that right now the ROW($1:$12) is fixed - but I need the second number (in the above example $12) to be copied from a cell.

When I try to do this, the formula is rejected by Excel.

For instance, if the number I need for the Row is in cell F3, I need the formula to pull the number from that cell, as the number of rows is a function of the number of characters in the string

so what I am trying is:

{=MATCH(TRUE,ISNUMBER(1*MID(H3,ROW($1:$(=f3),1)),0)}

where $12 is replaced by $(=f3).

Make sense?

I am using this function in order to extract the numbers only from a string.

In the above example, this is the string, which has 12 characters:

Other-/20621

So I need it to return = 8

but the next string could be 15 characters and so on.........

the string will always end with numbers - just do not know how many - could be between 4 - 7

Can you help - is there another function to do this?

PS: What I originally started with was a URL from ebay and what I am trying to pull from the URL is the category number - here is original URL:

http://www.ebay.com/sch/Other-/20621/i.html

Hi,

 

This array formula uses the value in F3 as the last row in the range

 

=MATCH(TRUE,ISNUMBER(1*MID(H3,ROW(INDIRECT("$1:"&F3)),1)),0)

 

Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

 

John D and other Microsoft Office Specialists are ready to help you