Converting rich long text to comma separated text

[nisha_elliott]

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

[Justin_Barrett · Accepted solution]

Try this:

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

[nisha_elliott]

Perfect, thank you!!!