View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pc.. pc.. is offline
external usenet poster
 
Posts: 1
Default How do I auto format data so that the middle letter changes. EG 2.

I am trying to set up an exel spread sheet so that I can change the data by
dragging down instead of re-typing each one, so for example I want accross
the top to be: 21A01 21A02 21A03 etc which I can just drag and it will
automatically change the number digit but I am trying to change the down
collum to read
21A01
21B01
21C01 etc etc