How can I automatically create a string of reference designators

I have BOM information which looks like this in a single Excel cell: R1-R5.

Does anyone have a formula or command for automatically changing that cell to: R1,R2,R3,R4,R5

Thanks for your help