Hi, experts! Thank you in advance for your help

Here is my scenario:

I have a worksheet full of cells that have ranges desribed like "C1-C4" or "R30-R50". There could be more than one in each cell or it could be just by itself. I was hoping to write a code so that it expands those ranges and fills them out so therefore it would say "C1, C2, C3, C4" in only that cell. I can manually do it, or I can take the first character, fill it down, copy it and paste it into the cell, but I have hundreds of worksheets like this. Can any of you think of a way of doing this? I was thinking of using the character "-" and writing a code so that it takes the first letter/number combo and it expands it until it reaches the last one, but I'm not quite sure how to do it.

I'm sorry if that is not very suscinct, but I will answer any questions, if you have any.

Thank you again for your help!
-Rachel