Add text to beginning of each line

I want to add a bullet or emoji to the beginning of each line. To make things more complicated I have a CSV file that I’m importing that has | as line breaks. With a quick formula I’m changing | to \n and then adding a the bullet or emoji after the \n but obviously this won’t change the first record.

Is there a (simple) way to add text to the beginning of each line?