LEFT Function in Excel
Table of Content:
LEFT Function in Excel
The LEFT function in Excel is a text function that allows you to extract a specific number of characters from the beginning (left-hand side) of a string.
The syntax of the LEFT function is as follows:
LEFT(text, num_chars)
where:
- "text" is the text string from which you want to extract the characters.
- "num_chars" is the number of characters you want to extract from the left of the string.
For example, if you have a text string "Hello, world!", and you want to extract the first 5 characters (i.e., "Hello"), you can use the following formula:
=LEFT("Hello, world!", 5)
The result will be "Hello".
The LEFT function can be very useful when you need to extract a specific part of a text string, such as the first name from a full name or the first few digits of a phone number.