Are <p> and </p> the only HTML tags in this field or are there others?
Here's a calculation that will strip out the two shown in your example. you can easily extend it to strip out additional tags:
Trim ( Substitute ( text ; ["<p>" ; "" ] ; ["</p>" ; "" ] ) )
Thanks for your response. But this type of tag is present in the string more than one.
The substitute function will delete all instances of each tag you set up with the substitution brackets like I've posted.
The spaces before and after the tag may be an issue, however. If you want you can use TrimAll instead of trim to reduce all spaces between words to a single space. You could also include a trailing space in the substitution brackets, but if your formatting isn't always consistent, this may double the number of substitution brackets like this:
Substitute ( text ; ["<p>" ; "" ] ; ["</p>" ; "" ]; ["<p> " ; "" ] ; ["</p> " ; "" ] )