I have a software package that requires serial number effectively data to be entered in a particular format.

As this can cover hundreds of lines I would like to make it less tedious to enter, and as my MACRO knowledge is very basic I would appreciate some help.

The data starts off in format below in example 1. After the data is CUT from the .html or .pdf document and PASTE into EXCEL. I would like the MACRO to start by pressing an activate button within EXCEL,

The serial numbers always have four digits with single serial numbers being separated by spaces and ranges being separated by a hyphen with the odd carriage return depending on how many numbers there are.

I would like the data to end up in two separate columns as shown in example 2.


Example 1 (Starting format)
* indicates space
- indicates a range, this needs to be separated into two separate columns

2252*2254*2256*2257*2259*2272*2274-2276*2278*2280*2282*2284*2286-2641*2643-2681*2683-2712*2714-2717*2719*2721*2724*2726*2727*2729* 2733*2735 *2738*2739*2746

Example 2 (Finished format ready to be paste into software package
2252
2254
2256
2257
2259
2272
2274 2276
2278
2280
2282
2284
2286 2641
2643 2681
2683 2712
2714 2717
2719
2721
2724
2726
2727
2729
2733
2735
2738
2739
2746

Many Thanks in advance for any help you can give.