Converting rich long text to comma separated text

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", ", "
)

Screen Shot 2021-07-04 at 2.07.26 PM

1 Like

Perfect, thank you!!!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.