Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How would I extract a number (or series of numbers) using a single cell
formula from an alphanumeric text string that also contains spaces? One key component of the number(s) in question, is that they have a space on either side. See the example of the text string below: "A 544646-BA CALIF UN1MM+ 5 7/1/2017 FSA 108.579 3.90 3.82 8 Aaa AAA" In this example, I am trying to extract the number "8". However, there is also the number "5", which appears first, and that I want to avoid extracting. Additionally, the formula should be able to extract any number, not specific to "8" or "5". This formula should always skip the first single number surrounded by spaces ("5" in this example) and extract the second number(s) ("8" in this example). -- iperlovsky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting numbers from string of text | Excel Discussion (Misc queries) | |||
Extracting a word from a text string | Excel Discussion (Misc queries) | |||
extracting numbers within text string! | Excel Worksheet Functions | |||
Extracting from a text string | Excel Worksheet Functions | |||
extracting numbers from string | Excel Discussion (Misc queries) |