Convert Cell Value to ASCII

[carl]

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.

 

[Ron Rosenfeld]

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]

Check your other post.

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.