Excel Forum

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.