Find Function With Cells contains large text

[Taisir]

Dear friends,
Can somebody explain and provide a solution for this annoying problem for me?

The Find Function (Ctrl+F) cannot find the names I am looking for when the cell contains large number of text.

Column A in the attached, contains the sample that I exported from a database to Excel. When searching for the names in column C, in Column A, the Find Function (Ctrl+F) returns nothing although the names exist in the cells, but toward the end of the content.

Any solution or advice?

Thanks

[CK76]

It does find it on my system.

Make sure you set option like below.
0.JPG

Edit: It's especially important to set "Look in:" to Values, and uncheck "Match entire cell contents"

[TMS]

It's only not finding them because they're not there. This works for me:

Please Login or Register  to view this content.

A couple were missing, and the last cell in the author list was blank. If I added the relevant names at the end of the cell, they were picked up.

[Taisir]

Dear CK76

Indeed, the "Look kn" was "Formulas". Many thanks for the quick response and advice.
All the best Taisir

[Taisir]

Thanks TMS for the formula.

I was tring to find how many times the name "Murray, CJL" appears in column A, and "Zenebe, ZM" in clomn A etc.
Apparantly, the "Look in" setup of the Find fuction was not correct as explained by CK76 above. Thank you.

[TMS]

You're welcome. Thanks for the rep.