Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a numerical value within a cell
I am trying to extract all the characters after a numerical value in a cell.
The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting numerical values within a cell | Excel Worksheet Functions | |||
Conditional Formatting; finding numerical data in mixed text. | Excel Discussion (Misc queries) | |||
In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
How can I insert numerical bullets in a cell ex: 1a) ? | Excel Discussion (Misc queries) | |||
Numerical characters in a cell | Excel Discussion (Misc queries) |