Quickly remove numeric, alphabetic, non-printable or alphanumeric characters from cells

In Excel, sometimes you may need to remove or delete numeric, alphabetic, non-printable or alphanumeric characters from text strings or cells. Normally there is no handy way for you to remove those specific characters easily in Excel. But with the Kutools for Excel's Delete Characters utility, you can easily apply the following operations:

Remove numeric characters from cells

Remove alphabetic characters from cells

Remove non-numeric characters from cells

Remove non-alphabetic characters from cells

Remove non-printable characters from cells

Remove non-alphanumeric characters from cells

Remove customized characters from cells

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

arrow blue right bubble Click Kutools >> Text Tools >> Delete Characters. See screenshots:

shot-remove-specific-characters1arrow-bigshot-remove-specific-characters2

arrow blue right bubbleRemove numeric characters from cells

In a worksheet, there are a range of cells which mixed with alphabetic and numeric characters, and now you want to only delete the numeric characters from the text strings. Tip: Numeric characters means a character used to represent a number, such as, 1, 2, 3. For example, you need to convert Jane Green 001 to Jane Green, you can get it as follows:

1. Select the range that you want to remove the numeric characters from cells.

2. Apply this utility by clicking Kutools > Text Tools > Delete Characters.

3. In the Delete Characters dialog box, check Numeric option, and you can preview the results in the Preview Pane. See screenshot:

shot-remove-specific-characters3

4. Then click OK or Apply, the numeric characters have been deleted. (Note: click OK button will close the dialog box and apply the operation; but click Apply button will only apply the operation without closing the dialog box.) See screenshots:

shot-remove-specific-characters4arrow-bigshot-remove-specific-characters5

arrow blue right bubbleRemove alphabetic characters from cells

Supposing you have a range of text strings such as America 1234567@2212,and you need to remove only alphabetic characters from the string. Tip: Alphabetic characters are letters of the alphabet (as opposed to numeric characters, which are numbers). Please do as follows:

1. Select the range that you want to remove the alphabetic characters from cells.

2. Go to the Delete Characters dialog box, check Alpha option, and you can preview the results in the Preview Pane. See screenshot:

shot-remove-specific-characters6

3. Then click OK or Apply, the alphabetical characters have been removed. See screenshots:

shot-remove-specific-characters7arrow-bigshot-remove-specific-characters8

arrow blue right bubbleRemove non-numeric characters from cells

If you have a range of cells containing alphabetic, numeric and other characters, and now you need to remove all non-numeric characters and only keep the numeric characters in the cells. For example, to change America 34-12234@2212* to 34122342212 after removing non-numeric characters. You can do it as follows:

1. Highlight the range that you want to remove the non-numeric characters.

2. Go to the Delete Characters dialog box, check Non-numeric, and you can preview the results in the Preview Pane. See screenshot:

shot-remove-specific-characters9

3. Then click OK or Apply, the non-numeric characters have been removed. See screenshots:

shot-remove-specific-characters10arrow-bigshot-remove-specific-characters11

arrow blue right bubbleRemove non-alphabetic characters from cells

With this multifunction utility, you can remove non-alphabetic characters (remove all characters except the alphabetic characters) and only keep alphabetic characters in the cells. Tip: Alphabetic characters are letters of the alphabet (as opposed to numeric characters, which are numbers).

1. Highlight the range that you want to remove the non-alphabetical characters.

2. Go to the Delete Characters dialog box, check Non-alpha, and you can preview the results in the Preview Pane. See screenshot:

shot-remove-specific-characters12

3. Then click OK or Apply, the non-alphabetical characters have been removed. See screenshots:

shot-remove-specific-characters13arrow-bigshot-remove-specific-characters14

arrow blue right bubbleRemove non-printable characters from cells

When you paste some information from other application into cells, maybe there will be some non-printable characters together with the data. If you need to remove non-printable characters from cells, you can do as follows:

1. Select the range that you want to delete the non-printable characters.

2. Go to the Delete Characters dialog box, check Non-printing, and you can preview the results in the Preview Pane. See screenshot:

shot-remove-specific-characters15

3. Then click OK or Apply, the non-printable characters have been removed. See screenshots:

shot-remove-specific-characters16arrow-bigshot-remove-specific-characters17

arrow blue right bubbleRemove non-alphanumeric characters from cells

Sometimes, there are some specific characters such as $#@*{} neither are alphabetical characters nor numeric characters between the text strings of the range of cells. But you need to get rid of the specific characters and leave the alphanumeric characters, with this tool, you can easily get it done.

1. Select the range that you want to delete the non-alphanumeric characters.

2. Go to the Delete Characters dialog box, check Non-alphanumeric, and you can preview the results in the Preview pane. See screenshot:

shot-remove-specific-characters18

3. Then click OK or Apply, the non-alphanumeric characters have been removed. See screenshots:

shot-remove-specific-characters19arrow-bigshot-remove-specific-characters20

arrow blue right bubble Remove customized characters from cells

With this utility, you can also customize to remove specific characters from the text strings. Do as the following steps:

1. Select the range that you want to delete the specified characters.

2. Go to the Delete Characters dialog box, check Custom, and enter the characters that you want to remove. You can preview the results in the Preview pane. See screenshot:

shot-remove-specific-characters21

3. Then click OK or Apply, the characters in the custom box have been removed. See screenshots:

shot-remove-specific-characters22arrow-bigshot-remove-specific-characters23

arrow blue right bubbleNote:

This utility supports Undo (Ctrl+Z).


arrow blue right bubble This is just one of 120 powerful features of Kutools for Excel

It includes more than 120 advaned functions and tools for Excel 2007, 2010 and 2013 (includes Office 365).



btn read more     btn download     btn purchase

Add comment


Security code
Refresh