I am trying to do an ASCII conversion of a string of 11 numeric
characters into 22 numeric characters. When I use the conversion in
Excel, it only converts the 1st character in the string. Is there a
way to have it convert all 11 characters into one string of 22
characters?

Could you post an example of what your are doing?

" wrote:

I am trying to do an ASCII conversion of a string of 11 numeric
characters into 22 numeric characters. When I use the conversion in
Excel, it only converts the 1st character in the string. Is there a
way to have it convert all 11 characters into one string of 22
characters?

Would a UDF function do?

If so try:

Public Function StringIt(Number) As String
Dim Temp As String
Dim x As Integer
Application.Volatile

For x = 1 To Len(Number)
Temp = Temp & Asc(Mid(Number, x, 1))
Next x

StringIt = Temp
End Function

With you original string in A1 enter:

=StringIt(A1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
oups.com...
I am trying to do an ASCII conversion of a string of 11 numeric
characters into 22 numeric characters. When I use the conversion in
Excel, it only converts the 1st character in the string. Is there a
way to have it convert all 11 characters into one string of 22
characters?

I have a someone sending me information with account numbers in it (a
simple example: 143). What I need to do is convert that to ASCII.
When I use the Excel conversion, it only converts the first number. I
need it to convert all 3 and display them in a continuous string, in
this case being 495251. Right now, Excel is only displaying 49,
representing only the first character of the account number.

JLGWhiz wrote:
Could you post an example of what your are doing?

" wrote:

I am trying to do an ASCII conversion of a string of 11 numeric
characters into 22 numeric characters. When I use the conversion in
Excel, it only converts the 1st character in the string. Is there a
way to have it convert all 11 characters into one string of 22
characters?

=CODE(MID(A1,1,1))&CODE(MID(A1,2,1))&CODE(MID(A1,3 ,1))

--
Regards,
Tom Ogilvy




wrote in message
oups.com...
I have a someone sending me information with account numbers in it (a
simple example: 143). What I need to do is convert that to ASCII.
When I use the Excel conversion, it only converts the first number. I
need it to convert all 3 and display them in a continuous string, in
this case being 495251. Right now, Excel is only displaying 49,
representing only the first character of the account number.

JLGWhiz wrote:
Could you post an example of what your are doing?

" wrote:

I am trying to do an ASCII conversion of a string of 11 numeric
characters into 22 numeric characters. When I use the conversion in
Excel, it only converts the 1st character in the string. Is there a
way to have it convert all 11 characters into one string of 22
characters?