| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stripping text from numbers in a cell
Hi All
I did a search in the archives for a way to strip all occurences of text from a cell of numbers, eg, A3F4DR5V1, would end up being 3451. I found a post from Bob Phillips ( thanks Bob),with the following formula: =LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),ROW(INDIRECT("4:"&LEN(A1))))) but it doesn't work, I've tried using CSE but I still get a #N/A error. Can anybody please tell me where it's not working. I can do it with code but would rather keep the OP away from macros. Regards Michael M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stripping text before a number (alpha or numeric) | Excel Worksheet Functions | |||
| adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
| Add numbers accross columns after stripping away text | Excel Discussion (Misc queries) | |||
| Stripping section of text | Excel Worksheet Functions | |||
| Stripping mixed number and text | Excel Worksheet Functions | |||
Threaded Mode
