search on an excel sheet

[nickee33]

Hi all

I want to set a function on a cell that will look on a sheet for a wor
or number and place this word or number in an other cell
I hope someone will understand what I am looking for

Thank yo

 

[Kathy]

Try this,
=search(find_text,within_text,[start_num])
Good Luck