How do I create a bulleted list text format inside cell?
 

I am collecting data and want to format the text inside the "notes" (my
title) cell so that it can be more easily read. I would like to make a
bulleted list. There are several cells that need this formatting. Is this
possible?

There is no help for this. You have to do it manually.

--
Regards,
Tom Ogilvy

"DEH" wrote in message
...
I am collecting data and want to format the text inside the "notes" (my
title) cell so that it can be more easily read. I would like to make a
bulleted list. There are several cells that need this formatting. Is this
possible?

Thank you for the help. Is there a way to atleast list the items line by line
in the same cell...That is, "press return" without leaving the cell?

"DEH" wrote:

I am collecting data and want to format the text inside the "notes" (my
title) cell so that it can be more easily read. I would like to make a
bulleted list. There are several cells that need this formatting. Is this
possible?

Use alt-enter to force a new line within the cell.

As a formula:

=a1&char(10)&"hi there"&char(10)&b1

You may have to turn on wrap text (if you see square boxes where those
alt-enters are).
format|cells|alignment tab

DEH wrote:

Thank you for the help. Is there a way to atleast list the items line by line
in the same cell...That is, "press return" without leaving the cell?

"DEH" wrote:

I am collecting data and want to format the text inside the "notes" (my
title) cell so that it can be more easily read. I would like to make a
bulleted list. There are several cells that need this formatting. Is this
possible?

--

Dave Peterson

In a cell hit ALT + 0149(from NumPad)

Type some text then hit ALT + ENTER.

Hit ALT + 0149 then type some more text.

The ALT + ENTER will give a carriage return.

The ALT + 0149 will give a Bullet.


Gord Dibben Excel MVP

On Sun, 30 Jan 2005 12:47:01 -0800, DEH wrote:

Thank you for the help. Is there a way to atleast list the items line by line
in the same cell...That is, "press return" without leaving the cell?

"DEH" wrote:

I am collecting data and want to format the text inside the "notes" (my
title) cell so that it can be more easily read. I would like to make a
bulleted list. There are several cells that need this formatting. Is this
possible?

Thank you...big help!
Sincerely,
Debbie Hope

"Dave Peterson" wrote:

Use alt-enter to force a new line within the cell.

As a formula:

=a1&char(10)&"hi there"&char(10)&b1

You may have to turn on wrap text (if you see square boxes where those
alt-enters are).
format|cells|alignment tab

DEH wrote:

Thank you for the help. Is there a way to atleast list the items line by line
in the same cell...That is, "press return" without leaving the cell?

"DEH" wrote:

I am collecting data and want to format the text inside the "notes" (my
title) cell so that it can be more easily read. I would like to make a
bulleted list. There are several cells that need this formatting. Is this
possible?

--

Dave Peterson