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)


--

Regards,

Peo Sjoblom



"JayL" wrote in message
...
All -
Using the following function..=MATCH(CONCATENATE("*",A9,"*"),D3:D21,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