On Monday 28 August 2006 08:56 pm, Dan Lewis wrote:
> On Monday 28 August 2006 08:08 pm, James Elliott wrote:
> > In a calc cell I can use the function CHAR to convert a number to
> > the corresponding character,
> > eg. =CHAR(65) gives me the letter A
> >
> > What function would I use to get the ASCII value of B?
> >
> > ie, in pseudocode what is the correct syntax for something like
> > this: ASC("B") = 66 ?
> >
> > Many thanks, James
>
> =Char(65) puts A in the cell.
> =Code(A) puts 65 in the cell.
>
> Dan
Slight error here. It should be as two others have already pointed
out:
=Code("A") puts 65 in the cell. (=Code(A) puts #NAME? in the cell.)
However, if Cell A1 has the formula: =Char(65) in it
and Cell B1 has the formula: =Code(A1),
the cell A1 will contain an A and cell B1 will contain a 65.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
