Break Line based on character for use in Mail Merge

Greetings All,

 

I am seeking advice on how to add a break line to a string based on a specific character. I was able to get the table to look semi correct using ETL + Beast Mode.

 

REPLACE(`String`,';','<br>')

 

But I am unable to use my mail merge doc because the data doesn't doesn't export to excel correctly. I am a bit stumped. Please review the images below and let me know what other options I may have.

 

Any assistance would be greatly appreciated. Thank you in advance. 

 

 

 

Comments