In excel, how do you split /expand text , so appear like paragraph
 

Hi there,

Im using MS Excel, and am writing text into a cell. What I want is for all
the text to appear in a bullet point format or in separated lines, for
example:-

There is a dog.
There is no dog.
There are lots of dogs.
There are some dogs.

I want this all in one cell - to appear in this format when you click into a
cell.

Other than wrapping text in a cell - is there another way to do this?

Thanks

Ket

In excel, how do you split /expand text , so appear like paragraph
 

You can use Alt+Enter to force a page break within a cell, but to get more
detailed formatting you should use a word processor.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ket" wrote in message
...
Hi there,

Im using MS Excel, and am writing text into a cell. What I want is for
all
the text to appear in a bullet point format or in separated lines, for
example:-

There is a dog.
There is no dog.
There are lots of dogs.
There are some dogs.

I want this all in one cell - to appear in this format when you click into
a
cell.

Other than wrapping text in a cell - is there another way to do this?

Thanks

Ket

In excel, how do you split /expand text , so appear like paragraph
 

Type Alt-Enter for each line break......if this automatically results in a
Wrap-text formatted cell, just reformat the cell, deleting the wrap-text
checkmark

Alternatively, the cell contents could also be put in a pop-up comment
box.......

hth
Vaya con Dios,
Chuck, CABGx3



"Ket" wrote:

Hi there,

Im using MS Excel, and am writing text into a cell. What I want is for all
the text to appear in a bullet point format or in separated lines, for
example:-

There is a dog.
There is no dog.
There are lots of dogs.
There are some dogs.

I want this all in one cell - to appear in this format when you click into a
cell.

Other than wrapping text in a cell - is there another way to do this?

Thanks

Ket