ok i have a very simple ask that I am struggling with. Brain is fried...

·Nov 30, 2023 06:24 PM·

ok i have a very simple ask that I am struggling with. Brain is fried today. How can i adjust in a column to simply change wherever there is a comma to the word "and"?

9 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Alex
·
·
https://app.clay.com/workspaces/83297/tables/t_kusjZAmwLLrs/views/gv_qbJsDZ5TNOe4
Matthew Q.
·
·
Create a new formula column!
Matthew Q.
·
·
Then use the AI formula generator and say “Replace any comma in /column with “and”
Alex
·
·
I tried that and I didnt work
Matthew Q.
·
·
https://www.loom.com/share/e3450652827342f8953f42b337355aea
Matthew Q.
·
·
Quick steps above!
Matthew Q.
·
·
looks like you were using Chatgpt instead of a formula column
Alex
·
·
Thank you sir! Will give it a shot

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Alex
·
·
https://app.clay.com/workspaces/83297/tables/t_kusjZAmwLLrs/views/gv_qbJsDZ5TNOe4
Matthew Q.
·
·
Create a new formula column!
Matthew Q.
·
·
Then use the AI formula generator and say “Replace any comma in /column with “and”
Alex
·
·
I tried that and I didnt work
Matthew Q.
·
·
https://www.loom.com/share/e3450652827342f8953f42b337355aea
Matthew Q.
·
·
Quick steps above!
Matthew Q.
·
·
looks like you were using Chatgpt instead of a formula column
Alex
·
·
Thank you sir! Will give it a shot