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

timework0

New Member
Joined
Sep 16, 2016
Messages
7
Hi everyone, Thank for coming in.

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

Product DescriptionBP1BP2BP3
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 HammerSolid,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

<tbody>
</tbody>
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,312
Office Version
365
Platform
Windows
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.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">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 style="text-align: right;;">410</td><td style=";">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</td><td style=";">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</td><td style=";">Plastics, and metal hammer. Suitable for cars, trains, buses, trucks, ships and so on. Package Included: 1 X Emergency Hammer</td></tr></tbody></table><p style="width:8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Split Text</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">=LEN(<font color="Blue">D2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F2</th><td style="text-align:left">=LEFT(<font color="Blue">D2,FIND(<font color="Red">" ",D2,E2/3</font>)-1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G2</th><td style="text-align:left">=MID(<font color="Blue">D2,LEN(<font color="Red">F2</font>)+2,FIND(<font color="Red">" ",D2,LEN(<font color="Green">F2</font>)+E2/3</font>)-LEN(<font color="Red">F2</font>)-2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H2</th><td style="text-align:left">=RIGHT(<font color="Blue">D2,E2-LEN(<font color="Red">F2&G2</font>)-2</font>)</td></tr></tbody></table></td></tr></table><br />
 

Forum statistics

Threads
1,082,510
Messages
5,365,988
Members
400,865
Latest member
LuciaRomo

Some videos you may like

This Week's Hot Topics

Top