How to replace commas with line breaks in a field

#1

Currently I have a field that contains multiple products separated by commas.

Is there a way to “find” all commas and “replace” them with the “/n” line break?

I would like the product field which currently looks like this
“product1, product2, product3, product4”

to appear in the field as
product1
product2
product3
product4

Is there a way to do this?

#2

Add a formula field using this formula: SUBSTITUTE({Product Field},",","\n")

3 Likes