Subtracting text

[bgowood]

I have a large number of key words in A1 e.g. Bottle Hat Ring Mat glasses Fire free etc

A product title is A2 Best selling Glasses in a ring shape free with this bottle.

How do I get A1 - B1 in C1?????

Then how do I split that into D1 E1 F1 G1 H1 using only 50 characters in each box.

e.g
a1
Bottle Hat Ring Mat glasses Fire free

B1
Best selling Glasses in a ring shape free with this bottle

C1
Hat Mat Fire

D1
Hat Mat Fire up to 50 characters

E1
50 more Characters

I'm using Excel 2011 for Mac

[RobertMika]

Hello and welcome.
Quite hard to understand...
Can you post an example in your workbook?