ascii conversion

[jclarke]

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?

 

[Guest]

Could you post an example of what your are doing?

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[jclarke]

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.

 

[Tom Ogilvy]

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