How to extract number from string in Excel

The tutorial shows how to extract number from various text strings in Excel by using formulas and the Extract tool.

When it comes to extracting part of a text string of a given length, Excel provides three Substring functions (Left, Right and Mid) to quickly handle the task. When it comes to extracting a number from an alphanumeric string, Microsoft Excel provides… nothing.

To get a number from a string in Excel, it takes a little ingenuity, a bit of patience, and a bunch of different functions nested into each other. Or, you can run the Extract tool and have the job done with a mouse click. Below you will find full details on both methods.

How to extract number from the end of text string

When you have a column of alphanumeric strings where number always comes after text, you can use one of the following formulas to get it.

Important note! In the below formulas, the extraction is performed with the RIGHT and LEFT functions, which belong to the category of Text functions. The output of these functions is always text. In our case, the result will be a numeric substring, which in terms of Excel is also text, not number. If you need the result to be a number (that you can use in further calculations), wrap a corresponding formula into the VALUE function as shown in the first example.

Formula 1. Get number from the right of a string

To extract number from a 'text-number' string, the first thing you need to know is where to start the extraction. So, let's determine the position of the first digit with this generic formula:


We will dwell on the formula's logic a bit later. For now, simply replace cell with a reference to the cell containing the original string (A2 in our case), and enter the formula in any empty cell in the same row, say in B2:


Although the formula contains an array constant, it's a regular formula completed in the usual way by pressing the Enter key.

Once the position of the first digit is determined, you use the RIGHT function to extract the number. To find out how many characters should be extracted, you subtract the position of the first digit from the total length of the string, and add one to the result because the first digit is also to be included:

=RIGHT(B2, LEN(A2)-B2+1)

Where A2 is the original string and B2 is the position of the first digit.

The following screenshot shows the results:
Formula to extract number from the right of a string

To eliminate the helper column containing the position of the first digit, you can embed the MIN formula directly in the RIGHT function like this:

=RIGHT(A2,LEN(A2) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, A2&"0123456789")) +1)

To force the formula to return a number rather than a numeric string, nest it into the VALUE function:

=VALUE(RIGHT(A2,LEN(A2) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, A2&"0123456789")) +1))

How the position of the 1st digit is calculated

We supply the array constant {0,1,2,3,4,5,6,7,8,9} in the find_text argument of the SEARCH function, so that the formula searches for each element of the array within the original string and returns their positions. Because the array constant contains 10 digits, the resulting array also contains 10 elements.

The MIN function processes the resultant array and returns the smallest value, which corresponds to the position in of the first digit in the original string.

Additionally, we use a special construction (A2&"0123456789") to concatenate every possible number with the original string. In situations when a certain number in the array constant is not found within the source string, this construction acts like IFERROR forcing the formula to return a "fake" position equal to the string length +1 or more chars.  As the result, if the original string does not contain any number, like in row 7 in the screenshot above, the RIGHT formula returns an empty string.

To make things easier to understand, let's see how the formula works out for a specific cell, say A2. That cell contains the text string "ECDAA-05", for which the SEARCH function returns the following array {7,10,11,12,13,8,15,16,17,18}. Here's how:

  • 0 is the 1st element of the array constant and the 7th character in the original string, therefore the first item of the resulting array is "7".
  • 5 is the 6th element of the array constant and the 8th character in the original string, so the sixth item of the resulting array is "8".
  •  No other item of the array constant is found in cell A2, and therefore the other 8 items of the resulting array represent the positions of corresponding digits in the concatenated string (ECDAA-050123456789).

Getting the position of the 1st digit in a string

Since 7 is the smallest value in the resulting array, the MIN function returns it, so we get the position of the first digit (0) in original string.

Formula 2. Pull number from the right of a string

Another way to extract number from the end of a string is by using this generic formula:

RIGHT(cell,SUM(LEN(cell) - LEN(SUBSTITUTE(cell, {"0","1","2","3","4","5","6","7","8","9"},""))))

With the original text string in A2, you enter the below formula in B2 or any other empty cell in the same row, and then copy it down the column:

=RIGHT(A2,SUM(LEN(A2) - LEN(SUBSTITUTE(A2, {"0","1","2","3","4","5","6","7","8","9"},""))))

Another formula to get number from the end of a string

How this formula works

In essence, the formula searches for all numbers from 0 to 9 within the source string, counts the found numbers, and returns that many characters from the end of the string.

And here is the detailed formula break down:

  • First, you use the LEN and SUBSTITUTE functions to find out how many times a given number occurs in the string. For this, you replace the number with an empty string (""), and then subtract the length of the string without that number from the total length of the original string. This operation is performed on each number in the array constant.
  • Next, the SUM function adds up all occurrences of all digits in the string.
  • Finally, the digit count goes to the num_chars argument of the RIGHT function instructing it to return that many characters from the right side of the string.

How to extract number from the beginning of text string

If you are working with strings where text appears after number, the formula for extracting number would be similar to the one discussed above, with the difference that you use the LEFT function to pull the characters from the left side of the string:


With the original string in A2, use the following formula to get number:


Formula to extract number from the beginning of text string

Note. As is the case with the RIGHT function, the LEFT function returns a numeric substring, which is technically text, not number.

How to get number from any position in a string

If your task implies extracting number from anywhere in a string, you can make use of the following mind-boggling formula published on MrExcel forum:

=SUMPRODUCT(MID(0&A2, LARGE(INDEX(ISNUMBER(--MID(A2, ROW(INDIRECT("1:"&LEN(A2))), 1)) * ROW(INDIRECT("1:"&LEN(A2))), 0), ROW(INDIRECT("1:"&LEN(A2))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(A2)))/10)

Where A2 is the original text string.

Breaking down this formula would require a separate article, so you can simply copy it to your worksheet to make sure it really works :)
Formula to get number from any position in a string

Upon examining the results, however, you may notice one insignificant drawback - if the source string does not contain a number, the formula returns zero, as in row 6 in the screenshot above. To fix this, you can wrap the formula in the IF statement, the logical test of which checks if the source string contains any number. If it does, the formula extracts the number, otherwise returns an empty string:

=IF(SUM(LEN(A2)-LEN(SUBSTITUTE(A2, {"0","1","2","3","4","5","6","7","8","9"}, "")))>0, SUMPRODUCT(MID(0&A2, LARGE(INDEX(ISNUMBER(--MID(A2,ROW(INDIRECT("$1:$"&LEN(A2))),1))* ROW(INDIRECT("$1:$"&LEN(A2))),0), ROW(INDIRECT("$1:$"&LEN(A2))))+1,1) * 10^ROW(INDIRECT("$1:$"&LEN(A2)))/10),"")

