How to Remove the LAST x characters from a cell..
Using the LEFT function we can tell Excel to take the value of one cell, remove a certain number of Characters from the Left, and return the balance
eg: =LEFT(A1,LEN(A1)-5)
That code will remove the LEFT 5 characters, and return the remainder.
Another variation that I have found useful, when a Cell is full of Capital letters, is to combine the above function with the PROPER function, and change the case in the answer.
How to Remove last 5 characters from a cell, and return the answer in Proper case
eg: =PROPER(LEFT(A1,LEN(A1)-5))
That code will remove the LEFT 5 characters, and return the remainder, after changing the case to lower case, except for the first letter
48.1 - 873,670
↓ Scroll down for Comments ↓