Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to remove all instances of a character in Excel range?

Have you ever tried to remove all instance of a character in a range or the whole sheet in Excel? Do you still remove this specific character one by one manually? In this tutorial, I introduce some tricks on quickly removing all instances of a specific character in Excel.

Remove all instance of a character with Find and Replace

Remove all instance of a character with Remove Charactersgood idea3

Enable you to do smarter, faster and better

Kutools - the best office productivity tool brings 300 advanced features to Excel. Details... Download...

Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...


Remove all instance of a character with Find and Replace


In Excel, the Find and Replace function can quickly find a character and replace it with blank or other contents in a selection or the whole sheet.

1. Select the range you need and press Ctrl + H to enable the Find and Replace dialog, and type the character you want to remove into the Find what textbox, leave nothing in the Replace with dialog. See screenshot:
doc remove instance of character 1

2. Click Replace All, a dialog pops out to remind you the characters have been removing. See screenshot:
doc remove instance of character 2

3. Click OK > Close. Then all instances of “A” have been removed from the selection.

doc remove instance of character 3 shot arrow right doc remove instance of character 4

Remove all instance of a character with Remove Characters

Actually, with Kutools for Excel’s Remove Characters utility, you can more quickly and easily remove all instance of one specific character.

Kutools for Excel, with more than 120 handy functions, makes your jobs easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Select the range you need to work, and click Kutools > Text > Remove Characters. See screenshot:
doc remove instance of character 5

2. Then in the Remove Characters dialog, check Custom option, and type the character you want to remove into the textbox. See screenshot:
doc remove instance of character 6

3. Click Ok or Apply, all the instance of the character has been removed in the selection.

doc remove instance of character 3 shot arrow right doc remove instance of character 4

Tip: with this utility, you can remove non-numeric characters, or non-alpha characters and so on.


Relative Articles



Excel Productivity Tools

Kutools for Excel - The Best Office Productivity Tool

  • Brings 300 powerful advanced features to Excel, enable you to do smarter, faster and better.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Office Tab - brings tabbed interface to Office, make your work much easier.

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.