Ok come across another little quirk here. Martin, your formula is perfect except I can't get it to ignore blank squares which is an issue, as I can not now SUM a list of them. Is there a way to do this, I basically have a list of people that grows and shrinks so the formula is permenantly there whether the cell is full or blank, I can't find a way for Excel to ignore this.

@ MickG, I can't see in this code where the value comes from, it is no longer asci text value, this makes my code difficult to verify as a newby programmer, could you point out the line that actually gives a number for a letter please.

Kind regards

Rob