If a cell, say A1 contains:

1..5, 7, 9

I want to find ".." and replace with missing numbers in the sequence that are comma separated. Output in column B1 would be:

1, 2, 3, 4, 5, 7, 9

Tried a function, no luck. I know it can be done through vba but trying to avoid that.