Help creating a list

[HMC YORK]

Hi I have a list of 87,000 lines of parts which I need to break down to single years but unsure on how I can do it on excel is there a formula or function which would allow me to do this, I have done an example below. Thank you for your help

Honda C200 62-67 Brake Light Switch - Rear 62-67


and I need to create it showing the

Honda C200 62-67 Brake Light Switch - Rear 62
Honda C200 62-67 Brake Light Switch - Rear 63
Honda C200 62-67 Brake Light Switch - Rear 64
Honda C200 62-67 Brake Light Switch - Rear 65 etc

[ChemistB]

It might help if you uploaded a small example (maybe 20 lines) so we can see how your data is laid out. Also show how you want the results to look. (Go Advanced>Manage Attachments)

[BlindAlley]

In the simple sense - using =LEFT(A1, LEN(A1)-3) will get what you need, how you fit this into your spreadsheet with multiples is why Mr Chemist is asking for a sample worksheet.

Honda C200 62-67 Brake Light Switch - Rear 62-67 Formula returns Honda C200 62-67 Brake Light Switch - Rear 62