I have a column where the cells contain V11, C139, D27 etc. I need to strip the letters out so that I can apply the MAX formula to the entire column. The entries are also entered as text so I will need to remove the apostrophe. I have only just discovered the text/value toggle so, unwittingly, I have been entering text instead of "value" (number). I have formatted the column as "number" and have tried highlighting the cells and toggling to "AUTO" but the damned apostrophe remains.
Anyone out there who can help?