Adding content to start and end of each paragraph within cells

Tom Allen

Board Regular
Joined
Sep 26, 2014
Messages
92
Hi I have data that is formatted like so:

Kneeling for a while and struggle to get up after all that trimming, pruning, and work in the flowerbed? You need a kneeler with a frame. This one from Gardman might be just the ticket. With a sturdy frame surrounding a comfortable foam pad, you'll be able to push yourself up no problem. The frame even folds away for easy storage when not in use.
The steel frame is lightweight, so this product can still be moved around the garden with ease.
Flip the kneeler up the other way, and you can even use this versatile product as a stool!

I need to be able to add tags around each new paragaph, so it should be formatted like so:

HTML:
Kneeling for a while and struggle to get up after all that trimming, pruning, and work in the flowerbed? You need a kneeler with a frame. This one from Gardman might be just the ticket. With a sturdy frame surrounding a comfortable foam pad, you'll be able to push yourself up no problem. The frame even folds away for easy storage when not in use.

The steel frame is lightweight, so this product can still be moved around the garden with ease.

Flip the kneeler up the other way, and you can even use this versatile product as a stool!

I am at a loss on how to go about this however.

Each cell has different text in it of varying length. Some have multiple paragraphs, some only one and some have no text.

All these cells are in column N starting in row 2.

I have tried looking for something similar but the code I found only seems to work by adding tags around the entire content instead of each paragraph.

http://stackoverflow.com/questions/25744249/append-p-and-p-tags-to-the-text-in-all-the-cells-in-a-coloumn-in-vba-the-c
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Not sure how to include p tags in the code but they should have p tags around each paragraph

< p >Kneeling for a while and struggle to get up after all that trimming, pruning, and work in the flowerbed? You need a kneeler with a frame. This one from Gardman might be just the ticket. With a sturdy frame surrounding a comfortable foam pad, you'll be able to push yourself up no problem. The frame even folds away for easy storage when not in use.</ p >

< p >The steel frame is lightweight, so this product can still be moved around the garden with ease.</ p >

< p >Flip the kneeler up the other way, and you can even use this versatile product as a stool!</ p >
 
Upvote 0

Forum statistics

Threads
1,224,527
Messages
6,179,348
Members
452,907
Latest member
Roland Deschain

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top