numbering items in a cell
One method:
In A1 enter a 1
In A2 enter: =IF(OR(B20,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!
|