Conversion of excel file data format

Input file in spreadsheet format has the following features: Column A: Name Column B: numbers delimited with column or comma or showing a range using hyphen. other columns - random data. Output file must have format: Column A: Name Column B: one number per line other columns - random data. Task is to create a macros (preferred) or external application that would convert spreadsheet in requested format: one number per line. ## Deliverables Example: input data <col width="248" style="width: 186pt;" /> <col width="506" style="width: 380pt;" /> | Argentina Corredores | 54221; 54223; 54230; 54232; 54291; 54299; 54342; 54348; 54353; 54358; 54381; 54387 | output data: | Argentina Corredores 54221 | | | | | | Argentina Corredores 54223 Argentina Corredores 54230 | | and so forth. Same rule with comma as delimiter. If range is shown: 74-80 than 7 lines are created. In put data can also be mixed: ColumnA Column B <col width="109" style="width: 82pt;" /> <col width="210" style="width: 158pt;" /> | 374 | 93-94, 77, 98 | resulting output should show: 37493 37494 37477 37498 with other data dulicated to each new line. | | * * *This broadcast message was sent to all bidders on Tuesday Jun 9, 2009 11:14:14 AM: The amount of data per converted file varies from few lines to several thousand lines. Generally it should not exceed Excel limit of 56K records.