Is there an excel function and/or marco that can convert a cell value
into it's ASCII equivalent ?

I have data like this needs to be conversted to its unique ASCII
codes:

HO
Ho
hO
ho

Thank you in advance.

Check your other post.

On 09/08/2010 13:40, Ron Rosenfeld wrote:
> On Wed, 8 Sep 2010 11:21:56 -0700 (PDT), carl<(E-Mail Removed)>
> wrote:
>
>> Is there an excel function and/or marco that can convert a cell value
>> into it's ASCII equivalent ?
>>
>> I have data like this needs to be conversted to its unique ASCII
>> codes:
>>
>> HO
>> Ho
>> hO
>> ho
>>
>> Thank you in advance.
>
> If all of the data is two characters, then
>
> 1st char: =code(a1)
> 2nd char: =code(right(a1,1))
>
> If you need something more general, that will deal with longer data,
> then try:
>
> A1: your data
> B1: =IF(LEN($A1)<COLUMNS($A:A),"",CODE(MID($A1,COLUMNS($A:A),1)))
> and fill right as far as might be required.

--
Dave Peterson