ascii conversion
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? |
ascii conversion
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? |
ascii conversion
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? |
ascii conversion
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? |
ascii conversion
=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? |
All times are GMT +1. The time now is 05:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com