Inserting quotation marks into a string

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?

Welcome to the Airtable community!

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

  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.

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