Help

Formula to make bullet list from comma separated text

Topic Labels: Formulas
827 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kumar99
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Anthony
6 - Interface Innovator
6 - Interface Innovator

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