| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove number from text string
Hi,
With your number in A1 try this =LOOKUP(10^100,--MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"01234567 89")),ROW(INDIRECT("1:"&LEN(A1))))) Mike "adunao" wrote: Please how do I remove numbers from unformatted texts strings e.g DEPOSIT RICA MARINE 6890312 RICA MARINE or DEPOSIT 7048783 KURUS NIG or DEPOSIT 7042248 NNAJI 7042248 NNAJI Pls I need a plobal formula for these |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Remove number from string in excel | Excel Discussion (Misc queries) | |||
| remove text from string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Linear Mode
