Function limitation

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

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" <JayL@nospam.com> wrote in message
news:kIWdnaSNXr38FLXfRVn-iQ@comcast.com...
> 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
>
>