Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Add text to beginning of each line

posted Jan 3, 2020 7:38:17 AM

Topic Labels: Formulas

0 387 0

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?

0 Replies 0