The attached spreadsheet displays product information.
1.Column D needs to be split so the first word is also in column C. (See example in red).
2.This could be tricky! Collumn 'AM' displays product categories separated by a semi colon (;). Each category needs to be placed in a separate column. Sometimes column 'AM' will include up to five different categories. I am only concerned with splitting the first two categories.
e.g.
Maintenance & Consumables;Lubricants & Cutting Oils|SPECIAL OFFERS; Maintenance & Consumables - Special Offers|SPECIAL OFFERS;All Offers And Deals
I would want
Maintenance & Consumables in collumn 'AK'
Lubricants & cutting oils in collumn 'AL'
similarly for
Hand Tools;Bits
I would want
Hand Tools in column 'AK
Bits in column 'AL'
I would always want the semi colon to be removed.
Good Luck!