Skip to main content

Can you tell me formula to make bullet list from comma separated text?
eg text: "text1, text2".
expected output:
• text1
• text2

This should do it:

"• " & SUBSTITUTE({your field here},", ","\n• ")

 If you expand the cell, or copy the text somewhere else you will see that it is working


Reply