amazing...thanks to all. it works. I was breaking my hand trying ,left arrow
then number....amazed me that a mouse combination can do so much when working
on excel lol.


"raulavi" wrote:

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