Excel Forum
Similar Content
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can ...
How to import Text Files (CSV) into Excel
Tutorial: Text files in CSV format are one of the easiest ways to store and transfer data as it is o...



Excel Magic Trick 309: Partial Text Match: Why 2^15?


See how to check to see if an item in first list is second another list, even if there is text before or after the item. See the LOOKUP, SEARCH and ISNUMBER functions.

Fuzzy Match

Learn about the number 2^15 = 32768. 32768 is one more character than is allowed in a cell. 32767 characters are allowed in a cell. See a great trick with the REPT function to prove that this is TRUE.

Characters in cell limit.





Got a Question? Ask it Here in the Forum.