As shown in the screenshot below, the improved formula works beautifully (kudos to Alex, our Excel guru, for this improvement):

An improved formula to extract number from anywhere in a string

Unlike in all previous examples, the result of this formula is number. To make sure of this, just notice the right-aligned values in column B and truncated leading zeros.

This is how you can extract number from string in Excel. To better understand and probably reverse-engineer the formulas, you are welcome to download our sample Excel Extract Number workbook.

Extract number from text string with Ultimate Suite

As you have just seen, there is no trivial Excel formula to pull number from a text string. If you have difficulties with understanding the formulas or tweaking them for your data sets, you may like this simple way to get number from string in Excel.

With our Ultimate Suite added to your Excel ribbon, this is how you can quickly retrieve number from any alphanumeric string:

  1. Go to the Ablebits Data tab > Text group, and click Extract:
    Extract tool for Excel
  2. Select all cells with the source strings.
  3. On the Extract tool's pane, select the Extract numbers radio button.
  4. Depending on whether you want the results to be formulas or values, select the Insert as formula box or leave it unselected (default).

    My advice is to select this box if you want the extracted numbers to update automatically as soon as any changes are made to the source strings. If you want the results to be independent on the original strings (e.g. in case you plan to remove the source data at a later point), then do not select this box.

  5. Click the Insert Results button. Done!

Extract numbers and insert the results as formulas or values.

Like in the previous example, the results of the extraction are numbers, meaning you are free to count, sum, average, or perform any other calculations with them.

In this example, we've chosen to insert the results as values, and the add-in did exactly what was asked for:
Numbers are extracted from strings as values.

If we selected the Insert as formula checkbox, you'd observe a formula in the formula bar. Curious to know which one? Just download Ultimate Suite's trial and see for yourself :)

If you'd like to have this as well as 60+ more useful tools in your Excel, be sure to grab the 15% off coupon code that we provide exclusively to our blog readers: AB14-BlogSpo.

I thank you for reading and hope to see you on our blog next week!

You may also be interested in:

