| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To remove numbers in a cell with out using the macro
Dear All,
Consider a cell in which both Alphabet & numbers. I want to remove only the number from that cell. I have don this using the SUBSTITUTE Function. But i have to write the 10 subtitute fucntion in ten different cells. Is there any other method to do it. For example, in the cell a1, has the following text abv1234111f5ds4fsd54fds54fsdf4ds6111111111119802 Formula which i used in b1 to K1 cells =SUBSTITUTE(A1,1,"") and the answer is abv234f5ds4fsd54fds54fsdf4ds69802 =SUBSTITUTE(B1,2,"") and the result is abv34f5ds4fsd54fds54fsdf4ds6980 like this i used this formula. Is there is any other option to do this process in a single cell. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to remove space at front and end of a cell | Excel Discussion (Misc queries) | |||
| How to remove empty spaces in a cell with numbers? | Excel Worksheet Functions | |||
| How can I remove 4 of 9 numbers from a cell for the whole column? | Excel Discussion (Misc queries) | |||
| remove text from cell containing numbers | Excel Discussion (Misc queries) | |||
| How can I remove diff. numbers from a cell combined with text | Excel Discussion (Misc queries) | |||
Threaded Mode
