Text Functions in Excel
Text functions play a key role in managing text strings within Excel. This chapter will teach you several helpful Excel text functions.
Join Strings
To join strings, use the & operator.
Note: Between the CONCATENATE function and the ‘&’ operator, prefer the CONCATENATE function to join strings.
Excel LEFT function
The LEFT function helps you pick the leftmost characters of a string.
RIGHT
Use the RIGHT function when you want to pull characters from the right side of a text.
Excel MID function
This feature helps you select a specific part of a text string by defining where to start and how many characters to take.
Note: From position 5 (p), 3 characters extracted.
LEN Excel function
It helps you to find the number of characters in a text string, including spaces and punctuation.
Note: space (position 8) included!
FIND
Locating a part of a text (substring) within a bigger text (string) means finding where that smaller portion appears in the larger text. It returns the position number where the substring starts.
Note: The word “am” appears at position 3. For more examples, please visit our FIND function page.
SUBSTITUTE
The SUBSTITUTE function finds a part of the text you choose and replaces it with new text.
1/13 Completed! Understand text functions in details➝
Next Chapter: Lookup & Reference Functions
Leave a Reply