Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Wildcard MATCH() breaks on long (?) strings
All -
I was doing wildcard matches [MATCH("*"&ref&"*",range,0)]and happened to notice that it skipped an obvious correct match. After attacking that for too long a time, I found that MATCH() won't handle strings longer than 255 characters. The skipped cell satisfied ISTEXT(), FIND(), SEARCH() and menu find efforts. The problem was that the skipped string was 283 characters long, even though the query string started at 81. 1. Is this documented somewhere? It's not in my Excel function book, and Google groups didn't readily reveal it. 2. What's the best workaround? Is there a UDF someone can point me to? Right now I have over a thousand MATCHes to re-evalutate that might have skipped some cases because the string length was too long. Right now I plan to match on truncated strings in a helper column. Less than perfect to say the least. Thanks for any help. ....best, Hash |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Please how do do this in vba | Excel Worksheet Functions | |||
Find nth instance of a character in a string | Excel Discussion (Misc queries) | |||
Filter long Text strings | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |