Did a search but didn't get the exact results i was looking for.
Here's my situation, i have a cell with multiple numbers in it. The numbers are separated by a comma, and sometimes there is a number range in the cell. So for example, one cell may contain 39,40,43,45-49. How do I extract the numbers? Also for 45-49, I want all the numbers in between i.e. 45 46 47 48 49.
Any help is appreciated.