Excel has a number of text functions that can help you to extract a word or a text from another text string. Which function, or combination of functions, to use depends on your situation.
Suppose that cell A1 has the text string:
“Creativity requires the courage to let go of certainties”
1. To get the first 5 characters of the string, we use the LEFT function:
The result is “Creat”
2. To get the last 11 characters of the string, we use the RIGHT function:
The result is “certainties”
3. To get 7 characters from the string starting with position 10, we use the MID function:
The result is “y requi”.
4.To get the first word of the string, we use the LEFT and FIND functions:
The result is “Creativity”.
The FIND function here will give us the position of the first SPACE. We subtract 1 to get the length of the first word. That length is used as a parameter for the LEFT function.