amending an EXCEL worksheet

[Bodster]

Firstly I have a worksheet with an array of single letters in each cell
(they are grades for subjects in a school). I need to create a parallel
worksheet where the letters are one grade higher than those in the original
worksheet, i.e. if in cell A1 of the original worksheet there is the letter
C I need the the new worksheet to ahve in cell A1 the letter B. Any ideas?

Secondly I have another worksheet where the entries are numbers and letters
i.e. 6b. I need to create a parallel worksheet where all the entries have
moved up one level so 6b would go to 7b etc... The only letters in use are
a, b or c

Lastly I have a worksheet again where the entries are letters and numbers
i.e. 6b. I need to create a parallel worksheet where all the entries move up
one letter so 6b would go 6a etc... The major complication that the original
entry might be contain the letter "a" and this would need to change to the
letter "c" one level up. e.g. 6a would have to change to 7c.

Cheers.

Bodster.

 

[Joerg]

Firstly: In your new worksheet you could use something like
=CHAR(CODE(Sheet1!A1)-1)

Cheers,
Joerg

 

[Joerg]

Secondly: =LEFT(Sheet1!A1,1)+1&RIGHT(Sheet1!A1,1)
This assumes that your numbers in 6a, 7c etc. are always single digit.

 

[Joerg]

Lastly:
=IF(RIGHT(Sheet1!A1,1)="a",LEFT(Sheet1!A1,1)+1&"c",LEFT(Sheet1!A1,1)&CHAR(CO
DE(RIGHT(Sheet1!A1,1))-1))

Cheers,
Joerg