Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Text
Clean, split and join text: LEFT, MID, TRIM, TEXTJOIN, TEXTSPLIT, SUBSTITUTE.
50 functions
ARRAYTOTEXTAn array written as textASCFull-width (double-byte) to half-widthBAHTTEXTNumber as Thai text with “baht”CHARCharacter from a code (1–255)CLEANRemoves non-printing charactersCODECode of the first characterCONCATJoins textCONCATENATEJoins textDBCSHalf-width to full-width (double-byte)DETECTLANGUAGETells you which language some text is written in, as a language code (for example "fr").DOLLARNumber as currency textEXACTTRUE if exactly the sameFINDPosition of text (case-sensitive)FINDBPosition of text (bytes)FIXEDNumber as text with fixed decimalsJISHalf-width to full-width (double-byte)LEFTFirst charactersLEFTBFirst characters (bytes)LENNumber of charactersLENBLength in bytesLOWERConverts to lower caseMIDCharacters from the middleMIDBCharacters from the middle (bytes)NUMBERVALUEText to number with any separatorsPHONETICFurigana (phonetic) textPROPERCapitalises Each WordREGEXEXTRACTExtracts text matching a patternREGEXREPLACEReplaces text matching a patternREGEXTESTTRUE if the text matches a patternREPLACEReplaces characters at a positionREPLACEBReplaces characters (bytes)REPTRepeats textRIGHTLast charactersRIGHTBLast characters (bytes)SEARCHPosition of text (any case, wildcards)SEARCHBPosition of text (bytes, any case)SUBSTITUTEReplaces textTThe text, or "" if it isn’t textTEXTFormats a number as textTEXTAFTERText after a delimiterTEXTBEFOREText before a delimiterTEXTJOINJoins text with a separatorTEXTSPLITSplits text into columns and rowsTRANSLATETranslates text between languages using Microsoft’s translation service.TRIMRemoves extra spacesUNICHARCharacter from a Unicode numberUNICODEUnicode number of the first characterUPPERConverts to CAPITALSVALUEConverts text to a numberVALUETOTEXTA value written as text