Main Profile

At A Glance

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.
Length: 06:10

Contact

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

Want more info about Excel Magic Trick 309: Partial Text Match: Why 2^15?? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question