hi Phire

I'm pleased Windknife has been able to give you a solution (& shown you how the Search function can be used).

Quote Originally Posted by phire View Post
Hi there,
I've uploaded an example of i want to do. My problem in using the Search or Find functions is that they are case sensitive, and my source data has titles (Miss, Mr.).
Again, thanks for the help.

To clarify/correct your above comments for others who may read this post looking for solutions to their own problems, here's a quote from the Help files for Excel 2000:
FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text. You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn't allow wildcard characters.
Rob