Can't Find & Replace ~ 2

[APElliott]

Hello,

Is there a way to replace this character "~"!

I can't get rid of it in my excel workbook unless I manually delete each one!

Thanks,

Andrew

 

[dyarwood]

Where is the ~ symbol occuring? Might it be possible to filter for things not containing or not equal to ~ then copy the sheet into another sheet?

dyarwood

 

[APElliott]

Hello,

I've imported some data that we've been sent and the ~ symbol appears in situations like this (~Approximate Quantity~), ~Pairs~, ~In 75Nr~!

I've tried to filter on data that contains ~ but it isn't recognised!

Help

 

[dyarwood]

If you use the following macro it will remove all cells which equal ~ in the first column.

Range("A1&quot.Select
Do Until IsEmpty(ActiveCell)
If ActiveCell.Value = "~" Then
ActiveCell.Value = ""
ActiveCell.Offset(1, 0).Select
Else
ActiveCell.Offset(1, 0).Select
End If
Loop


If the ~ symbol is in other columns you could add in a second loop to move across the columns.

dyarwood

 

[KenWright]

Precede your ~ with a ~. Same goes fo any wildcard character, so Edit Find:-

~~
or
~?
or
~*

etc

Regards
Ken...........

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[MakeItSo]

Excel-lent, Ken! Starry..
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[APElliott]

Cheers Ken,

Doubling up on the characters works perfect.

I'd already tried the ? and * after the symbol, but without success!

Thanks

Andrew

 

[KenWright]

Make sure you are not just doubling the characters though. Each wildcard character regardless of what it is, needs to be preceded with a tilde ~

Regards
Ken................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------