Seperate product description into 3 bullet points. #Bullet Point, Product Description, Divide, Seperate, Features

[timework0]

Hi everyone, Thank for coming in.

I have product informations and would like to seperate into 5 bullet point like below.

[TABLE="width: 1284"]
<tbody>[TR]
[TD]Product Description[/TD]
[TD]BP1[/TD]
[TD]BP2[/TD]
[TD]BP3[/TD]
[/TR]
[TR]
[TD]Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt. You can break the car window in an emergency situation. Fixed in a holder, it will not fall even if the car bumps, and can be removed easily. Material: Engineering Plastics, and metal hammer. Suitable for cars, trains, buses, trucks, ships and so on. Package Included: 1 X Emergency Hammer[/TD]
[TD]Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt.[/TD]
[TD]You can break the car window in an emergency situation. Fixed in a holder, it will not fall even if the car bumps, and can be removed easily.[/TD]
[TD]Material: Engineering Plastics, and metal hammer. Suitable for cars, trains, buses, trucks, ships and so on. Package Included: 1 X Emergency Hammer[/TD]
[/TR]
</tbody>[/TABLE]
I have try the following fomula.
=LEN(D2) to count the description character.
Then =LEFT(D2,E2/3), =MID(D2,E2/3+1,E2/3), =MID($D2,$E2/3*2+1,$E2/3)
But the problem is some word are cut like ex. Waterproof > Wat. erproof

Anyone have ideas ? Thanks

#Bullet Point, Product Description, Divide, Seperate, Features

 

[Peter_SSs]

Is this what you want? If not please provide 2 or 3 more samples, expected results and further explanation why they are the expected results.

Book1
	D	E	F	G	H
2	Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt. You can break the car window in an emergency situation. Fixed in a holder, it will not fall even if the car bumps, and can be removed easily. Material: Engineering Plastics, and metal hammer. Suitable for cars, trains, buses, trucks, ships and so on. Package Included: 1 X Emergency Hammer	410	Solid,durable,waterproof,rustless. A must-have tool for your car. Set you free from the danger by cutting the seat belt. You can break the	car window in an emergency situation. Fixed in a holder, it will not fall even if the car bumps, and can be removed easily. Material: Engineering	Plastics, and metal hammer. Suitable for cars, trains, buses, trucks, ships and so on. Package Included: 1 X Emergency Hammer
Split Text

Cell Formulas
Range	Formula
E2	=LEN(D2)
F2	=LEFT(D2,FIND(" ",D2,E2/3)-1)
G2	=MID(D2,LEN(F2)+2,FIND(" ",D2,LEN(F2)+E2/3)-LEN(F2)-2)
H2	=RIGHT(D2,E2-LEN(F2&G2)-2)