Comments on: Excel MID function to extract text from the middle of a string

MID is one of the Text functions that Microsoft Excel provides for manipulating text strings. At the most basic level, it is used to extract a substring from the middle of the text string. The tutorial explains the specificities of the Excel MID function and shows a few creative uses to accomplish challenging tasks. Continue reading →

Comments page 3. Total comments: 206

  1. Hi Svetlana.
    I have a column for dates and I want to count how many dates are there? if there are more than one date in a single cell, separated by a comma
    (eg.in cell A2=08/02/17,09/02/17,10/02/17). it should come 3.how can i count it using 'countif'formula?
    I tried
    =countif (a2:a10,"*"&",")
    but it doesn't work.
    can u help me on this?

    1. =1+LEN(A2)-LEN(SUBSTITUTE(A2,",",""))

  2. Great article. Find your sight so helpful.
    I'm trying to pull specific digits from a string - WC5-39S-311704-022
    I need 6th, 8th & 9-14th, so 9-311704.
    Trying for a few days to figure this out.
    Any help is appreciated.

    1. Hi Chuck,

      You can concatenate 3 Mid functions, like this:
      =MID(A1,6,1)&MID(A1,8,1)&MID(A1,9,6)

      1. 2020;01;10;00;00;21.08;74.00;1013.70;27.00
        The question is how can I get the values after each ";" all in different columns

        1. Use Excel Text to Columns feature with ; as the delimiter

      2. Thank you so much svetlana cheusheva, I am tried to find the above formula tip from many URL's, finally I got it. Thanks my solution solve now! Great help

  3. wOW Svetlana!!!! Very Nice Article.

    1. Thank you Rohan! I am glad you've found it helpful :)

      1. You are genius!

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)