How to Split Countries from Claygent into Separate Cells in Excel

·Apr 07, 2025 07:14 PM·

Hey guys, quick question: I used claygent to identify which countries some companies are hiring. Now I have all results in a single cell. how do I break down claygent's response into, let's say, 3 distincts cells with one country as a response into each cell?

1

4 comments

· Sorted by Oldest

Summiya B.
·
·
Use formula to separate the results.
Summiya B.
·
·
click on manage accounts
Felipe d.
·
·
Summiya B. do you have any idea on how to do it? I'm trying some not successful prompts (i'm recently new to clay universe)
noor
·
·
yea, super easy. Just add a new column, choose “Split Text,” and pick the Claygent column. Use a comma as the separator (or whatever it's using), and it’ll turn the response into a list. Then just make a few more columns and grab item 1, 2, 3, etc. from that list. Each one drops into its own cell. Takes like 30 seconds once you see it.
1

Summiya B.
·
·
Use formula to separate the results.
Summiya B.
·
·
click on manage accounts
Felipe d.
·
·
Summiya B. do you have any idea on how to do it? I'm trying some not successful prompts (i'm recently new to clay universe)
noor
·
·
yea, super easy. Just add a new column, choose “Split Text,” and pick the Claygent column. Use a comma as the separator (or whatever it's using), and it’ll turn the response into a list. Then just make a few more columns and grab item 1, 2, 3, etc. from that list. Each one drops into its own cell. Takes like 30 seconds once you see it.
1