Hi,

I'm looking for a worksheet function (NO VBA involved) in order to achieve the following:

In cell A1 there is the string: 1,2,3,6-9

In Cell B1 I want to present: 1,2,3,4,5,6,7,8,9 (separated by commas)
In cell C1 I want to present: 1 2 3 4 5 6 7 8 9 (separated by spaces)

I could also have strings like: 8,9,10,11-14 or 11,12-15 which should be presented as:
8,9,10,11,12,13,14 and 8 9 10 11 12 13 14
11,12,13,14,15 and 11 12 13 14 15

I tried to use some combinations of: Substitute/Len/Find/Mid/Right/Row(Indirect... (not is this order) but without success.

I hope I made myself clear.

Thanks, Elm