Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Typing in multiple row in a single cell
Is there a way to divide a cell in multiple rows? I am not talking about the insert the Text Box or table. The cell it self should be able to take text in multiple rows. for example to type "My address My Street My City" Three rows in one cell Khusro |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Typing in multiple row in a single cell
Hi
FormatCellsAlignmentWrap text Then press Alt+Enter at each point you want to create a new row. As an aside, entering data in this format is not the most useful way to store data. Very often, you want to pull out the City separate form other things, for example. It would be better to store your data in separate cells, but if you want it displayed in a single cell then use =A1&Char(10)&B1&Char(10)&C1 -- Regards Roger Govier "Khusro" wrote in message ... Is there a way to divide a cell in multiple rows? I am not talking about the insert the Text Box or table. The cell it self should be able to take text in multiple rows. for example to type "My address My Street My City" Three rows in one cell Khusro __________ Information from ESET Smart Security, version of virus signature database 4537 (20091023) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4537 (20091023) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple colums into a single cell | Excel Discussion (Misc queries) | |||
Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
can a single cell contain multiple numbers? | Excel Worksheet Functions | |||
Using a single cell in multiple formulas | Excel Worksheet Functions | |||
multiple validation in a single cell | Excel Discussion (Misc queries) |