Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Suppose I have the following string:
"The street is 1501 S. Oak Lane, Apt #228" I need code that would extract the first numeric substring (starting from the LEFT). Therefore, I would need to extract "1501 from this string. Or, I might have a string that looks like this: "cat. dog mouse 12 8 112 house tree" For that string, I would need to extract the "12" only, because it is the first numeric substring or token. Does anyone have any code samples that can extract the substring that I describe above?? Please note that any number of whitespace (space or tab) characters may separate the string elements. Thank you! Robert Crandal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Numeric data | Excel Worksheet Functions | |||
Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
Find numeric value at end of string | Excel Worksheet Functions | |||
MACRO TO FIND SUBSTRING OR SUBTEXT ! | Excel Programming |