View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
raulavi raulavi is offline
external usenet poster
 
Posts: 10
Default resequence with a prefix

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