Skip to main content

Hello! I have a long text field with information captured as rich text:

  • Achievement 1
  • Achievement 2
  • Achievement 3

I need these Achievements converted to a comma separated text field. How do I get the above, converted to the below?:

Achievement 1, Achievement 2, Achievement 3

Appreciate any guidance!!!

Try this:

SUBSTITUTE(
    SUBSTITUTE(
        TRIM({Field Name}),
        "- ", ""
    ), "\n", ", "
)


Try this:

SUBSTITUTE(
    SUBSTITUTE(
        TRIM({Field Name}),
        "- ", ""
    ), "\n", ", "
)


Perfect, thank you!!!