Text(Microsoft Excel Functions)
Contents
- 1. TEXTBEFORE function. Obtains a substring up to the specified characters.
- 2. TEXTAFTER Function. Get substrings after a specified character.
- 3. TEXTSPLIT function. Split text into cells by specifying a delimiter.
- 4. CONCAT Function. Concatenate strings.
- 5. CONCATENATE Function. Concatenate strings.
- 6. LEN function. Length of a character string.
- 7. LEFT, MID, and RIGHT functions. Extracts strings by specifying the number of characters.
- 8. FIND Function. Finds the position of a string.
- 9. SUBSTITUTE function. Substitutes the specified text.
- 10. TEXT Function. Obtains text with formatting applied to numbers and dates.