XCOMPARE | Returns the word difference between two ranges. |
XEXTRACTAFTER | Returns the part of a selected range after a specified word. |
XEXTRACTBEFORE | Returns the part of a selected range before a specified word. |
XFIND | Returns the word search results on a selected range based on a specified word list. |
XHASNUMBER | Returns True if there is a number in the selected range. |
XLOOKUP | Returns the matched lookup value from a search list. |
XREPLACEWORDS | Replaces words in a selected range based on specified replacement word list. |
XSPELLNUMBER | Spells monetary values in dollar and cents. |
XSUBSTITUTEPREFIX | Replaces the prefix of a selected range based on a specified replacement. |
XSUBSTITUTESUFFIX | Replaces the suffix of a selected range based on a specified replacement. |
XTRANSLATE | Returns the Google Translation result on a selected range. |
XCELLFORMULA | Returns formula of the selected cell. |
XCLEANTEXT | Removes excess non-alphanumeric characters |
XGETPAGENUMBER | Returns page number. |
XIFDATE | Returns True if it is date format. |
XREMOVEBETWEEN | Removes text between two specified delimiters. |
XREMOVESYMBOLS | Removes leading and trailing symbols from text. |
XSHEETNAME | Returns worksheet name. |
XSUBSTITUTEMULTIPLE | Substitutes multiple words. |