Thread: Cut out data from Column A to Column B

Hi,
I need your help in cutting out different year ranges and year formats from Column A to Column B
for example Column A contains

Column A

400 TURBO DIESEL 1982-83
4000SE 1980-81
5000 2.1 & 2.3 LITRE 85-88
A4 1985-1988 1.61 ADP
A4 1.8 LITRE ADR,AFY 1994-ON
A4 1.8 LITRE 1994-ON ADR,AFY
A4 1.8 LITRE ADR,AFY 1994-ON
5000 2.1 & 2.3 LITRE 2/1985-10/88


I need them in such form..

Column A ________________________________ Column B

400 TURBO DIESEL ___________________________ 1982-83
4000SE _____________________________________ 1980-81
5000 2.1 & 2.3 LITRE ____________________________ 85-88
A4 1.61 ADP _________________________________ 1985-1988
A4 1.8 LITRE ADR,AFY ____________________________ 1994-ON
A4 1.8 LITRE ADR,AFY ____________________________ 1994-ON
A4 1.8 LITRE ADR,AFY ____________________________ 1994-ON
5000 2.1 & 2.3 LITRE ____________________________ 2/1985-10/88


Thanks In Advance

as long as there is always a - and its only between dates