Thread: Removing Dates from Cells

Hi,
I need your help in removing year ranges from column A.
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 1994-ON 1.8 LITRE ADR,AFY
5000 2.1 & 2.3 LITRE 2/1985-10/88


I need them in such form..

Column A

400 TURBO DIESEL
4000SE
5000 2.1 & 2.3 LITRE
A4 1.61 ADP
A4 1.8 LITRE ADR,AFY
A4 1.8 LITRE ADR,AFY
A4 1.8 LITRE ADR,AFY
5000 2.1 & 2.3 LITRE


Thanks In Advance

can anyone help please?

Waiting for your expert opinion