Delete all occurrences of a character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all! I have a spreadsheet of customer information broken up into 5
different columns. In the first column, "customer name", all the names are
followed by the "~" character. I'm hoping there's a way to delete all
occurrences of this character without manually removing each one.
Thanks!
Katie
 
Use the Edit > Replace... in the FIND field type your undesired character
and in the REPLACE WITH field do not type anothing .. push REPLACE ALL
 
Thanks for the quick reply! I tried that but I must be doing it wrong,
because it says it can't find any data to replace. And really, there is
nothing I want to replace it with, I just want the names with nothing else.
thanks
kt
 
Also make sure you SAVE your work FIRST! After you perform the
Find/Replace, if it's not what you want, you have the option of Undo'ing or
closing w/o saving.
 
Edit>Replace

what: ~~

Note the double ~~. The tilde(~) is a wildcard character.

with: nothing


Gord Dibben Excel MVP
 
Back
Top