Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I enter carriage returns into text within a cell in excel
I am trying to use excel to create a table full of text. I would like to be
able to format the text within the cell (e.g. entering carriage returns to put some text on a separate line). I can't seem to make this work. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I enter carriage returns into text within a cell in excel
You need to use Alt-Enter to add line breaks within a cell.
Lizzy wrote: I am trying to use excel to create a table full of text. I would like to be able to format the text within the cell (e.g. entering carriage returns to put some text on a separate line). I can't seem to make this work. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I enter carriage returns into text within a cell in excel
Press Alt+Enter within a cell to enter carriage return
"Lizzy" wrote: I am trying to use excel to create a table full of text. I would like to be able to format the text within the cell (e.g. entering carriage returns to put some text on a separate line). I can't seem to make this work. Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I enter carriage returns into text within a cell in excel
Hi Lizzy,
Adding to Andrew's reply. Use Alt+Enter which inserts a CHAR(10) for a new line, and turns on cell wrap in format,cells,alignment within a concatenation =A1 & CHAR(10) & B1 and you must turn on cell wrap yourself in Format, cells, alignment within a concatenation in VBA newstring = Oldstring & CHR(10) & Morestring Failure to turn cell wrap will result in viewing a square printer's bullet, which is an indication of a character not in the character set you are using.. -- --- 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 "Lizzy" wrote in message ... I am trying to use excel to create a table full of text. I would like to be able to format the text within the cell (e.g. entering carriage returns to put some text on a separate line). I can't seem to make this work. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display a cell range in a text box in excel? | Excel Discussion (Misc queries) | |||
How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |