How to Split Company Names into Separate Columns in Excel

I have a column that has company names separated by commas. How do I separate by comma to separate columns

· Sorted by Oldest

Clay
APP
·
·
To separate comma-separated company names into separate columns: 1. Use Extract Data From Values to process the CSV data 2. Add the correct column using the Forward Slash (/) command 3. Apply this custom extraction Regex: [^,"]+"?[^,"]+ This will split the values into a list, which you can then send to new columns or tables as needed.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.

Clay
APP
·
·
To separate comma-separated company names into separate columns: 1. Use Extract Data From Values to process the CSV data 2. Add the correct column using the Forward Slash (/) command 3. Apply this custom extraction Regex: [^,"]+"?[^,"]+ This will split the values into a list, which you can then send to new columns or tables as needed.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.