Browse » Home
Wednesday, December 12, 2012
How to Remove Characters in Excel 2007
1. Open your spreadsheet and select all cells from which you want to remove the character string.
2. Click the 'Home' tab and click 'Find Select' in the 'Editing' group. Click 'Replace' to open a Find and Replace dialog box.
3. Type the character or string of characters that you want to eliminate in the 'Find what' field.
4. Type the new characters that you want to insert in place of the removed characters in the 'Replace with' field. If you simply want to delete the characters, then don't type anything in this field.
5. Click the 'Find Next' button if you want to perform the search-and-replace function manually.
6. Click 'Replace All' to remove all instances of the specified characters in the selected cells.