How do I take a string of text and convert it ASCII Values?
Since your text is a fixed width, you could try something like this (I'll
assume 3 characters for this example):
=CODE(MID(A1,1,1))&" "&CODE(MID(A1,2,1))&" "&CODE(MID(A1,3,1))
HTH,
Elkar
"KBos@Minuteman" wrote:
I have a column containing a string of text of a fixed width, and I need to
make another column out that displays the ASCII values. How can I do this?
The Code function only allows me to display the ASCII value of the first
character in the column and I need the whole thing.
|