View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Geoffric Geoffric is offline
external usenet poster
 
Posts: 11
Default Linera fill formula

I have data in columns A and B, as follows:

C00010 C00015
T02030 T02035

In column C, I want to create an incremental Fill series formula (i.e. not
using the Fill handle method) so that the result looks like this:

C00010
C00011
C00012
C00013
C00014
C00015
T02030
T02031
T02032
T02033
T02034
T02035

Ive tried the toolbar route of Edit\Fill\Series\ Type €“Linear\ Step Value
1\Stop Value, but having the letter in front of the numeric part of the data
seems to stop it performing. Any suggestions will be gratefully received.

--
Geoff