LEFT

The LEFT formula is used to extract a specified number of characters from the beginning of a cell. To use the LEFT formula, select the cell where you want the result to appear and enter “=LEFT(” followed by the cell you want to extract characters from and the number of characters you want to extract. For example, “=LEFT(A1,3)” would extract the first three characters from cell A1.

Example:

Extract the first three characters from cell A1: =LEFT(A1,3).