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" wrote in message
...
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!


.