sample code for ms excel for text to numeric character

=CONCATENATE(CODE(A36),CODE(B36),CODE(C36),LEN(A36),LEN(B36),LEN(C36))

http://desertionbliss.blogspot.com. Powered by Blogger.