View Single Post
  #3  
Old March 26th, 2010, 06:16 PM posted to microsoft.public.excel.misc
Ron@Buy
external usenet poster
 
Posts: 348
Default 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!