| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove all Characters Remains only Numeric Data
Hello Experts
I have Mobile No. in Column A1:A300000, But the Problem is that in Many Cell there are Unused and Special Character like Dash,comma,Slash, Doted Line. Slash Lines in Some Cell i have Mobile No. like A9810332270 or 9810332270F How can i delete these Data and Remains only Numeric Data Thanks in Advance Hardeep Kanwar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove alpha or non-numeric characters from cell | Excel Discussion (Misc queries) | |||
| determinant with non-numeric characters | Excel Discussion (Misc queries) | |||
| remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
| Removing Non-Numeric Characters | Excel Discussion (Misc queries) | |||
| "combo box- numeric characters" | Excel Discussion (Misc queries) | |||
![Hardeep kanwar[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
