Try using ~~ as the find character

--
HTH

Bob Phillips

"Harleygrrl814" wrote in message
...
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" wrote:

Hello,

Try a Find/Replace, from the Edit menu.

--
Regards,
Zack Barresse, aka firefytr

"Harleygrrl814" wrote in
message
...
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