extract number

  1. S

    Compare data and extract Software name, year and version

    Hi Experts, I was not able to find a thread similar, so starting this thread. I am a novice in excel and I am trying to compare the softwares of an application with the master data list. My questions are as below. 1. I have to compare 2 strings in this scenerio (e.g COL A - microsoft visual...
  2. R

    Extract a number from a string

    I have a column like this. Quality Score: 5 (20180412) Quality Score: 5 (20180220) Quality Score: 4 (xxxxxxxx) Quality score: 4 (20180713) Quality Score; 4 (20180605) I need to get just the scores in a different column so I can average them in a pivot base don toher criteria I have in other...
  3. M

    How to Extract text and numbers after or before comma

    Hi All, I have my text data as below mentioned & i need to extract data <tbody> <tbody> 152/C Ist FLOOR, ASAMBU ROAD, VADASERRY, NAGERCOIL,629001,TAMIL NADU </tbody> <tbody> 21-37-L, I FLOOR, VASANTHAM MAIN ROAD, THUCKALAY,629175,TAMIL NADU </tbody> <tbody> MAIN ROAD, BALAPALLAM...
  4. M

    Extracting data from website source code

    I would appreciate if any super experts would help to find a solution to extract source code data from a chart found on a website and build a macro to automatically import the data to excel. The website's source code is from: Load Forecast vs. Actual: Current Day The data to extract is the...
  5. A

    Extract number from text

    Hello there, semi-noob-code-developer here ! :nya: I have being searching for an option to extract specific numbers from a string, and so far I have been unable to find a suitable solution. I have this string format: (14.370) FY14 - 3Q US Marketing Progression I need to extract the...
  6. S

    Extract number out of text but only if in bracket.

    Hi everyone, I received an excle file hat include a list of employe and the employee number. The problem is that it's multiple employee in the same cell and multiple employee number per employee However the current employee number in the one in bracket. I would to extract each employee...
  7. L

    Extracting numbers, with a twist...!

    Hi all, So, I'm looking to extract phone numbers from a long list of company and number in the same cell. I have various formuals to extract numbers from cells, but none are working, and here's why: Firstly, all the formulas I try ignore the '0' at the start of the number Example: Cell...
  8. J

    How to extract a set of 6 numbers from a set of 7 to 15 numbers.

    Earlier I had alpha numeric data. I looked up a solution on your website and deleted all the text from the alpha-numbers (http://www.mrexcel.com/forum/showthread.php?t=545660) (Thanks to respondents, i learnt something new.) Now this is where i am. I have the below mentioned data with me...
  9. C

    deleting numbers shorter than x characters

    Hello, I have the following request, if someone is kind to help me. The lines in excel look like this : 3 4 6353 18423875632 43 563 88888888 123 4444 55555555 Now, I want to erase all the numbers from these 3 rows EXCEPT the numbers longer than 5 characters. In the end, I want the sheet to...
  10. J

    Extract a 5 Digit Number From Inconsistent Text Strings

    I know how to extract a number from a text string using: LOOKUP(99^99,--("0"&MID(J1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},J1&"0123456789")),ROW($1:$10000)))) But in my current data set I have thousands of inconsistent text strings some of which contain other numbers that I don't care about - with...
  11. B

    Copy (range} from worsheets to "Results" sheet

    Windows 7<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Excel 2007<o:p></o:p> <o:p></o:p> PROBLEM: I have completed my loop through all the sheets in my workbook. All my data is copied to a “Results” sheet that looks like this. Player 1 has been copied...
  12. F

    Extracting numbers from multiple cells in a range

    So I need to extract numbers from multiple cells withing a range, having added them up. The current extract number function I found only works for one cell at a time. Function ExtractNumber(Target As Range) As Variant Dim i As Integer Dim str1 As String For i = 1 To Len(Target) If...
  13. S

    Move numbers contained within a string

    Folks, Hello all, newbie here so please be patient. I have entries in approx 6500 cells which contain a string that is a mixture of text and numbers. What I need to do is to move the number value of the cell to the adjoing cell on the right - it sounds fairly simple deosn't it? Why have I no...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back