Can you tell me formula to make bullet list from comma separated text?
eg text: "text1, text2".
expected output:
• text1
• text2
Formula to make bullet list from comma separated text
+1+5This 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
Hi! I have a concatenate formula with a bunch of text. In the middle of the text I’d like to put a bulleted list. I can’t figure out where to add the portion of the formula you shared above :
"• " & SUBSTITUTE({your field here},", ","\n• ")
My formula currently looks like
CONCATENATE(
“Hi”,
IF(some conditional stuff),
“Text that needs to be in paragraph form followed by text that needs to be in bulleted form followed by text that needs to be in paragraph form.”
)
And I need it to look like:
CONCATENATE(
“Hi”,
IF(
some conditional stuff
),
“Text that needs to be in paragraph form.
- A few bullets that end in periods.
- A few bullets that end in periods.
A bit more text in paragraph form.”
)
Thanks!
+31Here’s a working version, but you’re probably pulling data in from other fields so I don’t think it’ll work for you?
CONCATENATE(
"Hi\n\n",
"Text that needs to be in paragraph form.\n\n",
" • A few bullets that end in periods.\n",
" • A few bullets that end in periods.\n\n",
"A bit more text in paragraph form."
)
Could you provide a screenshot of your data and an example that you’ve manually created of the desired output text?
In this case, the data is all text- no pulling in other formulas!
How did you do get the bullet point in this part?
" • A few bullets that end in periods.\n",
Thanks!
+31It’s just copy pasted? Here: •
Sorry I feel like I’m missing something!
Copy paste! Thank you so much! I was trying to use “* “ which auto converts to bullets in many programs, but copying that bullet was perfect- thank you!
However, I’m getting a lot of line breaks between the text when I use either \n or <br> when I use the formula in the Gmail automation. This screenshot is the formula pulled into a gmail automation
+31Hm could you provide a screenshot of the text? If it helps, removing the actual newline can be helpful, for example here’s my text:
And here’s the output:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.