Excel How to Remove Only Text Or Only Numbers

Remove text or numbers or symbols from cells in Excel

Excel How to Remove Text Only Or Numbers Only

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.

Click DOSE » Text » Remove Characters

Excel Remove Only Text Or Only Numbers

Remove only numbers

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

Remove only numbers with period

  1. Select range of cells, and check Numeric option to remove numbers with period from selected cells and keep the remaining characters.
  2. Then click Remove. You will see the result as shown in the below screenshot.
Excel Remove Only Numbers With Period

Remove only text

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

Remove only text (Capital Letters)

  1. Select range of cells, and check Alpha option to remove Capital Letters from selected cells and keep the remaining characters.
  2. Then click Remove. You will see the result as shown in the below screenshot.
Excel Remove Only Text Capital Letters

Remove only text (Small Letters)

  1. Select range of cells, and check Alpha option to remove Small Letters from selected cells and keep the remaining characters.
  2. Then click Remove. You will see the result as shown in the below screenshot.
Excel Remove Only Text Small Letters

Remove only non numeric

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

Remove only non alpha

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

Remove only non printing

  1. 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.
  2. Then click Remove. You will see the result as shown in the below screenshot.
Excel Remove Only non printing

Remove only non alphanumeric

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

Remove only custom chars

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

Demo


More Features:

Excel Compare Sheets

Compare Sheets In Excel Comparing Excel sheets will take long time if doing it manually,…

Excel Backup Settings

Auto Backup Excel Workbooks Save time by auto backup your Excel files automatically once the…

Excel Split

In Excel, split the first and last word, or divide them by a delimiter or…

Excel Clean Data

Clean Data In Excel Clean data in huge Excel sheets could take long time doing…

Excel Export Sheets

Export Sheets Separately In Different Formats In Excel Exporting from sheets from Excel using Excel…


Scroll to Top