I would like to know:

1 - How do you delete cells with dupicate content throughout an entire worksheet

2 - How do I delete cells that don't have certain criteria

Ex. I want to delete all cells that don't have the word "shoes". Or,
that do have the word shoes

3 - How do I filter all cells with certain criteria out from the rest.

Ex. I want to move all cells that have the word "trees" together and
separate from the rest of the cells - like at the top or bottom or to
another column.

All of these questions would require custom VBA programming code. Is
that what you are looking for?

Complete instructions on how to delete duplicates in ONE column are here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=135

If you have any VBA experience, perhaps you can edit that code to suit
your needs. ;)

If it's just for viewing purposes an 'Auto filter' will suffice for
some of your needs.

>Data >Filter >Auto Filter

Once you have the filter in place you can use the custom filter to
view words that don't contain a certain phrase (shoes), then select
them and delete!

Hi  jake8008,

1 - How do you delete cells with dupicate content throughout an entire worksheet

Ctrl + H (Replace)
Find What?:  Type whatever it is you want to delete
Replace With?: leave blank
By Rows or Columns (doesn't matter)
Replace All

2 - How do I delete cells that don't have certain criteria

Ex. I want to delete all cells that have the word shoes

Ctrl + H (Replace)
Find What?:  Shoes
Replace With?: leave blank
By Rows or Columns (doesn't matter)
Replace All

Hope this helps,
hummer

Do it with regular e expression.

A regular expression (regex or regexp for short) is a special text
string for describing a search pattern. You can think of regular
expressions as wildcards on steroids. You are probably familiar with
wildcard notations such as *.txt to find all text files in a file
manager. The regex equivalent is .*\.txt .

But you can do much more with regular expressions. In a text editor
like EditPad Pro or a specialized text processing tool like PowerGREP,
you could use the regular expression
\b[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,4}\b  to search for an email
address. Any email address, to be exact.

Regards