{"id":5180,"date":"2020-04-22T14:49:46","date_gmt":"2020-04-22T14:49:46","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=5180"},"modified":"2024-03-28T13:26:42","modified_gmt":"2024-03-28T13:26:42","slug":"remove-character-from-string","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/remove-character-from-string\/","title":{"rendered":"Remove Character from String in Excel"},"content":{"rendered":"\n
There are a few ways you can remove characters from cells in Excel. You can do it from the ribbon, using the formula, or the VBA code. You can get rid of a single, or multiple characters.<\/p>\n\n\n\n
The Find and Replace<\/strong> feature is the most straightforward way to replace the character. You can also use it to remove a character by replacing a searched character with a space. Here’s how it works:<\/p>\n\n\n\n This example shows a list of names separated by commas:<\/p>\n\n\n\n