Thread: all chr()
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
 
Posts: 691
Default all chr()

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