It is often necessary to replace characters within a string in Excel with other characters. Or you may want to remove some characters entirely. There are several ways to do this but by far the easiest method is to use the built-in replace tool.

For example, you have the following in a cell:


You want to remove the hyphens from the cell. To do this, select the cell and press ctrl+H. The replace tool will pop up. In the “find what” line put your -. in the “replace with” line, you have several options. To remove them and them entirely, leave “replace with” blank. This will give you 6105552904. To leave the space but remove the hyphen you would enter ” “.

Joseph Harris
Excel Help

If you found this article helpful, buy me a cup of coffee!

Related posts:

  1. Using Right() and Left() Functions to Remove Text from a String – Excel Today I came across a problem I see at least...
  2. Removing the Auto Hyperlink Option in Excel Today a colleague told me they were going crazy because...
  3. Removing Macros from a Workbook Q: How do I remove all the macros from my...
  4. Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...

This entry was posted on Tuesday, March 3rd, 2009 at 3:08 pm and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.