\SUBSTITUTE.ALL Leave a Comment / Text / PJ Replace nested SUBSTITUTE functions with one function. \SUBSTITUTE.ALL Read More »
\HAS.TAG Leave a Comment / Text / PJ Check if cell has given tag. Great for formula-based conditional formatting. \HAS.TAG Read More »
\TAG Leave a Comment / Text / PJ Add an invisible, zero-width, transferrable tag to a text value. \TAG Read More »
\NGRAMS.DISTANCE Leave a Comment / Text / PJ Fast edit distance function for text comparison \NGRAMS.DISTANCE Read More »
\LEVENSHTEIN Leave a Comment / Text / PJ First efficient Excel formula implementation of the Levenshtein distance function for measuring text similarity \LEVENSHTEIN Read More »
\STRIPACCENTS Leave a Comment / Text / PJ The most complete accent-stripping function for Excel \STRIPACCENTS Read More »