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.

Sure, I can help you with that! Here's how you can convert a string of text to ASCII values in Microsoft Excel:

1. First, create a new column next to the column containing the string of text that you want to convert.
2. In the first cell of the new column, enter the following formula:
   Code:

   =CODE(A1)

3. Replace "A1" with the cell reference of the first cell in the column containing the string of text.
4. Press Enter to apply the formula to the first cell.
5. Now, click on the cell with the formula and drag the fill handle (the small square in the bottom right corner of the cell) down to apply the formula to the rest of the cells in the column.
6. This will convert each character in the string of text to its corresponding ASCII value.
7. If you want to display the ASCII values as text instead of numbers, you can use the CHAR function. For example, if the ASCII value is in cell B1, you can use the formula
   Code:

   =CHAR(B1)

   to display the corresponding character.

That's it! You should now have a column displaying the ASCII values of the string of text. Let me know if you have any questions or if there's anything else I can help you with.

Hi there! I can definitely help you with that. Here's a step-by-step guide on how to convert a string of text to ASCII values in Excel:

1. First, create a new column next to the column containing the string of text that you want to convert to ASCII values.
2. In the first cell of the new column, enter the following formula:
   Code:

   =CODE(A1)

3. Replace "A1" with the cell reference of the first cell in the column containing the string of text.
4. Press Enter to apply the formula to the first cell.
5. Now, click on the cell with the formula and drag the fill handle down to apply the formula to the rest of the cells in the column.
6. This will convert each character in the string of text to its corresponding ASCII value.
7. If you want to display the ASCII values as characters instead of numbers, you can use the CHAR function. Simply replace "CODE" with "CHAR" in the formula.

That's it! You should now have a new column displaying the ASCII values of the string of text. Let me know if you have any questions or if there's anything else I can help you with.

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.

On Mon, 11 Dec 2006 10:52:02 -0800, 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.

You don't describe exactly how you want the result displayed.

Here's one way that displays the ASCII values of the string with each value
separated by a <space.

Download and install Longre's free morefunc.xll addin from
http://xcell05.free.fr


Then use this formula, with your string in A1:

=REGEX.SUBSTITUTE(A1,"(.)","=CODE(""[1]"")&"" """)

As written, the formula will leave a trailing <space. If that is not OK, then
you could TRIM. If you want another separator, you'll need to eliminate the
separator(s) following the final character.


--ron