Excel text functions help you extract, analyze, and manage text data easily. Functions like LEFT, RIGHT, MID, LEN, and FIND allow you to pull characters from any part of a text string, count characters, and locate specific words or positions.
These functions are especially useful when working with large datasets that contain names, codes, or mixed text values.
LEFT Function in Excel
The LEFT function returns a given text from the left of our text string based on the number of characters specified.
Syntax:
LEFT(text, [num_chars])
Parameters:
- Text: The text we want to extract from.
- Num_chars (Optional): The number of characters we want to extract. Default num_chars is 1, and the number must be a positive number that is greater than zero.
LEFT Function Excel
Here are the steps to use the LEFT function in Excel to extract a specified number of characters from the beginning of a text string.
Step 1: Format our data.
Now if we want to get the first "Geeks" from "Geeksforgeeks" in B2. Let us follow the next step.
Step 2: Enter Formula
We will enter =LEFT(B2,5) in the B3 cell. Here we want Excel to extract the first 5 characters from the left side of our text in B2.
Step 3: This will return "Geeks".
RIGHT Function in Excel
The RIGHT function returns a specified number of characters from the end (right side) of a text string.
Syntax:
RIGHT(text, [num_chars])
Parameters:
- Text: The text we want to extract from.
- Num_chars (Optional): The number of characters we want to extract. Default num_chars is 1 and the number must be a positive number that is greater than zero.
RIGHT Function in Excel
Here are the steps to use the RIGHT function in Excel to extract a specified number of characters from the end of a text string.
Step 1: Format our data.
Now if we want to get the last geeks from "Geeksforgeeks" in B2. Let us follow the next step.
Step 2: Enter Formula
We will enter =RIGHT(B2,5) in the B3 cell. Here we want Excel to extract the last 5 characters from the right side of our text in B2.
Step 3: This will return "geeks".
MID function in Excel
The MID function returns the text from any middle part of our text string based on the starting position and number of characters specified.
Syntax:
MID(text, start_num, num_chars)
Parameters:
- Text: The text we want to extract from.
- start_num: The starting number of the first character from the text we want to extract.
- Num_chars: The number of characters we want to extract.
How to use MID Function in Excel
Here are the steps to use the MID function in Excel to extract a specific number of characters from a text string, starting at any position we choose.
Step 1: Format our data
Now if we want to get the character "for" which is located in the middle of our text "Geeksforgeeks" in B2. Let us follow the next step.
Step 2: Enter Formula
We will enter =MID(B2,5,3) in the B3 cell. Here we want Excel to extract the characters located in the middle of our text in B2.
Step 3: This will return "for"
LEN Function in Excel
The LEN function returns the number of characters in the text strings.
Syntax:
LEN(text)
Parameters:
- Text: The text we want to know the length
How to use LEN Function in Excel
Here are the steps to use the LEN function in Excel to count the number of characters in a text string, including spaces.
Step 1: Format our data.
Now if we want to know how many characters are in the text "Geeksforgeeks". Let us follow the next step.
Step 2: Enter Formula
We will enter =LEN(B2) in the B3 cell. Excel will count how many characters are in the text.
Step 3: This will return 13
FIND Function in Excel
The FIND function returns the position of a given text within a text.
Syntax:
FIND(find_text, within_text, [start_num])
Parameters:
- Find_text: The text we want to find.
- Within_text: The text containing our find_text.
- Start_num (Optional): The starting position of our find_text. Default is 1.
How to use FIND Function in Excel
Here are the steps to use the FIND function in Excel to locate the position of a specific character or substring within a text string.
Step 1: Format our data
Now if we want to find “for” in geeksforgeeks in B2. Let us follow the next step.
Step 2: Enter Formula
We will enter =FIND("for",B2) in B3 cell. Here we want Excel to find “for” in our text in B2.
Step 3: This will return 6 because “for” is located at character number 6 in our text
