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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]