Re: amending an EXCEL worksheet

Giganews Newsgroups
Subject: Re: amending an EXCEL worksheet
Posted by:  Joerg (…@email.address)
Date: Thu, 11 Jan 2007

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

Cheers,
Joerg

"Bodster" <bodst…@ntlworld.com> wrote in message
news:cXkph.80456$493.112…@newsfe4-gui.ntli.net...
> 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.

Replies

In response to

amending an EXCEL worksheet posted by Bodster on Thu, 11 Jan 2007