Hi everyone, Thank for coming in.
I have product informations and would like to seperate into 5 bullet point like below.
<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
I have product informations and would like to seperate into 5 bullet point like below.
Product Description | BP1 | BP2 | BP3 |
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 | 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 |
<tbody>
</tbody>
=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