VBA conversion from hyphens to CSV

[jcoat]

I have a column that contains CSV. For example,

1,2,3,4,5
2,4,1,3,5
4,1,2,3,5

The order of these numbers is important as it records a sequence. Unfortunately, my data includes a bunch of shorthand. The above data is recorded in my data as follows:

1-5
2,4,1,3,5
4,1-3,5

How do I write a macro to clean up the hyphens so I get this:

1,2,3,4,5
2,4,1,3,5
4,1,2,3,5

Thanks

 

[Rick Rothstein]

See the code I posted in my mini-blog article here...

<!-- title / author block --> Return individual page numbers from a list of pages and ranges (e.g., 1,5,9-12,20-18)

 

[jcoat]

Nice... Exactly what I needed.

You're right about this problem not coming up often, but your function is quite lovely to have around when it does.

Thanks.