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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> escribió en el
mensaje news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> escribió en el
> mensaje news:[email protected]...
>> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
message
> > news:[email protected]...
> > > 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
> >
> >
> >

Edit>Replace

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"
<[email protected]> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> escribió en el
> > mensaje news:[email protected]...
> >> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> escribió en
>> > el
>> > mensaje news:[email protected]...
>> >> 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
>> >
>> >
>>
>>
>>