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,
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,