The LEFT function in Excel is a text function that allows you to extract a specified number of characters from the left side of a text string. It can be used to manipulate text data in various ways, such as splitting names or addresses into separate fields or extracting specific parts of a text string.
Syntax
=LEFT(text, [num_chars])
Arguments
text – text string from which you want to extract characters
num_chars – the number of characters you want to extract