Add html code before each capitalized word in a sentence

[esb128]

Hello,

I need help creating a formula to insert an </li><li> in the following data before each capitalized word in the sentence below, it must skip the first capitalized word in the sentence.

Data

Positive seal sealing and holding is accomplished instantaneously Reusable connect and disconnect numerous times Full flow fitting seals on outside diameter of tubing Internal hex allows ease of assembly in tight places Pre-applied thread sealant

Result

Positive seal sealing and holding is accomplished instantaneously</li><li>Reusable connect and disconnect numerous times</li><li>Full flow fitting seals on outside diameter of tubing</li><li>Internal hex allows ease of assembly in tight places</li><li>Pre-applied thread sealant

 

[Fluff]

Duplicate to: Need Help Adding Characters to a line of information

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.