Formula to turn a Combined Text Summary field into a vertical list

This would be a new text Rich Text formula field.  

var text CombinedText = ToText([My Text Concatenation Field for Child Records]);

var text ConvertToVerticalListWithBullets=
Trim(SearchAndReplace($CombinedText, " ; ","<br>&#8226")); // separate entries with a new line and a bullet

If($ConvertToVerticalListWithBullets<>"", "&#8226") // this is a bullet for the first entry
&
$ConvertToVerticalListWithBullets


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------