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.