how to trim last 4 characters in excel


how to trim last 4 characters in excel


And you can specify the number of characters you want to remove from the left string by changing the Number 4 in the formula =LEFT(A1, LEN(A1)-4). Step 2. Then press Enter key, and select the cell B1, then drag the fill handle over the cells that you want to contain this formula.


how to trim last 4 characters in excel

Leave a Reply