Separate year of production

[patko15]

Hello everybody!


I have a very big database with car specifiactions, including the years of production like this:


2002-2008
2008-2013
2013-2015
2009-2013
2013-2015
2009-2014


As you can see, every value is different, and I need to split them; fill inbetween every year, and separate them with ;.


Example: 2002-2008 - should come back like this: 2002;2003;2004;2005;2006;2007;2008.


Any advice?


Thank you in advance!
Patko15

 

[Jon von der Heyden]

Cross post: Separate year of production

Hi Patko15

Welcome to the board.

Same rule applies, i.e. we need you to cross reference cross posts. We realise though that these rules aren't obvious to newcomers.

REgards
Jon

 

[Jon von der Heyden]

If those values are in A1:A6

1. Select C1:I1
2. Enter: =TRANSPOSE(ROW(INDIRECT(SUBSTITUTE(A1,"-",":"))))
3. Commit with Control+Shift+Enter, not just Enter
4. Copy C1:I1
5: Paste to C2:I6

 

[patko15]

If those values are in A1:A6

1. Select C1:I1
2. Enter: =TRANSPOSE(ROW(INDIRECT(SUBSTITUTE(A1,"-",":"))))
3. Commit with Control+Shift+Enter, not just Enter
4. Copy C1:I1
5: Paste to C2:I6

Thank You for the advices, and I can gladly pronunce that my problem was solved! I know that the best thing that I can do is to stay connected to this forum because the opportunities to learn are very much.

 

[patko15]

I tried to mark this thread as SOLVED but there is no such function. I beg the moderators to mark this forum as [SOLVED]. Thank You!

 

[Jon von der Heyden]

Thank You for the advices, and I can gladly pronunce that my problem was solved! I know that the best thing that I can do is to stay connected to this forum because the opportunities to learn are very much.

You're welcome.