I know the following is possible in Apex, but I'm wondering whether there's a way to do it with standard formula fields.
Is there a way to split up a value and wrap each bit in other text values? For example (not a real example:
Custom_Field_1 = 'This;That;Other;', but could have any number of terms.
Formula for Custom_Field_2 should wrap each term delimited by
<p></p> and remove the
; to result in