Convert Cell Value to ASCII

C

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.
 
R

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top