Skip to main content

Custom Functions

FunctionsDescription
XCOMPAREReturns the word difference between two ranges.
XEXTRACTAFTERReturns the part of a selected range after a specified word.
XEXTRACTBEFOREReturns the part of a selected range before a specified word.
XFINDReturns the word search results on a selected range based on a specified word list.
XHASNUMBERReturns True if there is a number in the selected range.
XLOOKUPReturns the matched lookup value from a search list.
XREPLACEWORDSReplaces words in a selected range based on specified replacement word list.
XSPELLNUMBERSpells monetary values in dollar and cents.
XSUBSTITUTEPREFIXReplaces the prefix of a selected range based on a specified replacement.
XSUBSTITUTESUFFIXReplaces the suffix of a selected range based on a specified replacement.
XTRANSLATEReturns the Google Translation result on a selected range.
XCELLFORMULAReturns formula of the selected cell.
XCLEANTEXTRemoves excess non-alphanumeric characters
XGETPAGENUMBERReturns page number.
XIFDATEReturns True if it is date format.
XREMOVEBETWEENRemoves text between two specified delimiters.
XREMOVESYMBOLSRemoves leading and trailing symbols from text.
XSHEETNAMEReturns worksheet name.
XSUBSTITUTEMULTIPLESubstitutes multiple words.