.png){kind=logo}
Split Comma-Delimited Text into Multiple Rows in Excel
How do I turn a comma-delimited text within a cell into multiple rows within the same column? I have multiple linkedin urls from a search result that I would like separated into rows.
To split comma-delimited LinkedIn URLs within a cell into multiple rows in the same column, you can use our "write to table" feature. Here's how: 1. Use the "Extract Data From Values" option to process the CSV data. 2. Add the correct column using the "/" (Forward Slash) command. 3. Apply a custom extraction Regex:
[^,"]+"?[^,"]+This will split the values into a list. Once complete, you can send the newly created list to the desired column or table using the "write to table" feature. If you need further assistance, please don't hesitate to ask for more details or request human support.Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Joel M.··can I use a formula to split a concatenated list from one cell to multiple rows?
Yes, you can use a formula to split a concatenated list from one cell into multiple rows. Here's how: 1. Use the "Extract Data From Values" feature to process your concatenated list. 2. Add a new column using the "/" (Forward Slash) command. 3. Apply a custom extraction Regex:
[^,"]+"?[^,"]+This will split the values into a list. 4. Once you have the list, use our "write to table" feature to map each item individually to rows in a destination table. Alternatively, you can use the AI formula generator to create a custom formula for your specific needs. If you need more detailed guidance, please ask and I'll be happy to provide step-by-step instructions.Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
- Joel M.··
I am trying to use a formula to split the concatenated linkedin urls into rows that correspond with their respective company name. For example, row 1 has 5 linkedin urls that match the google search criteria. I want those moved to rows in a new table along with the company they work for so I can enrich the list further.
Hey there Joel thanks for reaching out, in this case I would recommend using a Write to table integration here in order to get these all into their own rows. Herre is a loom showing you how we could do this. https://www.loom.com/share/d316dbd8a08d417abf2d696e7c2caf90?sid=aaabe159-4ac6-42a0-a0a0-d7c60d0f1b89
- Joel M.··
Thank you!