Excel How to Remove Numbers and Text

 
 

Home

Copyright 2014 - 2021 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home
Remove text or numbers or symbols from cells in Excel

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 Text Or Numbers
Excel Remove Text Or Numbers
Excel Remove Text Or Numbers
  • Remove all 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 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
Dose for Excel

Dose for Excel adds more than +100 new features and functions to your Excel.
Supported Excel versions: 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 14 days.

Dose for Excel
Dose for Excel
 











 
  • Demo

Download Dose for Excel
HOME        PRODUCTS        INSTALLATION GUIDE        EXCEL TEMPLATES        EULA        AFFILIATES        SUPPORT        ABOUT US
 
  • Remove 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 Numbers with Period
Excel Remove Numbers with Period
Excel Remove Numbers with Period


Excel Remove Only Numbers
Excel Remove Only Numbers
Excel Remove Only Text
Excel Remove Only Text
 
  • Remove all 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
Excel Remove Only Text Capital Letters
Excel Remove Only Text Capital Letters
 
  • Remove all 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
Excel Remove Only Text Small Letters
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
Excel Remove Only Non Numeric
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
Excel Remove Only Non Alpha
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 break, , etc...) from selected cells.
2. Then click Remove. You will see the result as shown in the below screenshot.
Excel Remove Only Non Printing
Excel Remove Only Non Printing
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
Excel Remove Only Non alphanumeric
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
Excel Remove Only Custom Chars
Excel Remove Only Custom Chars

Dose for Excel 75% OFF
Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%   Mega Discount 75%