Clay Icon

How to Split Countries from Claygent into Separate Cells in Excel

·
·

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?

  • Avatar of Summiya B.
    Summiya B.
    ·
    ·

    Use formula to separate the results.

  • Avatar of Summiya B.
    Summiya B.
    ·
    ·

    click on manage accounts

  • Avatar of Felipe d.
    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)

  • Avatar of sneha
    sneha
    ·
    ·

    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.