Excel LEFT Function can extract a specified characters from a cell starting from the first (left) character. You just have to specify the numbers of characters which you want to extract from the text string.
- text A text or number from which you want to extract some characters.
- num_char Number of characters you want to extract.
More Information on Excel LEFT Function
- num_char can be zero or greater than zero.
- If you skip specifying num_char, it will assume 1 as default.
- You can’t refer to more than one cell. If you do that it will return the characters from the top right cell of the selected range.
- It can work with numbers also in the same manner.
- It can also work as an array formula.
- With negative num_char, it will return an error.
- You can also enter a text string directly into the formula.
In the below example, I have extracted the first five digits from the text string using Left Formula. I have just specified the number of characters to extract from the string.
It will first count total length of the text string and then find the position of space between first and last name & in the end left function extracted the first name from the test string.
To learn more about Excel LEFT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.