Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
to add a row
i wanted to auto increment the number for the cells for which i have entered
text already say 1)some text 2) some text 3) ------------- This is possible if i enter in an individual column by dragging it where i can fill the series wheras for the text already exising in the cell and i have to prefix nos can any one tell me whether can i do this? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
to add a row
Offhand, I would say that you should use a text concatenation function for
the text, prefixing "some text" with a number in a cell. E.g. =ROW(B9)&" " &B9 where row(cell) returns the row number and the & concatenates and the " " puts a blank space. Other possibilities other than the row() function, but this should give you a start. "Vijay" wrote: i wanted to auto increment the number for the cells for which i have entered text already say 1)some text 2) some text 3) ------------- This is possible if i enter in an individual column by dragging it where i can fill the series wheras for the text already exising in the cell and i have to prefix nos can any one tell me whether can i do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|