Extracting character

Extract all but the last 2 characters

By Neale Blackwood

You can do this using two text functions. The following function will work on any length text string. It is extracting the text from cell A1.


The LEFT function extracts a number of characters from the left of a string of characters. Because the number of characters could be variable, we use the LEN function to tell us how many characters in cell A1, and then simply deduct 2 to tell the LEFT function how many characters from the left to extract. The 2 could be replaced by a cell reference to all allow you vary the number of characters to omit.