Delete all occurrences of a character

[Harleygrrl814]

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

 

[Zack Barresse]

Hello,

Try a Find/Replace, from the Edit menu.

 

[Carlos Medrano]

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

 

[Harleygrrl814]

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

 

[Zack Barresse]

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.

 

[Bob Phillips]

Try using ~~ as the find character

 

[Gord Dibben]

Edit>Replace

what: ~~

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

with: nothing


Gord Dibben Excel MVP

 

[Harleygrrl814]

It worked!! Thank you thank you thank you everyone!!
-Katie

 

[Zack Barresse]

Thanks for letting us know Katie! Glad you got it working!!