LEFT Function can extract specified character(s) from a cell/string starting from the first (left) character.
You just have to specify the numbers of characters which you want to extract from the text string.
In the below example, we have extracted the first four characters from the cell where we have “Jack Brown”.
In the below example, we have extracted the first five digits from the text string using LEFT by specifying the number of characters to extract.
In the below example, we have used LEN and FIND along with the LEFT to create a formula which extracts the name from the cell.
It first counts total length of the text string and then finds the position of space between first and last name. And in the end, it extracts the first name from the test string.