Enter
prt:001
in the first cell, say A1, then enter
prt:002 in the next cell down.

Select *both* cells,
and click on the fill handle of that 2 cell selection, and simply drag down
to copy as needed.

XL will copy and increment the data *automatically*.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"raulavi" wrote in message
...
excel 2007: have 1 col with many rows, each cell has a prefix prt:000 ,
need
to sequence all row in that col as prt:001,prt:002...and so on... any
ideas
how?

TIA