Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Converting rich long text to comma separated text

Solved
Jump to Solution
402 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

Try this:

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

Screen Shot 2021-07-04 at 2.07.26 PM

See Solution in Thread

2 Replies 2

Try this:

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

Screen Shot 2021-07-04 at 2.07.26 PM

Perfect, thank you!!!