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

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!

Here’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!

Terms & ConditionsAccessibility statement