Text(Microsoft Excel Functions)

01/07/202301/25/2023

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

TEXTBEFORE function. Obtains a substring up to the specified characters.(Microsoft Excel)

TEXTAFTER Function. Get substrings after a specified character.

TEXTAFTER Function. Get substrings after a specified character (Microsoft Excel)

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

TEXTSPLIT function. Split text into cells by specifying a delimiter.(Microsoft Excel)

CONCAT Function. Concatenate strings.

CONCAT Function. Concatenate strings.(Microsoft Excel)

CONCATENATE Function. Concatenate strings.

CONCATENATE Function. Concatenate strings.(Microsoft Excel)

LEN function. Length of a character string.

LEN function. Length of a character string.(Microsoft Excel)

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

LEFT, MID, and RIGHT functions. Extracts strings by specifying the number of characters.(Microsoft Excel)

FIND Function. Finds the position of a string.

FIND Function. Finds the position of a string.(Microsoft Excel)

SUBSTITUTE function. Substitutes the specified text.

SUBSTITUTE function. Substitutes the specified text.(Microsoft Excel)

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

TEXT Function. Obtains text with formatting applied to numbers and dates.(Microsoft Excel)