EditReplace

what: ~~

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

with: nothing


Gord Dibben Excel MVP

On Mon, 9 May 2005 15:54:03 -0700, "Harleygrrl814"
wrote:

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