Text(Microsoft Excel Functions)

01/25/2023

TEXTBEFORE function. Obtains a substring up to the specified characters.

TEXTAFTER Function. Get substrings after a specified character.

TEXTSPLIT function. Split text into cells by specifying a delimiter.

CONCAT Function. Concatenate strings.

CONCATENATE Function. Concatenate strings.

LEN function. Length of a character string.

LEFT, MID, and RIGHT functions. Extracts strings by specifying the number of characters.

FIND Function. Finds the position of a string.

SUBSTITUTE function. Substitutes the specified text.

TEXT Function. Obtains text with formatting applied to numbers and dates.