You can remove only text and keep numbers in Excel’s range or remove symbols and keep text or vice versa or even remove non alpha, non numeric, non alphanumeric and non printing. Dose for Excel‘s Remove Characters utility can remove anything you want from Excel cells with one click on huge Excel sheets.
- Remove only numbers
- Remove numbers with period
- Remove all text
- Remove all text (Capital Letters)
- Remove all text (Small Letters)
- Remove only non-numeric
- Remove only non-alpha
- Remove only non-printing
- Remove only non-alphanumeric
- Remove only custom chars
Click DOSE » Text » Remove Characters

Remove only numbers
- Select range of cells, and check Numeric option to remove only numbers from selected cells and keep the remaining characters.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only numbers with period
- Select range of cells, and check Numeric option to remove numbers with period from selected cells and keep the remaining characters.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only text
- Select range of cells, and check Alpha option to remove All Alpha text from selected cells and keep the remaining characters.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only text (Capital Letters)
- Select range of cells, and check Alpha option to remove Capital Letters from selected cells and keep the remaining characters.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only text (Small Letters)
- Select range of cells, and check Alpha option to remove Small Letters from selected cells and keep the remaining characters.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only non numeric
- Select range of cells, and check Non-numeric option to remove anything and keep numbers from selected cells.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only non alpha
- Select range of cells, and check Non-alpha option to remove anything and keep text from selected cells.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only non printing
- Select range of cells, and check Non-printing option to remove non printing symbols and chars (eg. Carriage return, line feed, tab, backspace, null character, ASCII control characters, DEL – delete, line separator, paragraph separator, ¶, €, ž, etc.) from selected cells.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only non alphanumeric
- Select range of cells, and check Non-alphanumeric option to remove everything and keep text and numbers from selected cells.
- Then click Remove. You will see the result as shown in the below screenshot.

Remove only custom chars
- Select range of cells, and check Custom option to remove certain chars you specify from selected cells.
- We will remove for example the chars @_
- Then click Remove. You will see the result as shown in the below screenshot.

Demo
More Features:
How to Remove Leading Or Trailing Or Extra Spaces In Excel
Remove Leading Or Trailing Or Extra Spaces From Excel Cells You can remove leading spaces,…
Excel Reading Layout View
Excel Reading Layout If you have a lot of data at your Excel sheet, then…
Excel Work Area View
Excel Work Area If you have many data in Excel sheet cells, and want to…
How To Convert Numbers To Words In Excel
Convert numbers to words in Excel Converting numerical values into words in Excel holds significant…
How to Change Text Case In Excel
Change Case Of Excel Cells Text Change case of text in selected cells in Excel…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…