-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
number extraction
-
C
Formula to identify and display all numbers from 2 separate cells
I have a string of numbers that I need to have individually listed (one number per cell). Right now that string is being identified by having the smallest number in one cell and the largest number in another cell. Instead of displaying like this I need to have the entire string of numbers to...- chellechelle
- Thread
- add to another cell display content locate and insert values number extraction show all
- Replies: 9
- Forum: Excel Questions
-
M
Sorting numbers in 2 different columns
HI - I am looking to extract numbers from the strings, please can you help how it can be done. <colgroup><col><col span="2"></colgroup><tbody> String Required Answer Rng, Thrst(G08) 1.875in StSteel(0550) 1.875in 0550 Disc 1in StSteel(0550) 1in 0550 Rng, Thrst(H-2250-652-0594) 2.25in...- manish7490
- Thread
- 1.875in easiest way excel number extraction ststeel0550
- Replies: 1
- Forum: Excel Questions
-
D
Extracting string of 10 Numbers from cell
I have a column of thousands of cells that contain responses from a survey. Each cell contains an account number (or should) of exactly 10 numbers, but at different positions in the cell. The cell can also contain other numbers, but I need to extract just the 10-digit account number from each...- de_keda
- Thread
- extract find formula number extraction search
- Replies: 26
- Forum: Excel Questions
-
V
Fill Down cell in detail line with number in header line until next header line, then use the new number
Situation: Customer receipt records, each with a header line with customer ID number and one or more detail lines of items purchased. I want to attach that Customer ID number in the header to each of the detail rows - The number of detail rows is not consistent. The Customer ID is a number...- vsanthony
- Thread
- formula number extraction
- Replies: 1
- Forum: Excel Questions
-
E
Being able to pull out highest number when divided by dots and using multiple criteria with some numbers being 0
Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...- exceldaddy
- Thread
- multiple criteria lookup multiple criteria search number extraction order quantities
- Replies: 1
- Forum: Excel Questions
-
E
Being able to pull out highest number when divided by dots and using multiple criteria
Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...- exceldaddy
- Thread
- dots multiple criteria lookup number as text number extraction ordering
- Replies: 8
- Forum: Excel Questions
-
L
How to extract numbers from text with specified and unique conditions
<quote> I was curious if someone could tell me how to change this formula and add some properties. Such as: To ignore number strings lead by zeros, if an x is directly behind a + = - its counted as a 1 is extrated (or in the case of the - a -1), and if a - is directly in front of a number...- Lil Hotpocket
- Thread
- if then function modify formula number and text number extraction urgent helped needed!
- Replies: 0
- Forum: Excel Questions
