Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Reply
