Delete all occurrences of a character
 

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

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

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" escribió en el
mensaje ...
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

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

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.

--
Regards,
Zack Barresse, aka firefytr

"Carlos Medrano" wrote in message
...
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" escribió en el
mensaje ...
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

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

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

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

"Zack Barresse" wrote:

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.

--
Regards,
Zack Barresse, aka firefytr

"Carlos Medrano" wrote in message
...
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" escribió en el
mensaje ...
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

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

--
Regards,
Zack Barresse, aka firefytr

"Harleygrrl814" wrote in message
...
It worked!! Thank you thank you thank you everyone!!
-Katie

"Zack Barresse" wrote:

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.

--
Regards,
Zack Barresse, aka firefytr

"Carlos Medrano" wrote in message
...
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" escribió en
el
mensaje ...
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