Thread: convert range of years to series
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
autoguy autoguy is offline
external usenet poster
  
Posts: 5
Default convert range of years to series
I have the following range of years in column A
02-08
91-99
92-96
01-03

What I need (in column B) is
02 03 04 05 06 07 08
91 92 93 94 95 96 97 98 99
92 93 94 95 96
01 02 03

Thanks for your help!
Reply With QuoteReply With Quote