Creating a Formula for List Formatting in Excel

Joe H. · 2025-04-24 18:00:04.277903+00

I am trying to create a formula and wondering if you have any ideas. I have a column with lists and want the formatting to say "apples, bananas, and oranges" or "apples and oranges". Is there a formula i can write?

To format your list column, you can use our AI Formula Generator. Here's how: 1. Add a new column and select "Formula". 2. In the AI Formula Generator box, type something like: "Format the list in /YourListColumn to display items separated by commas, with 'and' before the last item". 3. Click "Generate Formula". 4. Review the sample output to ensure it matches your desired format (e.g., "apples, bananas, and oranges" or "apples and oranges"). 5. If it looks good, click "Save Formula". This should create the formatting you're looking for. If you need to adjust the formula, you can edit it directly or use the AI Generator again with more specific instructions. If you need further assistance, you can request human help by clicking on "Talk to a person" in this chat.

Sources: Formulas Order a list with Clay

5 comments