Remove lines with +++

[shawn]

Is there anyway to find any line that has a + in it and delete that whole
line?!

I'd also like to do the same for *.

I have a list of about 1300-1500 names and addresses. Some of them have a
few +++ next to the name and some of them have a few *** next to the name.
These were put there by the company to designate things. They need to be
removed from the list, but it's a lost of work doing it one by one.

 

[Pete_UK]

You could apply an autofilter to the column with these characters in
and from the pull-down select Custom - in the panel choose
"Contains" (scroll down for this) then enter +++. Then highlight all
the rows which are visible and Edit | Delete Row. Repeat looking for
the other characters, then finally select All from the filter pull-
down.

Hope this helps.

Pete

 

[MartinW]

Hi Shawn,

Try Edit>Replace
Find what: +
Replace with: (leave this blank)
Click replace all

Find what: ~*
Replace with: (leave this blank)
Click replace all

HTH
Martin

 

[MartinW]

Ignore that. I misread your post.

Hi Shawn,

Try Edit>Replace
Find what: +
Replace with: (leave this blank)
Click replace all

Find what: ~*
Replace with: (leave this blank)
Click replace all

HTH
Martin

 

[Dave Peterson]

Just to add to Pete_UK's advice.

You can look for "ends with", too (if those characters are at the end of the
string).

And when you're looking for ***, you'll have to look for: ~*~*~*

Asterisks are wild cards and the way you tell excel that you really want the
asterisk (not the wildcard), is to put a tilde (~) in front of it.

Same thing with
? use ~?
* use ~*
~ use ~~

 

[Pete_UK]

Dave,

you can call me Pete <bg>

Pete

Just to add to Pete_UK's advice.

You can look for "ends with", too (if those characters are at the end of the
string).

And when you're looking for ***, you'll have to look for: ~*~*~*

Asterisks are wild cards and the way you tell excel that you really want the
asterisk (not the wildcard), is to put a tilde (~) in front of it.

Same thing with
? use ~?
* use ~*
~ use ~~








--

Dave Peterson- Hide quoted text -

- Show quoted text -