Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract 10 digit number from string
I need to find and extract a 10 digit number from a string which might contain more than one numeric string, but there would only be
one string of that length. I'm going to have to find out how to do this and then loop through a long list and extract that number and place it in the first cell to the right (column B). I've been at this all morning. I'm out of ideas. Surely there is an easy way to do this that I'm just not thinking of. Help ! Thanks in advance ! Richard -- RMC,CPA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting 7 digit number from alphanumeric string | Excel Discussion (Misc queries) | |||
Change a 1,2,3 or 4 digit number to a 6 character text string | Excel Worksheet Functions | |||
How to extract each digit from a number in one cell? | Excel Discussion (Misc queries) | |||
Extract 2, 3, 4 or 5-digit number from string | Excel Programming | |||
Extract 2, 3, 4 or 5-digit number from string | Excel Programming |