Darren, 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. Do you have a formula that would look for
either word?

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

"DARREN FONG via OfficeKB.com" wrote:

Ben,

you could try an "IF" formula in the next collumn

i.e

=IF(A1="your text to find",your text to find,"")

then edit/fill/down

and then possibly to remove the formulas

edit/copy

edit/pastespecial/values

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200512/1