Prev: How do I stop the Commands from disappearing from Quick Access too
Next: CONCATENATE error?
From: Maanu on 26 Mar 2010 13:46
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!
From: T. Valko on 26 Mar 2010 13:59
>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!


From: Ron on 26 Mar 2010 14:16
One method:
In A1 enter a 1
In A2 enter: =IF(OR(B2>0,B2>""),A1+1,"") and copy down (you could then hide
column A)
In C2 enter: =A2&" "&B2 and copy down
Now in column B (starting in B2) enter your data.
Column C should give you the desired result


"Maanu" wrote:

> 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!
From: Maanu on 27 Mar 2010 00:30
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!
>
>
> .
>
From: T. Valko on 27 Mar 2010 01:34
>All the items given below is in the same cell
>if I press alt+enter the next item should start with 4.

Yikes!

I don't know how you'd do that all in the same cell. In fact, I'd love to
see someones solution. I don't think it can be done. While you're typing
data into a cell Excel is in Edit mode. Nothing can happen in Excel while
you're in Edit mode until you actually enter the data in the cell by either
hitting the Enter key, the tab key, one of the directional arrow keys or
clicking the "enter" icon.

--
Biff
Microsoft Excel MVP


"Maanu" <Maanu(a)discussions.microsoft.com> wrote in message
news:1FBFE188-4E97-4386-92CE-6E79EDA34A97(a)microsoft.com...
> 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!
>>
>>
>> .
>>


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