Hi,
I have a number of cells which contain information such as 'H8', 'S4' and 'T6', etc, etc.
What I want is a formula which sums just the numerical part of these cells, so would add up the 8 plus 6 plus 4.
I have hundereds of these cells filled out like this. The first character in the cell is always a letter and then the number will either be a singe number (e.g. H8) or decimal (e.g. H7.5).
Thanks,
Mike