numbering items in a cell
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
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" 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!
.
|