Trimming values in Excel is the method of eradicating additional areas from the start or finish of a cell’s contents. The LEN operate in Excel can be utilized to find out the size of a string, and this data can be utilized to trim additional areas utilizing the LEFT, RIGHT, and MID features.
To trim additional areas from the start of a cell’s contents, you should utilize the LEFT operate to extract a specified variety of characters from the left facet of the cell. For instance, the system `=LEFT(A1, LEN(A1) – 2)` would take away the final two characters from the cell A1.
