main excel

example-1) Suppose we want to extract the first three letters of each string of the above Column-A, and suppose we want to start the extraction from the left, we use the LEFT Excel function:

formula: =LEFT(A2,3) means: get the first 3 characters starting from the LEFT of cell A2.

Note the formula in use (IN RED) below. Thus we are able to extract the first 3-characters from each cell in Column-A


The above example also applies to get a number of characters from the right, using the RIGHT function, for example: =RIGHT(A2,3)

Add comment

Security code