LEFT Function: In the last post we talked about the “ISBLANK” function. Now let’s explore the LEFT function in Excel. Please share it with others to show your support.
In the above example we had taken some famous names:
Virat Kohli and PM Modi
From the above we want only name “VIRAT” using left function and “PM” from the second one.
What is LEFT Function in Excel?
The LEFT
function in Excel is used to extract a specified number of characters from the start of a text string. It is particularly useful for parsing data and extracting relevant information from cells.
Syntax
LEFT(text, [num_chars])
text
: The original text string from which characters will be extracted.num_chars
: Optional. It specifies the number of characters to extract from the left of the text. If omitted, it extracts one character.
Example
Suppose cell A1 contains the text “Excel Functions”. To extract the first 5 characters from this text, the formula would be:
=LEFT(A1, 5)
This would return “Excel”. If the num_chars
parameter is omitted, it defaults to 1, so =LEFT(A1)
would return “E”.
The LEFT
function is a valuable tool for manipulating text data in Excel, allowing users to efficiently extract specific portions of text for analysis or presentation.
Practice Now
When it comes to practicing the LEFT function, it’s essential to understand its utility and application, especially for those who are familiar with using it in Excel. The LEFT function allows you to extract a specified number of characters from the beginning (leftmost side) of a text string. By replicating the same example and guiding you to start with the equal sign and type the LEFT function, you can gain hands-on experience and understand its functionality with practical ease. This practical approach can be immensely beneficial in comprehending how this function operates within the context of different scenarios and datasets.
Join EduTaxTuber Network for the Latest News and updates on Income Tax, GST, Company Law, Stock Market and other related subjects.
Disclaimer: The views expressed are solely those of the author and Edutaxtuber. The content in this piece is solely intended for informational purposes and for personal, non-commercial use. It should not be considered as professional advice or an endorsement by any organization. The author, the organization, and its affiliates disclaim any liability for any loss or harm resulting from the information in this article, as well as for any decisions made based on it.