| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I search for a string of numeric digits within a text stri
I've got some cells containing text. Somewhere inside each cell is a 6-digit
number, though not necessarily in the same location in each cell. (A few cells may be missing the number.) Is there some way using to find and extract the number using built-in functions? If not, how would I do it in a user-defined function? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Numeric from a Text String - Help? | Excel Discussion (Misc queries) | |||
| Formula to extract digits from a text string? | Excel Worksheet Functions | |||
| Find first numeric value in text string | Excel Worksheet Functions | |||
| Need insert a dash in between last 4 digits in text string | Excel Worksheet Functions | |||
| Search string for alpha or numeric | Excel Worksheet Functions | |||
Threaded Mode
