| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing text characters from a cell
volleygods wrote:
I need to find an easy function or macro to remove all text characters from a cell. EX. Pail=19KG converts to 19 =LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),ROW(INDIRECT("1:"&LEN(A1))))) Credit to Bob Phillips |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing extra characters in a cell | Excel Discussion (Misc queries) | |||
| Removing non text characters from spreadsheet | Excel Discussion (Misc queries) | |||
| Removing characters from a cell (keeping only the numbers) | Excel Discussion (Misc queries) | |||
| Removing text characters | Excel Worksheet Functions | |||
| removing some of the characters from a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
