But you don't need code Sheelo

Alt + 0149 textAlt +Enter
Alt + 0149 textAlt +Enter
etc.


Gord Dibben MS Excel MVP

On Sat, 1 Nov 2008 16:49:01 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:

:-)

Through code you can do almost anything..

"Wayne" wrote:

ok cracked it thanks

wrote a separate macro for inserting 1-5 bullet points in a cell
used insert symbol and a couple of spaces
used alt enter for the line break required

it can be done in Excel.........



"Wayne" wrote:

Yeah thanks

I have a very large workbook containing mixed text and data and need Excel
capability for sorting. In some text cells I need to provide a line
separated list of outcomes

"Sheeloo" wrote:

You can not. Excel is not meant for word processing.

"Wayne" wrote:

How do I format an Excel cell similar to an MS Word Table cell with bullets
or numbers on discrete lines within the cell ?
• Jgjgkj
• Kjhkh
• Kjhkh
• kjlkhlk
1. kjhkhlkhjl
2. lklkjhlkjh
3. lkjhlkjh
4. lkjhlkjh