Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |