Problem with find

[DRFLETT]

Hi

I have a spreadsheet with a column with a large amount of text (copied and pasted from word for reference).

When i use the find function, very often it doesnt find cells that have the text within.

Any ideas why this might be happening? and how to stop it!

Thanks in advance

Andy

[martindwilson]

if it doesn find them for some reason they dont match try copying some of the text and try to find it. make sure match in entire cell and match case arent checked.
failing that post a sample of what you cant find?