ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Use of ANSI codes in Excel Cell (https://www.excelbanter.com/excel-programming/279274-use-ansi-codes-excel-cell.html)

David

Use of ANSI codes in Excel Cell
 
I know how to insert a "bullet point" in a cell, ALT
0149, the ANSI code places a bullet into the cell, and
you can follow with text.

Is there anyway to insert a "CR/LF" into a Cell? The ansi
code 0895 doesn't seem to give me a return. I'm trying to
format text in the cell, and it would make it so much
easier?

Bernie Deitrick[_2_]

Use of ANSI codes in Excel Cell
 
David,

Simply hold down the Alt key and use the numeric keypad to enter 0149.

To put in line breaks, use Alt-Enter.

HTH,
Bernie


"David" wrote in message
...
I know how to insert a "bullet point" in a cell, ALT
0149, the ANSI code places a bullet into the cell, and
you can follow with text.

Is there anyway to insert a "CR/LF" into a Cell? The ansi
code 0895 doesn't seem to give me a return. I'm trying to
format text in the cell, and it would make it so much
easier?





All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com