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
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
That code will remove the LEFT 5 characters, and return the remainder, after changing the case to lower case, except for the first letter
7.1 - 546,017