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