Feb 03, 2023 04:45 AM
Can you tell me formula to make bullet list from comma separated text?eg text: "text1, text2".expected output:• text1• text2
Feb 03, 2023 07:56 AM
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
