Remove Numeric, Alphabetic, Non-Printable Or Alphanumeric Characters From Cells in Excel 365!!
Tags: kutoolsexceltutorial, removenumericoralpha, kutools
Published: 2020-11-16 07:28:10

---
title: Remove Numeric, Alphabetic, Non-Printable Or Alphanumeric Characters From Cells in Excel 365!!
published: true
date: 2020-11-13 10:44:22 UTC
tags: KutoolsExcelTutorial,RemoveNumericorAlpha,Kutools
canonical_url: https://geekexcel.com/remove-numeric-alphabetic-non-printable-or-alphanumeric-characters-from-cells-in-excel-365/
---

In this guide, we are going to see how to **Remove Numeric, Alphabetic, Non-Printable, or Alphanumeric Characters From Cells** in **Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Remove Numeric Characters:

If you want to remove numeric characters from the text strings, do as follows.

- You need to **select the range** that you want to remove the numeric characters from cells.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-21.png)<figcaption id="caption-attachment-17330">Input range</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters –** You need to **select** the **Numeric** option.
- You can see the results in the **Preview** pane as shown in the below screenshot.

![Remove Characters Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-20.png)<figcaption id="caption-attachment-17331">Remove Characters Dialog Box</figcaption>

- Finally, **click** the **OK** button. You can see that the numeric characters have been deleted.
- Refer to the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-15.png)<figcaption id="caption-attachment-17332">Result</figcaption>

## Delete Alphabetic Characters:

To delete alphabetic characters from the text strings, do as follows.

- You need to **select the range** that you want to remove alphabetic characters.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-14.png)<figcaption id="caption-attachment-17334">select the range</figcaption>

- On the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters – **** Select **the** Alpha** option.
- You can preview the output in the **Preview pane.**
- **Hit** the **OK** button.

![Remove Characters Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-17.png)<figcaption id="caption-attachment-17335">Remove Characters Dialog Box</figcaption>

- Now, the alphabetic characters have been removed as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-8.png)<figcaption id="caption-attachment-17336">Output</figcaption>

## Remove Non-numeric Characters:

In this section, you will see the steps to delete non-numeric characters from text strings.

- You need to **select the input range** that you want to remove non-numeric characters.

![select the input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-13.png)<figcaption id="caption-attachment-17337">select the input range</figcaption>

- On the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters –** You need to **select the Non-numeric** option.
- You can preview the results in the **Preview pane**.
- Then, **click** the **OK** button.

![Remove Characters Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-11.png)<figcaption id="caption-attachment-17338">Remove Characters Dialog Box</figcaption>

- Finally, you can see that the non-numeric characters have been removed as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-11.png)<figcaption id="caption-attachment-17339">Result</figcaption>

## Delete Non-alphabetic Characters:

To remove non-alphabetic characters such as numbers & special Characters from the text strings, do the below steps.

- You need to **select the range** that you want to remove the non-alphabetical characters.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-8.png)<figcaption id="caption-attachment-17340">select the range</figcaption>

- On the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters – **** Select **the** Non-alpha** option.
- You can preview the results in the **Preview** pane.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-8.png)<figcaption id="caption-attachment-17341">Hit the OK button</figcaption>

- At last, **click** the **OK** button to get the result.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-5.png)<figcaption id="caption-attachment-17342">Result</figcaption>

## Remove Non-printable Characters:

If you want to delete non-printable characters from cells, then follow the below instructions.

- Firstly, you need to **select the range** that you want to remove the non-printable characters from cells.

![Input](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-4.png)<figcaption id="caption-attachment-17344">Input</figcaption>

- On the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters – ** You need to **select** the **Non-printing** option.
- You can preview the results in the **Preview** pane.
- Then, **click** the **OK** button.

![Remove Characters Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-4.png)<figcaption id="caption-attachment-17345">Remove Characters Dialog Box</figcaption>

- Now, you can see the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-4.png)<figcaption id="caption-attachment-17346">Output</figcaption>

## Delete Non-alphanumeric Characters:

Here are the steps to delete non-alphanumeric characters such as **$#@\*{}** from the cells. Follow the below steps.

- You need to **select the range** where you want to remove the non-alphanumeric characters.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/16-3.png)<figcaption id="caption-attachment-17347">Input range</figcaption>

- On the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters – **** Choose **the** Non-alphanumeric** option.
- You can preview the results in the **Preview** pane.
- Then, **click** the **OK** button.

![Remove Characters Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/17-3.png)<figcaption id="caption-attachment-17348">Remove Characters Dialog Box</figcaption>

- You can see the output as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/18-3.png)<figcaption id="caption-attachment-17349">Result</figcaption>

## Remove Customized Characters:

You can also remove specific characters from your text strings. To do this, follow the below steps.

- You need to **select the input range** that you want to delete the specified characters.

![select the input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/19-3.png)<figcaption id="caption-attachment-17350">select the input range</figcaption>

- On the **Kutools Tab, select** the **Text** option, then **choose** the **Remove Characters** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-7.png)<figcaption id="caption-attachment-17329">Kutools Tab</figcaption>

- It will open the **Remove Characters Dialog Box**.
- **Remove Characters – ** You need to **select** the **Custom** option and **type** the **characters** that you want to remove from the cells in the given **text box.**
- You can preview the results in the **Preview** pane.
- Then, **click** the **OK** button.

![Remove Characters Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/20-3.png)<figcaption id="caption-attachment-17351">Remove Characters Dialog Box</figcaption>

- Now, the characters given in the custom box have been removed as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/22-2.png)<figcaption id="caption-attachment-17353">Output</figcaption>

## End of the Article:

In this guide, you can easily understand the steps to **Remove Numeric, Alphabetic, Non-Printable, or Alphanumeric Characters From Cells** in **Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [How to Find Specific Text Strings Only in the Comments in Excel?](https://geekexcel.com/how-to-find-specific-text-strings-only-in-the-comments-in-excel/)
- [Select Multiple Items from the Drop-down Lists in Excel](https://geekexcel.com/how-to-select-multiple-items-from-the-drop-down-lists-in-excel/)