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?