all chr()
 

Hi!!
Where can i see all chr() codes
I know chr(13) is a new line

Best regards
Alvin

all chr()
 

Alvin Hansen wrote:

Hi!!
Where can i see all chr() codes
I know chr(13) is a new line

Best regards
Alvin

In Cell A1 of a blank sheet enter =CHAR(ROW(A1)) and fill down.

Alan Beban

all chr()
 

Hi Alvin

Use Google to search for
ASCII table

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Alvin Hansen" skrev i en meddelelse
...
Hi!!
Where can i see all chr() codes
I know chr(13) is a new line

Best regards
Alvin

all chr()
 

Tanks
Regrads
alvin


"Leo Heuser" skrev:

Hi Alvin

Use Google to search for
ASCII table

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Alvin Hansen" skrev i en meddelelse
...
Hi!!
Where can i see all chr() codes
I know chr(13) is a new line

Best regards
Alvin

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

all chr()
 

"Alvin Hansen" skrev i en meddelelse
...
Tanks
Regrads
alvin

You're welcome :-)

LeoH