you mean they all have prt:000, and you need them to be 001,002.etc?
in a blank row, enter prt:001, then click on that cell. Notice the "fill
handle" a black square in the lower right hand corner of the cell. click and
hold it and drag down, it will make prt:001, prt:002, etc as you go down.
Now, in another cell, concatenate that cell with the last part of the
existing cells-
=concatenate(b1,right(a1,len(a1)-7))
or something like that

"Bob I" wrote:

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