Typing in multiple row in a single cell

  • Thread starter Thread starter Khusro
  • Start date Start date
K

Khusro

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
 
Hi

Format>Cells>Alignment>Wrap 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 said:
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
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4537 (20091023) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top