Prev: How do I stop the Commands from disappearing from Quick Access too
Next: CONCATENATE error?
From: Gord Dibben on 27 Mar 2010 11:01
Cannot be done.

Excel knows nothing about bulleted lists.

You will have to enter the "4." manually after Alt + Enter on 3. Saiju


Gord Dibben MS Excel MVP

On Fri, 26 Mar 2010 21:30:01 -0700, Maanu <Maanu(a)discussions.microsoft.com>
wrote:

>An example is given below. All the items given below is in the same cell
>
>1. Manu
>2. Mini
>3. Saiju
>
>if I press alt+enter the next item should start with 4.
>
>"T. Valko" wrote:
>
>> >Is it possible to number items in a cell?
>>
>> If there's some kind of unique delimiter that separates the items then you
>> can count the delimiters and add 1. For example:
>>
>> 1,2,3
>>
>> You'd count the number of commas and add 1. So, that cells contains 3 items
>>
>> red yes no blue
>>
>> You'd count the number of space characters and add 1. So, that cell contains
>> 4 items.
>>
>> You should post some examples.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Maanu" <Maanu(a)discussions.microsoft.com> wrote in message
>> news:19D173A6-3C20-463F-BC26-9DAB17AD22D8(a)microsoft.com...
>> > Hi,
>> >
>> > Is it possible to number items in a cell?
>> >
>> > This number should automatically increment when I enter a new item at the
>> > end of the cell as in microsoft word.
>> >
>> > Thanks!
>>
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: How do I stop the Commands from disappearing from Quick Access too
Next: CONCATENATE error?