Excel How to Remove Numbers and Text


 
 
 

Home
HOME           PRODUCTS           EULA           AFFILIATES           SUPPORT           ABOUT US

Copyright 2014 - 2018 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. 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 only text (A-Z)

1. Select range of cells, and check A-Z option to remove 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

Excel Remove Only Text
Excel Remove Only Text
  • Remove only numbers (0-9)

1. Select range of cells, and check 0-9 option to remove 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

Excel Remove Only Numbers
Excel Remove Only Numbers
  • Remove all except characters and numbers

1. Select range of cells, and check All except characters and numbers option to remove anything but text and 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 All Except Text And Numbers

Excel Remove All Except Text And Numbers
Excel Remove All Except Text And Numbers
Dose for Excel

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

Dose for Excel
Dose for Excel