remove variable chars in excel (1 Viewer)

Hi,

I have a list of products with their description. What i need to do is remove the last few characters to convert description into style.

Example.

ALTRA PINE M8ALTRA PINE M9ALTRA SIM LC M10ALTRA SIM LC M11ALTRA SIM LC M12

What i would like to see is just Altra Safeguard M and Altra Shield LC.

I have been using the formula =left(Text, len(text)-2) but is there a way to automate this. I have a lot of products, where I need to remove only 1, 2 or 3 characters.

Thanks,

Can you attach a sample of your data and show what you have and also show what you need, your example in your thread doesn't give a clear definition.