Custom Fill Series in a column help

[johnnymca]

I want to create a custom fill series for a column that goes like this:
101-B
101-R
101-G
102-B
102-R
102-G
103-B
103-R
103-G

and so on. That way instead of typing manually all the way to 240 each with B, R and G following after each number. Can someone help with this?

 

[AlphaFrog]

Put this in A1, A2, and A3

101-B
101-R
101-G

Put this in A4 and drag down
=LEFT(A1,3)+1&RIGHT(A1,2)

If you want to replace thie formulas with values, select column A and Copy. Then with column A still selected, Paste Special: values

 

[johnnymca]

AlphaFrog: You are a lifesaver! I barely joined this forum earlier today and already received an answer. This forum is awesome! Thank you VERY MUCH!