148 Responses to "How to extract number from string in Excel"

  1. ramkey says:

    Input result
    1 (21) 500 555-0145----> 5005550117
    Write a formula to extract the numbers, eliminating all the spaces symbols state codes
    for eg eg: 1 (12) 500 555-0117 shall change to 5005550117

    thanks for advance

    my requiremnt is

  2. Hello, Ramkey,

    The formula below should help you:
    =SUMPRODUCT(MID(0&RIGHT(A1,LEN(A1)-FIND(")",A1)), LARGE(INDEX(ISNUMBER(--MID(RIGHT(A1,LEN(A1)-FIND(")",A1)), ROW(INDIRECT("1:"&LEN(RIGHT(A1,LEN(A1)-FIND(")",A1))))), 1))*ROW(INDIRECT("1:"&LEN(RIGHT(A1,LEN(A1)-FIND(")",A1))))), 0), ROW(INDIRECT("1:"&LEN(RIGHT(A1,LEN(A1)-FIND(")",A1))))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(RIGHT(A1,LEN(A1)-FIND(")",A1)))))/10)

    If you need a quicker solution, then you can use our add-in. The last point of the article above explains how it works.

    Hope this helps!

  3. Vitaly says:

    Dear Ladies,

    Could you please help with the formulas?
    The input is LME_04329_100_VSH_04122017_SHUBIN_AMEND
    I need to extract the date and surname in separate cells.
    04122017 and SHUBIN

    Thank you in advance!


    • Hi Vitaly,

      With input in A2, the formulas go as follows:

      To extract the date:

      =MID(A2, FIND(CHAR(1),SUBSTITUTE(A2,"_",CHAR(1),4))+1, FIND(CHAR(1),SUBSTITUTE(A2,"_",CHAR(1),5)) - FIND(CHAR(1),SUBSTITUTE(A2,"_",CHAR(1),4))-1)

      To extract the last name:

      =MID(A2, FIND(CHAR(1),SUBSTITUTE(A2,"_",CHAR(1),5))+1, FIND(CHAR(1),SUBSTITUTE(A2,"_",CHAR(1),6)) - FIND(CHAR(1),SUBSTITUTE(A2,"_",CHAR(1),5))-1)

      Please note, the formulas work only for strings of the same pattern where a date is always between the 4th and 5th underscores and a surname is between the 5th and 6th underscores.

  4. Vitaly says:

    Dear Svetlana!
    Thank you so much!!!

    Best regards,

  5. Forse says:

    Dears ,

    Could you please help with the formulas?
    in cell A1 i input Forse41.24 and in cell B1 i input Forse 41.24
    I need to extract the number and text in separate cells.
    41.24 and Forse

    Thank you in advance!


    • Hello,

      If I understand your task correctly, please try the following formula:



      Hope it will help you.

  6. Haseeb says:

    Dear Ladies,

    Could you please help with the formulas?
    I need to extract the profile and thickness in separate cells.

    Thank you in advance!

  7. deepak says:

    hi guys!

    I have a credit card number starting with 5433xxxxxxxx3019. how can I find the masked numbers through excel? or do i have to enter any other formulae?

    • Vipul Karkar says:

      If the credit card number is in Cell number A1, then =MID(A1,5,8) formula will extract masked xxxxxxxx number.

    • Amarjeet says:

      Try this and put vlookup formula instead of A2 if you have database with full credit card no. or I need one example of .xlxs file so that I can give you precise support.

  8. zulfi says:


    i am successful in using this formulas for my work but i want to use this same formula in VBA. when i tried it in VBA for copy pasting this formula for multiple cells, it throws error. can you please help me on this.


  9. soumyakanti says:


    How to find 2nd highest number from one string cell by cell.

    result should be 4

    result should be 5

    Any solution?

  10. David Christensen says:

    Could one of you Excel masterminds help with this simple formula?
    Needs the first digit of the group of numbers, but if it's only 3 numbers needs to = 0.


    i3-520 need = 1
    i5-550 need = 1
    i5-650m need = 1
    i5-2500k need = 2
    i5-3500L need = 3
    i7-6700HQ need = 6
    i5-7700HK need = 7

    Something along the lines of locate the group of 3-4 numbers, then output the first digit unless it's less than or equal to 999 in which case output

  11. Jimmy O. says:

    This has helped me so much. You are a genius. Thank you.

  12. Rashmi says:

    Can anyone help me to extract and match few alphanumeric consecutive records in an excel

    Excel Records - Pattern is like
    1) _00004Y74A 4427
    2) _00004Y74A 4428
    3) _00004Z74A 4429

    I have to pick numbers from the right of the string till user get some character /special character.
    e.g, 1st record - we have to pick 4427 and ignore _00004Y74A

    Then I will go to the next row and find out again numbers from the right of the string till user get some character /special character .
    If number is consecutive (4428 in this case) , then I have to match the string before the consecutive numbers e,g,'_00004Y74A' is same for first and second record and next four numbers are consecutive.
    As we can see third record doesn’t have same string before the last four consecutive numbers. So this will not be picked

    So result will for alphanumeric consecutive invoices will be
    1) _00004Y74A4427
    2) _00004Y74A4428

  13. Adel says:

    Hi here is the text "Brd 2Duplex&1VDM Btm 21.5x95.5" , want to extract 21.5 in one cell and 95.5 in another cell , it is not supposed that all description comes with sizes at the end sometimes text come at the end. thanking you.

  14. Randy says:

    Hi, want to extract the right side of equation.

    PARK HILL 3277 = 3277
    CONWAY,AR 10667 = 10667
    TRADTNL 16849 3a = 16849
    ToC 011066 = 011066


    • Doug says:

      I think the simplest method is to use Excel's built-in Text to Column tool.
      Highlight the data then
      Under Data choose the Text to Column tool.
      In the Text to Column window choose Delimited then Next
      Then select the Other radio button and enter "=" in that field then next
      Then if you want to format the numbers as something other than General you can do it here
      Then select Finish and you're done.

  15. Suresh says:

    Hi - How do get the number with decimal

    Examples : 3.5 days , 4.5 days?, 1 day?, 1 day

    I need 3.5,4.5,1,1 pulled out respectively from each text

    Thanks in advance

    • Doug says:

      If you have 3.5,4.5,1,1 as text in one cell and you want to separate the numbers into four separate cells select the one cell containing the numbers and then select the data tab then text to columns then choose the delimited option then next then the comma button then finish.
      This puts the numbers in separate columns. If you'd rather have the numbers in one column in separate rows then select the numbers in each column, copy them then highlight a cell in one row then from the paste tab choose paste special then the transpose option and the numbers will be pasted into separate cells in one row.

  16. Aline Trama says:

    Dear all,

    Thank you for the post!
    Can someone help me?

    I need to separate the numbers from text but in 3 dif collumns.
    Cataflam 30mg 10 cp| Col1=Cataflam / Col2= 30 / Col3= 10
    Diclofenaco potassico Clavulanato 180mg 20cp | Col1=Diclofenaco potassico Clavulanato/ Col2=180 / Col3=20

    Thank you very much!

    Kind Regards

    • Doug says:

      The only way I could get your result was by utilizing two different multi-step processes. There may be other ways, but this is how I did it.
      First, let me say thanks to Ron Coderre a MrExcel MVP who worked through this lengthy discussion back in January 2010 while working with a couple of other folks to arrive at his final formula.
      Next, let me say thanks to the folks over at extendoffice where I found this handy piece of VBA code. Here is the address:
      If you cannot save your workbook as a macro-enabled workbook, you will need to employ a different multi-step process that is not too hard.
      To begin here is the data I started with: Diclofenaco potassico Clavulanato 180mg 20cp.
      Notice there are spaces between the chemical names and the drug amounts, but not within the drug amounts. Keep your data structure consistently like this and you will be able to use either of these processes. If you do not, the methods will not work.
      OK, the multi-step process not using the VBA.
      The first part of this process is putting all the data into separate cells.
      First, select the data. Second, in the Data tab select Text-to-Columns. Third, in the Text-to-Column window select the delimited button, then next. Fourth, select the spaces button then next. Fifth, select the general button then finish. Now your data is in five separate columns.
      The second step is to combine the chemical names into one cell. For the sake of discussion, let us say the data is now in cells A2 to E2. First, select an empty cell where you would like to see the drug name, let us say B3. To accomplish this you will concatenate the names with =Concatenate(A2,” “,B2,” “,C2). Now the drug name is in one cell.
      The fourth step requires the use of an array. This means after you enter the complete formula in the formula bar, select the entire formula and select CTRL+SHIFT+ENTER or CSE as the boys in the backroom say. This will let Excel know this is an array and Excel will enclose the formula in curly brackets. Entering curly brackets via the keyboard will not work. So, select the entire formula then CSE.
      Keeping the array rule in mind you can extract the numbers. After the text-to-columns step 180mg is in cell D2. So, let us say you would like to see the 180 in C3. Enter this formula in C3:
      {=LOOKUP(10^99,--MID("|"&D2,SMALL(IF(((--ISNUMBER(--MID("|"&D2, ROW($1:$1003),1))=0)*ISNUMBER(--MID("|"&D2,ROW($2:$1004),1))),ROW($2:$1004)),1), ROW($1:$1003)))}
      After the text-to-columns step 20cp is in cell E2 and keeping the array rule and the CSE part in mind you move to the fifth and final step in this process where you extract 20 to cell D3. To accomplish this enter this formula in D3:
      {=LOOKUP(10^99,--MID("|"&E2,SMALL(IF(((--ISNUMBER(--MID("|"&E2, ROW($1:$1003),1))=0)*ISNUMBER(--MID("|"&E2,ROW($2:$1004),1))),ROW($2:$1004)),2), ROW($1:$1003)))}
      It is the long way round the barn, but I think you have achieved the result you wanted.

  17. Mary says:

    16.91cm 217415 BAKE KING ESSENCE ALMOND
    I want to find the number as 217415, can help the formula in Excel

  18. Bill says:

    I am trying to extract anything that looks like a credit card number from a string, and this could be anywhere in the cell. Assume a blank always precedes and succeeds the string.
    Either xxxxxxxxxxxxxxxx or xxxx-xxxx-xxxx-xxxx.
    Can you provide such a solution? I would like to know the string AND I would like to know the position in the string where it begins.

  19. ZUL says:

    Dear all,

    Thank you for the post!
    Can someone help me?

    I want to extract value of Metre from
    AXNASL137/16 JJ80029874 DOBJ JAN17 1.55M @DOLLAR1930.5 = 1.55
    AXNASL14/17 JJ 80033100 DOBJ OKT17 10.6M @DOLLAR1830.0 = 10.6
    YAH N133/17 JJOB F1 29.05M@DOLLAR1870 MONTREAL = 29.05
    AXNASL14/17 JJOB 80033071 DOBJ OKT17 12M @DOLLAR1620.00 = 12

    Thank you so much!!!

    • Doug says:

      I will provide you with a solution that will work most of the time. It will extract the Metre length from the third string in your sample, but because there is no space before the "@" it will also extract a little more. You'll have to clean this one up manually.
      Where the string is in A10 the formula is:
      =TRIM(MID(SUBSTITUTE(A10," ",REPT(" ",99)),MAX(1,FIND("M",SUBSTITUTE(A10," ",REPT(" ",99)))-50),99))
      First enter this into an empty cell and then copy it down as far as you need. The target cell will update as you copy the formula down.

      • ZUL says:

        Thanks brilliant!!! This has helped me so much, though i've to make few cleaning. You are a genius. Thank you.

  20. Indranovich says:

    Hi all,

    can you help me to extract the numbers from this kind of text:

    RODC - Jakarta 25105372 **
    RODC - Singapore 74297001 **

    many thanks

  21. Doug says:

    Probably the easiest way to do it is to use the Text-to-Columns technique.
    Highlight the data you want to split
    Under the Data tab select Text-to-Columns
    Click the Delimited button, click Next
    Select the Space option, click next
    In this window you'll see the way Excel will split the text, click Finish
    The text will be in separate cells.

  22. Theo says:

    This formula doesn't seem to work when the string of numbers I'm trying to capture starts with zeros, is there a workaround for this?

  23. willi says:

    im looking to extract a series and replace it with "-" to keep the min() and max() values of the series. Then to repeat IF() there are more series sets example:

    from this:

    100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 506

    to this:

    100 TO 122 124 TO 142 506

  24. ece says:

    how to extract only numbers from a text like this "€ 1'234'567" or this "EUR 803'765" ?

    • Doug says:

      This formula works great. Found it on the web some years ago.
      =IF(SUM(LEN(A8)-LEN(SUBSTITUTE(A8,{"0","1","2","3","4","5","6","7","8","9"},"")))>0, SUMPRODUCT(MID(0&A8, LARGE(INDEX(ISNUMBER(--MID(A8, ROW(INDIRECT("1:"&LEN(A8))), 1)) * ROW(INDIRECT("1:"&LEN(A8))), 0), ROW(INDIRECT("1:"&LEN(A8))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(A8)))/10),"")
      Remember, there are no line breaks in it.

  25. Mihael Matika says:

    Could someone please help me with :
    "Zadnja: *41,40*
    I want to extract 41,40 and the cell in wich is located is B2.

  26. mihaelmm says:

    Could someone please help me with :
    "Zadnja: *41,40*
    I want to extract 41,40 and the cell in wich is located is B2.

  27. Djole says:

    Hello, I have quite a difficulty task, can't seem to resolve it.
    Cell A1:
    0123456789 Description Item 1 $150.01 0123456789 Description of item 2 $1400.01 0123456789 Description of item 3 $50.01 0123456789 Description of item 4 $15

    I want to extract all the prices and sum them.
    In cell B2 it should be: $1615.03 - which is sum of 150.01+1400.01+50.01+15.

    Note that example in cell A1 can vary with number of items, it can go from 1 to 10 items in total, resulting in 10 prices that need to be SUMed. Also for this text string, what is constant always is the "$" before the price and space (blank) after the price.

    I'm able to pull the first price only, but can't quite figure out how to move on to the next price.

    Can someone help me out with this?

    • Doug says:

      You say you are able to get the first price. How are you able to do this?

      • Djole says:

        Well, at that time i thought i was able with this function:

        But, since the price is variable, it will not work well if the price is $15 for example. I was able though to find the position of each "$" in the cell with the help of FIND and SUBSTITUTE functions.

        For the example i mentioned above this will find first "$" position, then it will replace the first "$" and find the second one, etc.


        Big flaw of this method is that if you have more than 2 prices in the string, it will not work, so you'll need to add a nested SUBSTITUTE in SUBSTITUTE.

        To solve this problem i had i got help from yt channel I think they will post the solution in the next week or so.

      • Doug says:

        Because the values were not the same length, the only way I could extract the dollar values was to use Text-to-Columns using the "$" as the delimiter, then where the data had been entered into cell A8 through D8 I entered this: =LEFT(A8,FIND(" ",A8)-1)+0 in an empty cell, then formatted the cells as currency and created a cell to enter SUM(A8:D8).
        Is there a way the values can be entered into separate cells as they're entered? Putting all the info in one cell makes it very difficult to work with. Try to catch it at the front end.

  28. AMA says:

    I have a column of values (see example below, column A):
    What formulas do I use to split the numerical value into column B and the Unit of Measure (alpha characters) into column C, (see example, Columns B & C)??

    A B C
    1 1g 1 g
    2 10g 10 g
    3 5g 5 g
    4 50mg 50 mg
    5 250mg 250 mg

    What formulas do I use to split the numerical value into column B and the Unit of Measure into column C, example

    • AMA says:

      Formatting didn't come through correctly...

      cell A1 is 1g / want 1 in cell B1 / want g in cell C1
      cell A2 is 10g / want 10 in cell B2 / want g in cell C2
      cell A3 is 5g / want 5 in cell B3 / want g in cell C3
      cell A4 is 50mg / want 50 in cell B4 / want mg in cell C4
      cell A5 is 250mg /want 250 in cell B5/want mg in cell C5

      • Doug says:

        This requires a different formula for each cell.
        In the cell which will contain the number the formula is:
        In my example the cell holding the original data is H40. You can change this cell address to whatever suits you.
        The formula which will contain the units is:
        Again, my example has the data in H40 you can change that address.

        • AMA says:

          Thank you SO VERY Much!...These formulas worked!
          I had racked my brain trying so many different approaches and could not find the solution.
          Thank you for your help

  29. Doe says:

    I have following data.

    cell A1 = ap232pple 2017.01.01. aaaaasb
    cell A2 = gra2pe s7s 2018.01.01. ssss ed
    cell A3 = ora123nge see 2018.03.05 sse

    Is there a folmula to extract the date (A1 = 2017.01.01)?

    Thank you very much for your help!

    • Doe says:

      I got the formula for this case so far below. I don't know why it does not recognize first digit (2) so I had to manually add it..

      =IFERROR("2"&MID(E5,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},E5,1),LEN(E5)+1)),LOOKUP(1,0/MID(E5,ROW(INDIRECT("1:"&LEN(E5))),1),ROW(INDIRECT("1:"&LEN(E5)))) + 1 - MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},E5,1),LEN(E5)+1))),LEN(E5))

  30. guest says:

    Column, name, description
    A - text; text with drugs and chemical names (alphanumber). One, two or more names.
    B - common_name; common names of drugs and chemicals
    C – synonyms; synonyms of drugs and chemicals
    D – exctracted_names_origin; names from column A (drugs,chemicals). Between names the symbol ;
    E – extracted_names_common
    If some row contents two equal names or synonym only, one common_name is extracted in E

    Text; common_name;synonyms;extracted_names_origin;extracted_names_common
    Please copy column by column:
    SUBSTANCE (+/-)-2-(P-ISOBUTYLPHENYL)PROPIONIC ACID;N-(4-Hydroxyphenyl)acetamide etc


    1H-Purine-2,6-dione, 3,7-dihydro-1,3,7-trimethyl-

    (+/-)-2-(P-ISOBUTYLPHENYL)PROPIONIC ACID;N-(4-Hydroxyphenyl)acetamide



  31. Jesse Bryant says:

    Hello. May be a simple one for you guys but I would like to extract two separate numbers from a text string into separate cells. As in;

    Text string: 1 Lines for 50 mins

    Result 1: 1
    Result 2: 50


  32. Yagya says:

    I just count numbers mentioned in string,
    Ex: String- (123456, 124564, 123456, 321456, 526341, 253614) total numbers count is "6"
    Please help for excel.

    • Doug says:

      You can count a specific character like a comma with this formula:
      Where the data is in D85.
      In this formula the character to count is the comma in the second spot or the first ",". If your string was separated by - then enter a - in the place of the ,.
      In your case this will return 6.

  33. pawan kumar says:


    I have this type data mainsh98kamal98545 so how to split number and text in seprate columns.

  34. Quinton says:

    Henlo, is there any formula to find numbers within a string of text, I'm wanting to make an "=if(" formula for two cells where the sum of the numbers in cell B2 are equal to the single number in B3

    • Doug says:

      This is an array formula so you need to use the keys CTRL+Shift+Enter. In the formula bar you can move your cursor into the formula and then click CTRL+Shift+Enter.
      After you do this, there will be curly brackets around the formula which tells Excel it is an array.

      =LOOKUP(10^99,--MID("|"&D2,SMALL(IF(((--ISNUMBER(--MID("|"&D2, ROW($1:$1003),1))=0)*ISNUMBER(--MID("|"&D2,ROW($2:$1004),1))),ROW($2:$1004)),1), ROW($1:$1003)))

      Enter this in an empty cell and then CTRL+Shift+Enter. You can change D2 to the address you need.

  35. Vikram Rawat says:

    How can we extract the number from this text.
    BOACK#3243004465 Mount

    • Doug says:

      You can use the solution I provided Quinton in the reply directly above your question. It works great for your sample data. Remember after you enter the formula in the cell, put your cursor into the formula in the formula bar and click CTRL+Shift+Enter to tell Excel this is an array.

  36. Vikram Rawat says:

    Thank you, Its working.

    Can you pls explain,how the function is working?

  37. Newbee says:


    I have various lines with different patterns and wish to extract only the number. Appreciate your help and advice.

    Sa1_TC_Mthly Subs GPRS A/C 515946020_May18
    Sa1_TC_Mthly Subs for A/C 515605183_14Dec17-13Jan18
    SA1_TC_Mthly Subs for A/C 601335405_Jan18

    Expected results:

    • Doug says:

      I think there a too many numbers in the string to use a find numbers formula. After working with your sample data the easiest thing I could find was to use the Text-to-Columns tool. Once the data has been split into several cells you can copy the numbers you want and paste them where they're needed. It's nothing fancy, but it gets the job done.

  38. jam mesina says:

    Hi please help me in extracting only the numbers here:
    a.367 cd 046 104101 104101
    b.131 DPU3005 KRISPY 104017 104017
    c.CC MERCH ID 9189997141 9189997141
    d.CC MERCH ID 9189997158 9189997158
    e.POS MID 5930005 - 06/29/2 5930005
    f.POS MID 19520212 - 06/29/2 19520212

    I tried using this formula =LOOKUP(99^99,--("0"&MID(C7,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C7&"0123456789")),ROW($1:$10))))
    it worked for letters c-f but for a-b it only extracted the first number 367 and 131.

    Hope you can help me with this. thank you

    • Doug says:

      Where the first data set is in A2 this should work:
      =TRIM(SUBSTITUTE(RIGHT(SUBSTITUTE(A2,",", " "),LEN(SUBSTITUTE(A2,",", " "))-MAX(IF(MID(SUBSTITUTE(A2,",", " "),ROW($1:$99),1)=" ",ROW($1:$99)))),CHAR(160)," "))
      This is an array formula, so when you put it in the formula bar with the cursor somewhere in the formula click CTRL SHIFT ENTER. You should then see the entire formula surrounded by curly brackets.
      Copy this down the column to allow this to work on the next data sets.

      • jam says:

        sir the formula did not work.
        367 cd 046 104101 Real
        131 DPU3005 104017 KRISPY
        CC MERCH ID 9189997141
        CC MERCH ID 9189997158
        POS MID 5930005 - 06/29/2
        POS MID 19520212 - 06/29/2

        i want to extract 104101, 104017, 9189997141, 9189997158, 5930005, 19520212. what formula can i use to extract this numbers.

        Thank you.

  39. JAM says:

    367 cd 046 104101 Real
    131 DPU3005 104017 KRISPY
    CC MERCH ID 9189997141
    CC MERCH ID 9189997158
    POS MID 5930005 - 06/29/2
    POS MID 19520212 - 06/29/2

    i want to extract 104101, 104017, 9189997141, 9189997158, 5930005, 19520212. what formula can i use to extract this numbers.

    Thank you.

  40. Rosa says:

    How do I extract the $ value?
    $0.00 copayment

    • Doug says:

      Enter this as an array formula in an empty cell and then format that cell as Number. Where the data is in C36:
      Remember, this is an array formula so after you enter it in the formula bar click in the formula and CTRL+Shift+Enter all in one click. Then you'll see the curly brackets around the entire formula indicating Excel knows this is an array formula.

      • Doug says:

        Here's another formula to extract numbers from a string. It's also an array so CTL+Shift+Enter. I think this one works more reliably. So, where the data is in C37
        =LOOKUP(10^99,--MID("|"&C37,SMALL(IF(((--ISNUMBER(--MID("|"&C37, ROW($1:$1003),1))=0)*ISNUMBER(--MID("|"&C37,ROW($2:$1004),1))),ROW($2:$1004)),1), ROW($1:$1003)))
        Remember to format the cell where this formula is entered.

  41. Kim says:

    Can anyone help with a formula for this text string? We need the most recent date from the string. Thanks you in advanced.

    Below are a few examples:
    CPG PW REV 09-01-2011~No=02-19-2010~Yes=06-01-2005~Business Closing
    CPG PW REV 09-29-2010
    CPG PW REV 05-11-2012~No=06-08-2012~New Owner~Yes=07-21-2005~Business Closing

  42. Jessica says:

    I want to extract 541 from KA54115259.

    • Hi Jessica,

      If you just need to extract 3 characters beginning with the 3rd one, you can use this formula:


      Where A1 is the cell containing the original string.

    • ASHOK CHOPRA says:

      you can use MID function in excel. It returns a specific number of characters from a text string starting at the position you specify.
      in you case KA54115259 is the text string. To extract 541 from this string use =+MID(cell number,3,3). cell number in the cell where your this data appears.3 is the place of a text from where excel starts and next 3 is total number of characters you need to extract 541 i.e. 3

  43. Andrew says:


    I am attempting to return only those numbers below which contain "50097" in the first part (before the hyphen) which are pre-fixed by "BA". The numbers need to be returned in the same cell.

    BA50097-52201 BA50097-63623 BA50097-64930 BA52201-50097 BA56510-50097 BA63623-50097 BA64930-50097

    I've been racking my brains. Any help would be appreciated.


    • Andrew says:

      For clarity, I am attempting to return the second part of the string (after the hyphen) if 50097 is a match in the first part. Hope this makes sense.

  44. Nadeem Ahmed says:

    Hi, I need help in extracting numbers from a string but along with spaces after each set, for ex:

    A1 = first number48832234//second number552437548

    Result = 48832234 552437548

    i am already aware of the formula to extract all numbers.

    any help is highly appreciated.

    • Nadeem Ahmed says:

      I am awaiting some help ... is someone there who can help ....

      • Doug says:

        I remember this question from the other day and it isn't clear. However, if you have two numbers in one cell separated by "//" and you want to remove the "//" and substitute a space then this works:
        =SUBSTITUTE(A1, "//", " ")

  45. Hiren says:


    Please help me in following.

    I have a bunch of data containing product name with its strength in "MG", Like XYZ 50MG TABLET, PARADICLO 500/100MG TABLET, ABC 100 MG CAPSULE like wise....

    I just need to extract "STRENGTH" like, 50MG, 500/100MG, 100MG, 0.375/0.5MG likewise.

    Please help, if anyone knows.


  46. Doug says:

    Because each of the substrings you want to are different and the strings vary in length, I think the best you can do is to use different formulas for each.
    For example, with the string "XYZ 50MG TABLET" you want the "50MG" substring. You can use =MID(H35,SEARCH("MG",H35)-2,5). With the "PARADICLO 500/100MG TABLET" you can use =MID(I35,SEARCH("MG",I35)-7,9) to extract "500/100MG". This approach can be repeated for each string and substring. It's a little klunky, but I don't see anything other than the "MG" that's common to the strings.

    • Hiren says:

      Hi Doug,

      Thanks for your response. Yes, you are right. I had already tried this and helped me in few cases. I think, for rest of the things, I will have to do manually as the description of products are different.

      Once again Thanks.


  47. Stephanie says:


    I am having trouble with my formula, despite following the instructions step by step!

    I want to add numbers associated with different words. Example:

    15 walk
    60 gym
    10 run
    10 walk
    30 run

    I want the sum... Walk= 25 Gym=60 Run=40

    To rephrase, I want the sum of all digits associated with "walk" OR "gym" OR "run".

    I can't figure this one out! Thank you for any help you're able to provide!


    • Doug says:

      Enter "Run", "Walk" and "Gym" in cells C62, D62 and E62 respectively. These will be the headers.
      Enter the data in A48:A57. The formula is case sensitive so be sure the data matches the caps in the headers.
      In C63 enter =SUM(IF(ISNUMBER(FIND(C62,$A$48:$A$57)),VALUE(LEFT($A$48:$A$57,FIND(C62,$A$48:$A$57)-1)),0))
      then with the cursor in the formula bar in the formula click the CTRL Shift Enter keys at the same time. This is an array formula so you need to tell Excel to evaluate it as an array. When you enter the formula and then in the formula bar you put the cursor in the formula and click the CTL SHIFT ENTER keys it will put curly brackets around the formula which indicates to Excel that this is an array.
      When the value appears in E63 copy the formula over to D63 and E63.
      As you enter more data in the A range be sure to change the second cell address to match the last cell in the range. Right now the range is A48 to A57. If you add more data change the A57 to another cell address. Remember, there are three places in the formula for that range.

  48. RK Reddy says:

    Type of Issue: Booking failure (order in entered status)
    Here as detailed description of issue as possible.: Order 787895 is stucked can you book that. Thank you!
    Order number: 787895
    Priority: High

    Provsiioning bars are in N/A status. Plea

    ----- Please help me to write excel formulate to get order numbers

  49. S Thomas says:

    Please Help!
    I have a text string containing comma delimited numbers in a single cell, e.g. "2, 3, 4, 10, 11". I am looking for a formula that looks for a given number and returns TRUE if it is contained in the string or FALSE if it is not. The formula must not confuse numbers with characters, e.g. looking for "1" in the example string above must return FALSE.

    Any help much appreciated!

  50. cesarcazal says:

    It's great! but shamelessly the formulas in english doesn't work in german... So, thanks anyway! :D

  51. raj4rev says:

    Can also use the simple formula as below


    Then hit Ctrl+Shift+Enter

  52. sachin says:

    we have a data like this:-
    r0fsd9958405019e34 Required Data : 9958405019
    5353w9810105370qw4354 : 9810105370
    ewrew8860339000dfdf : 8860339000

    I want to extract only mobile number which is 10 digit at each place, please let me know the easiest formula to extract these mobile number in simple way.

    • Hello, Sachin,

      If we understand your task correctly, you may find our Extract Text add-in helpful. Please try to use the "Extract by position" option to extract the 10-digit mobile numbers from your cells. Just enter "6" as the position number of the first character, set "10" as the number of characters to extract and click "Insert Results".

      Please note that Extract Text is available as a part of our Text Toolkit only. It contains 8 useful add-ins to manage text data in Excel (remove extra spaces, substrings and non-printable characters, change case, split cells, etc.). You can install a fully functional 7-day trial version of Text Toolkit to see if Extract Text and other add-ins work for you. Here is the direct download link.

      If you have any questions, don't hesitate to ask.

  53. Ronald says:


    do appreciate your guidance how to extract number with decimal from excel?

    for example |1234.56 USD| to |1234.56|


  54. Michael Colin Gowlett says:

    Hi Guys - i want to extract the 2018 from the below text string in cell A3, can someone help? TES1-TEST-Bathtimes-2018, bloggs, joe

  55. Nerijus says:

    a1 a2
    I have BXC123644 i want rezultate BXC1 all text and one number
    AEB56984fg5 AEB5
    CT12564984 CT1

  56. majid says:

    I have data like:
    sodium fluoride 1.1 mg O 0.5 mg fluoride
    magnesium hydroxide 3 g O 
    how can extract sodium fluoride, benzydamine,magnesium hydroxide to column b
    and 1.1, 3 to column b and mg, g to column c and o in column d

  57. Christopher Allan Bautista says:

    Hi guys,

    I have a number string for example like "07427640900247247520603080251507427640900" and I want to extract a 11 digit number starting with 07 from within this number string. How can you do it?

  58. Doug says:

    There are two instances of "07" in this sample string.
    If you want the first instance and the next 9 digits then where the string is in C13 enter this in and empty cell: =LEFT(C13,11)
    If you want the second instance and the next 9 digits then enter this in an empty cell: =RIGHT(C13,11)

  59. Chelsea McEachern says:

    FYI, this is way more complicated than necessary. In a column to the right of the list, I pulled out one of the numbersets manually and Excel auto-filled the rest. My numbers were surrounded by text on both sides and of varying length.

  60. Elena says:

    Hello. What if I have a specific number, for example 1231, but that number is obtained by a sum of 3 numbers? Can I extract numbers from that sum formula?

  61. Ow Kj says:

    I have a string of numbers 20180818
    I need to extract month and year in MMMM/YYYY format

  62. Tim says:

    Hi guys,
    I refer to the formula to extract numbers from the beginning of the text string. i.e.,

    My text data looks like this:

    When I use this formula, I require the code '3922', but for some reason the second 2 is being eliminated, and i get an output '392'
    this is happening for all such cells where one number is repeated in the string.
    for eg., "2702AggravatedAssault" returns '270' instead of the desired '2702',
    "2902UnlawfulRestraint" returns '290' instead of the desired '2902', and so on.
    Please help, I'm at my wits end.
    thank you

  63. Doug says:

    I can't get Excel to exhibit the behavior you're seeing, so I can't say how to correct it.
    The numbers are extracted as text. If that is a problem for you can use the VALUE function on those cells that contain the numbers stored as text. It looks like =VALUE(A2)
    Alternatively, you can use the text to columns tool in Excel, Use the fixed width option and it will separate the numbers from the text. This method produces the numbers as numbers. Even where you have large numbers of rows of data the Text-to-Columns tool gets the job done quickly.

  64. JUANA says:

    how to extract the number of grams from a text like this without getting the 7x5 part

    thank you

  65. Sudhir says:

    Hi guys
    I want extract only numbers from
    Talk Show - (123456789)
    Pls pls share the formula.

    Thanks in Advance!

  66. Doug says:

    There are a couple of techniques for extracting specific data from text strings.
    One method is to use the RIGHT, LEFT or MID functions. Another is to use Excel's Text-to-Columns tool and another is to use one of several formulae. All of the techniques are thoroughly explained and demonstrated with examples in the above article.

  67. HARSH says:

    Please help me for below data separation

    (Vehicle Number separation )
    - INV#7451-47KA03MF2980
    - SU081819WIN02420-OTC BILL

    (Vehicle number and Invoice number separation )
    - SU081819INS02152-KA03MZ2310-INS AMT

    Please do the needful..

  68. Harsh says:

    Please help me for below data separation

    (Vehicle Number separation )

    - INV#7451-47KA03MF2980

    - SU081819WIN02420-OTC BILL

    (Vehicle number and Invoice number separation )

    - SU081819INS02152-KA03MZ2310-INS AMT

    Please do the needful..

  69. Doug says:

    Hello, Harsh:
    The data in the sample doesn't match the end result. Where is the data in the end result coming from?
    My first thought is you should try using the Text-to-Columns tool in Excel. Use the hyphen as the separator.
    If this doesn't work, try submitting your question with all the data so we can see what you're working with.

  70. Sid says:

    I have a question:
    I am trying to extend the autofill.

    I want it to go in sequence as A1+1, A2+1, A3+1, than A5+1, A6+1, A7+1, than A9+1 A10+1, A11+1...
    So when i drag the autofill it adds in above manner skipping after every 3 a cell

  71. Natalia says:

    I need to get last 6 numbers from a 10 digit number - 1000002502, but not including "0". Is there any formula with such condition?

  72. MUHAMMAD UMER says:

    INPUT LIKE THIS ( 98564, 45845, 45142, 45142)

  73. Vishal says:

    Input erfsd9958405019e34
    Desired Output 9958405019

    • Doug says:

      Hello, Vishal:
      This formula will produce the desired output: =MID(A2,6,10)
      where the input is in cell A2.
      If you have the same need to extract the middle 10 digits beginning at the 6th digit then you can copy this straight down column A.

  74. Kalyan Kumar says:


    I have query, I have data in cell like this
    "Owczarek TB 1, 2, Kobayashi T 2, Ramirez R 3, 4, Rong L 1, 2,3,4,5, Puzio-Kuter AM 2,". and I want to be split the data result like
    Owczarek TB 1, 2
    Kobayashi T 2
    Ramirez R 3, 4
    Rong L 1, 2,3,4,5
    Puzio-Kuter AM 2

    Please revert back me with solution.


  75. Rahul Yadav says:

    Hi There,

    Please help me to get extracted the number from a string. There is a string "(CAN_39F Inc. - 35722)" and I want to get only "35722" instead of "3935722". I have used the formula given above but I get all the number written in the string. That formula is very helpful in getting number from strings like "(Meraki Group - 36785)" (extracted number "36785") but fails for strings where number is written middle of the string or start and I want only those number which are written in last after hyphen (-).

    Kindly help me to get this sorted out.

    That would be very helpful.

    • Doug says:

      If the data is always formatted as shown in your example, the simplest way to extract the digits after the hyphen is:
      =RIGHT(A2,5) where the data is in A2. You can change the number of digits from 5 to another string length.

  76. benny says:

    Using the improved formula under the "How to get number from any position in a string" section, if a source string is "USEC-SATL: 100USRITM-SATL: 130", it will return "100130".
    Is there a way to adjust the formula so that it can return a comma separate value (i.e. 100,130)? I want to delimit it and get back the individual values. Thank you.

  77. Khrawn says:

    I have a lot of cells that looks like this:

    Omp. B. 2111215 013841 - Superbrugsens Lynge - Uggeløse fra sekr 935 52919 935 til sekr 935 52930 935

    And I need to find the number after the B., in this case 2111215. In some cells the number comes after "b" and some times after "B.". Is there any way to do this?

  78. Devansh Shrivastav says:

    I Want to Extract number after and before with X in the below descriptions
    example 1. Huhan Series XL38SX4 JP Limielite Product
    example 2. Shower Shampoo SM172SX1 BOX DENIM8 IN PC
    output want
    1. 38X4
    2. 172X1

    I need to extract 38X4 from the above string. I have bulk list of these type of description and the string type is not fixed. please help me to experts to extract these number in excel

  79. Larry Hodge says:

    How would I extract these numbers without using text to column, pleas, and thank you
    Introduction to IT 4 1
    Critical Thinking and Logic 3 1
    Fundamentals of Information Security 3 1
    Introduction to Geography 3 1
    Business of IT - Applications 4 2
    Integrated Physical Sciences 3 2
    Ethics in Technology 3 2

  80. RA says:


  81. Erin says:

    Thank you so much for this incredibly helpful article. The formulas almostttt work for me, but I am hoping to only retrieve the last 4 characters from a column entry ONLY in the case that the last four characters are NUMERIC, and even if there are numerals/text earlier in the string. My column entries are all different lengths so I am not able to use text to columns, either. Here is an example: If my column entry were to say "Blue Sky 1st Bracket 1999", I would only like to get the "1999" in its own separate column (without the inclusion of the first '1' earlier in the string). If my second column entry were to say "Blue Sky", I would like nothing to appear in the separate column. Thank you so much for your help.

  82. Janos says:

    Hi! I have "update" data in cells, like below (xxxx - string):
    181215 xxxxx xxxxx xxxx xxxx 34xx 3-4xxxx 181216 2xxxx-xx xxxx xx3 xxx, etc. where 181215 and 181216 are dates.
    I'd like to extract the last date (here it is 181216) from the string with functions (not with macro).
    Could you help me with this? Much appreciated! Thanks!

    PS: In the tutorial there's a little error at: =RIGHT(B2, LEN(A2)-B2+1). The working formula is =RIGHT(A2, LEN(A2)-B2+1) like under it.

  83. says:

    Hi, I have data like....agjkkhffjkkhfcnkkhfc2445543345fhhffh,
    I need only numbers like 244554334 pls help with formulas.

  84. Fahad Azeem says:

    Very helpful solved the problem.

  85. June says:

    I would like to extract the number right before "days" from following an example. Could you help me?
    60 years, female, white, stage:iia, alive, 588 days
    female, asian, stage:iib, alive, 2759 days
    80 years, female, black or african american, stage:iia, alive, 3364 days

    I need

  86. Alexa says:

    I have this column, where ALL is specified in other cells eg H1=270 and H2=9300

    And i would like to create this:
    A B
    270 9300
    270 9300
    319 3234
    8538 8542
    356 356
    2665 2665

  87. Sri Vidhya says:

    I have a 16 bit binary number in one cell, and have to read only 2 bit data from 5th position.Any excel formula for this?
    For Ex : 0100100001010011 is my bin number
    5th position counting from right is the 6th place(O,1,2,3,4,5)
    So it is 0, taking 2 bits to right is 01
    The answer is 01

  88. Kanntin says:

    "H004.16K6170" I need to get the number out of text include 0(left and right). for example "004166170"
    How can I do it? please help ;-;

  89. Rahul Rawat says:


    These are two values in cells which i need value of "G" means number which are together with "G"

    Exa -1 = Input - AMANACDEDITA FLOW BACK 18.85G abcde so output would be - 18.85G because 18.85 is number with "G"

    Exa -2 = Input - RWK MIX DN/LAKA 4DSX12UNX135G so output would be - 135G because 135 is number with "G"

    Please Help.

  90. jack says:

    Lb29235John033921058 this is in A1

    need formula for only "33921058"

    need just the last set of numbers but sometimes the count can vary in length so ex...
    last #s in a2 = 3 numbers
    last #s in a3= 5 numbers
    last #s in a4 = 9 numbers and so on

  91. Aida says:

    Anyone please,
    How can I extract the qty/value which is between texts. (e.g. 260 Individual Removal of Trees,small 303.00 each) I need to extract the number 303 only.) Thanks.

  92. ANKIT SINGH says:

    (A) 10400 OFF WHITE (B) 23100 CAMEL (C) 23100 CAMEL + 10400 WHITE
    Please help me !

  93. Mitchell says:

    Hi I need some help!

    I have cells that include an inconsistent title but all include a 6-digit meeting code. is and some of the inconsistent titles have numbers before the 6-digit code. Any thoughts?

    What I have:
    146761 - Trane Extended Leadership Meeting - April 2015
    RFPIGR19 - 161291 - Society of Women Engineers 2019 National Conference - November 2017
    RFPIGR19-161791-IWD Q1-QOR Reviews

    What I need:

  94. peter says:

    i need to multiply:
    40,000 sq.ft of gross building area @25.00/sq.ft

  95. SAM says:

    I have serial number in a cell like 12345678910 and i want to some this in a different cell so how can i do this?
    plse help me 8127701024 this is my whatsapp number so pls help me

  96. amir says:

    i have 234598 number
    i want per number put on a cell
    234598 2 3 4 5 9 8

  97. HInesh says:

    In a excel i have to add numbers from 2 different cells, 1st cell to have number before the decimal point and the other cell to have numbers after the decimal point.
    however both cells are linked to sheet 1 from which the cell number changes upon the entry, For example
    First Cell would be on D6 which is 10.25
    Second cell would be on O6 which is 6.77
    but the answer in cell E6 would be 10.77

    Can anyone help me with this please.

  98. Aljaž says:

    hello cen somebody please write me code for extract last 4 digits (0470) before P in serila number 1908910470P46363902R77391

  99. karthik says:

    How to separate the text and no. from string like this:
    Where hand power only is used 97.30 166
    Where any mechanically driven machinery is used 121.60 761
    Fish Dehydrating - 24.30 717
    Excl. erection, decoration tents and mosques 12.15 55 167
    Incl. Erection 24.30 168
    Floorcloth Linoleum Mfgrs. 30.15 725
    Flour and Dal Mills 15.10 169

Post a comment

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard