do you already have prt:001 , prt:002 ,prt:003 and you just need to
order them? If so just click the select sheet box in the upper left and
then Sort Ascending.

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