Hi Alvin,
Actually Chr(13) is a CR (Carriage Return),
Chr(10) is a LF (Line Feed), and
Chr(9) is TAB
CRLF is how you went to the beginning of a line and then started
a new line on a teletype.
Excel uses Chr(10) and ignores Chr(13) as far as doing
anything.
For more information on symbols, and ASCII (and EBCDIC) codes see
Symbols for HTML and Excel use
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
For a the characters you get in with Arial, wingdings, and webdings, see
Font Tables as Rendered by your browser
http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm
as rendered by your browser, hopefully that will be the same as
in your Excel. You will have to use Internet Explorer for this as
Firefox, Mozilla, Netscape, and Opera do not recognize wingdings
and webdings (unless you modify them to recognize these fonts).
If you are having trouble with CHR(13) codes in your Excel data and
want to remove along with leading and trailing spaces see
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Note there is a difference between the TRIM Worksheet Function
and the VBA with regard to consecutive internal spaces.
Excel will reduce internal spaces, VBA will not.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Alvin Hansen" wrote in message ...
Hi!!
Where can i see all chr() codes
I know chr(13) is a new line
Best regards
Alvin