Clay Icon

How to Extract and Consolidate Cell Details with Formulas

·
·

Can someone help with building a formular that pics of values from cell details such as contact info and puts all the infromation each value separated by Komma or something into a new column?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Vince, thanks for reaching out! Happy to help you out with this, what data points do you need to extract? Is it the company name, location, website? Let me know!

  • Avatar of Vince W.
    Vince W.
    ·
    ·

    Arturo O. its all the values grouped as company info. As for some company value 6 might be linkedin profile for others 4 and so on its not possible to use the values by their position. Hence I want to make one cell grouping all the values seperated by komma together and than extract the Social Profile phone numbers what every I need with a search integrated formula

  • Avatar of Vince W.
    Vince W.
    ·
    ·

    Arturo O. already solvfed build the formulas by myself! Thanks!