use code() function in the worksheet or use the following function to get the ascii value of each character seperated by a space
Public Function GetAscii(Var) Dim Cd As String For x = 1 To Len(Var) Cd = Cd & IIf(Cd = "", Trim(Str(Asc(Mid(Var, x, 1)))), " " & Trim(Str(Asc(Mid(Var, x, 1))))) Next x GetAscii = Cd End Function On 7/28/10, galsaba <gals...@aol.com> wrote: > Is there a way to see what the ascii code is for each character in a > chosen field? > The reason is, I got a file from China that contain some characters > that on xls they look as "space", but when I do "replace space by > nothing" this "space" is still there. so I assume it is not really a > space character, but a character that I cannot see. > > Thanks > > galsaba > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Regards Vasant -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
