Thread: convert range of years to series
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default convert range of years to series
Hello,

Just for the fun of it: array-enter
=MultiCat(TEXT(ROW(INDIRECT(SUBSTITUTE(A1,"-",":"))),"00")," ")

MultiCat you can find he
http://sulprobil.com/html/concatenate.html

Regards,
Bernd
Reply With QuoteReply With Quote