searching cells with more characters than are visible in the cell

[smak]

I know that a cell can contain 32,767 characters. and that the cell can only display 1024. the formula bar will show all 32,767 characters

if I have a cell that has 2000 characters, and I search for a term in that cell...will it be able to search the characters that only show in the formula bar?

 

[myall_blues]

Regardless of whether you use Find from the home tab on the ribbon or one of the search formulas (=FIND, =SEARCH) it will search the entire cell.

Regards

Murray

 

[smak]

I have read that formulas will only search the first 255 records when you use a formula. Is this the case or how is this different than =find searching the entire cell?

 

[Joe4]

I have read that formulas will only search the first 255 records when you use a formula. Is this the case or how is this different than =find searching the entire cell?

Seems like that should be something that you could easily test for yourself and find out.