Thread: Convert Range of Years to Individual list (integers)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] brian@justsuspension.com is offline
external usenet poster
  
Posts: 9
Default Convert Range of Years to Individual list (integers)
For example, I need to convert this:

1995-2000 (1 column, 1 row)

to this:

1995
1996
1997
1998
1999
2000 (1 column, 6 rows)

If anyone can help, it will be greatly appreciated!

Reply With QuoteReply With Quote