Control F question

[JinaS]

I cut and paste data from PDF and I am trying to use control F but cannot find the data. However, the words or numbers I am looking for is in the spreadsheet.

I changed the Look in: to Values and Find What: Preview* Format but still did not worked.

 

[Andrew Poulsom]

Welcome to MrExcel.

Are you sure that you have the right settings for 'Match case' and 'Match entire cell contents'?

 

[JinaS]

Welcome to MrExcel.

Are you sure that you have the right settings for 'Match case' and 'Match entire cell contents'?

Yes, I do.

 

[JinaS]

Yes, I do.

I unchecked the Match Cade and match entire cell contents and it works now. Thank you.

 

[Andrew Poulsom]

Can we see some sample data where Find isn't working please, and what was being looked for?