[Raph Nicolas]

Hi guys, I’m having a similar issue but wondering if this could be adapted to work with external text. I’m importing copy from a spreadsheet (with Dataclay’s Templater) and would like to choose in the spreadsheet which words get highlighted (e.g. yellow instead of white) in the comp’s text box. What would this formula look like if a special character (for example “*”) in the text field marks the word with different color? e.g. “Lorem ipsum *dolor sit amet*, consectetur adipiscing elit” returning “dolor sit amet” in yellow while stripping * away?