Eliminate cells

**TORINO7** · 03-08-2011, 04:41 PM

I need to eliminate cells that not have the @ simbol on a column list.
I use excel 2007
thanks

**NBVC** · 03-08-2011, 04:51 PM

Do an Autofilter from Data menu, and select Does Not Contain >> @ then delete those rows.

**TORINO7** · 03-08-2011, 06:22 PM

I can not find the the autofilter from the data menu

**TORINO7** · 03-08-2011, 06:52 PM

I can not find the the autofilter from the data menu

**NBVC** · 03-09-2011, 08:47 AM

What version of Excel are you in?

In XL2003 and below, go to Data|Filter|Autofilter

in XL2007 plus, go to Data tab, and click the larger Filter funnel icon.

P.S. Please update your profile to include your location and your version. This will help us in the future to help you.