Inserting quotation marks into a string

[Alex_Chediak]

Hello -

I’m looking for help creating a formula that will insert quotation marks around names in a string that are separated by commas. The number of names in the string will vary. For example the string Jane Doe, John Smith would become “Jane Doe”, “John Smith”.

Is there a formula that I can use to do this?

[kuovonne]

Welcome to the Airtable community!

If the comma will always be followed by a single space, you can try this formula.

IF(
  FIND( ', ', {text field}),
  '"' & SUBSTITUTE({text field}, ', ', '", "') & '"',
  {text field}
)

However, this will only work if the initial string is actually a string, and not an array (such as from a lookup or linked record). It also won’t work if there are multiple spaces or no space after the comma.