Insert html tag on every paragraph in cell

[igibbins]

Hi

I have a spreadsheet with many post from exported news content.

Unfortunately, the content does not contain any html paragraph tags.

What I would like to do is process every content cell and identify each paragraph and enclose it with <p>....content...</p> tags.

Any help would be much appreciated.

Best regards

Ian

[Norie]

Ian

There is no closing tag for paragraphs, so you might be able to use Find/Replace or SUBSTITUTE.

How will you determine where the paragraphs begin/end though?

[igibbins]

Hi Norie

Thank you for your reply...

Good point about the end tag...

Fortunately, each paragraph has a line break between so you are right, I guess I can try finding the break and inserting the start tag...

Many thanks!

Ian