Best answer

List cell values, and separate each with comma, but for last one use 'and' to separate

Hi, how would I list cell values separated by comma, but for the last value separated by the word "and".

For example, 'Apple, Orange and Pear'.

If the third cell is empty, then 'Apple and Orange'.

Thank you.

Best answer by Troy Tessalone

Try a Code step: https://zapier.com/apps/code/help

Otherwise you’ll need to use Filter/Paths with Formatter steps.

Filter: https://zapier.com/apps/filter/help

Paths: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths

Formatter: https://zapier.com/apps/formatter/help

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Otherwise you’ll need to use Filter/Paths with Formatter steps.

Filter: https://zapier.com/apps/filter/help

Paths: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths

Formatter: https://zapier.com/apps/formatter/help

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

Thank you Troy

Sign up