Excel help!!!!!

[sportsfisher]

Hi one and all
Just a quick for anyone who is in the know!

I have an excel spreadsheet with a list of about 25,000 items in it. I want to remove any data that doesn't contain a certain symbol (eg "@") without having to search all the way down the column.

Any one out there know how to do this?

Help!

 

[DavenHelen]

Select entire List, go to Data -> Filter -> click on Autofilter.

Click Down Arrow in Top Line in field you are interested in. Select Custom then select Does Not Contain in Left Field and @ in Right Field for example. Then click Ok.

You should now have a list of all records without an @. Select and Delete.

 

[Aja]

Ctrl+F will give you a 'Find and Replace' box.

Put in the '@' in the Find Section and ' ' in the replace section.

You may have to play about a bit - but should work.

Donald

Just re-read OP. Ignore me and I'll go away.

 

[Jonny_H]

Use the Autofilter tool ('Data' > 'Filter' > 'Autofilter' whilst you have selected the top row of the data), the filter using the 'Custom' Option and Select 'Contains' in the first box and then type your criteria in the second box, ie '@'.

You will then only see the data with the '@'

Alternatively, you can filter for items that 'Does not Contain' the '@' and then delete them.

Hope this helps

Jonny


Edit - Always to slow!!! /forums/images/graemlins/ooo.gif

 

[sportsfisher]

Thanks guys!

I might get home in time for a quick pint in the pub now!!!

 

[stephenh]

auto filter is a funny one, for me at least , and I learned at my (large) cost ALWAYS save an unfiltered copy first !!!

good luck

 

[exfinnsailor]

Sounds like an email list .. Cross me off .. Dont want any SPAM /forums/images/graemlins/smile.gif