Dave,

Thanks for the help however this formula is not working. I am looking
in one column 20000 + rows long for a part of a few words, example:

Woodman Park Apartments or Woodman Park Apts

I am looking for the word Apartments or Apts. That word(s) will not be the
only word in any of the cells. If it is not true, I want it to leave the
cell alone. If true, to paste it to a new cell (same row) one column over. Do
you have a formula that would look for either word?

Thanks. I am a relativly new to formulas.
Regards, Ben


"Dave Peterson" wrote:

Maybe you could use a formula instead of the edit|Find.

Say your data is in Columns A:E and you were looking for Ben in any cell in that
range, you could use a formula like this:

=if(countif(a1:e1,"Ben")0,"Ben","")
and drag down

This formula will count the cell only if Ben is the only thing in that cell. If
Ben is in that cell with other stuff like "Benny and June", you could use a
different formula:

=if(countif(a1:E1,"*ben*")0,"Ben","")
and drag down



Ben wrote:

Does anyone know how I can paste the find all into a new column in the same
corasponding row number? I did a copy from the "Findfind all" list by right
clicking the list then do "copy". Those cells (non-adjacent cells) get
highlighted but when I past it in the next column to the same row it pastes
the list in order not in the correct cell. Must I use formulas to do this and
if so which formula? HELPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP!

thanks

--

Dave Peterson