Function limitation

[JayL]

All -
Using the following function..=MATCH(CONCATENATE("*",A9,"*"),D321,0)
The D3 - D21 range consists of text only. Some cells contain 300 +
characters and some less than 100.
The function works fine on the lower character count cells but not on the
higher.
Is there a limitation in the function(s) I'm not aware of?

-TIA
-Jay

 

[Peo Sjoblom]

The max is 255 characters, Btw, no need really for the CONCATENATE, it is a
superfluous function, the same formula can be written

=MATCH("*"&A9&"*",$D$3:$D$21,0)