View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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.