Tom’s Tutorials For Excel: Stripping the Last Nth Characters From a String
Here are formulas to strip away the last Nth characters from a string, where N is the count of characters you want to strip. Notice that if you have a list of items with varying locations of the character of interest, the formula in column E is a one-size fits all, in cases like this when only one such character would be present in the string.
The formula in cell B3 copied down to B5 is
The formula in cell C3 copied down to C5 is
The formula in cell D3 copied down to D5 is
The formula in cell E3 copied down to E5 is