all chr()

  • Thread starter Thread starter Guest
  • Start date Start date
Alvin said:
Hi!!
Where can i see all chr() codes
I know chr(13) is a new line

Best regards
Alvin
Click to expand...
In Cell A1 of a blank sheet enter =CHAR(ROW(A1)) and fill down.

Alan Beban
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formattig word paragraphs from excel 5
Split data in field on character return 0
SQL VBA Excel 0
Chr$ 3
VB Send Mail using Thunderbird 6
Send Mail using Lotus Notes 1
Hyperlink in Email Body 6
Retrieving Data from SQL Server to Excel 1

Back
Top