Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Convert comma separated listed into individual cells

Topic Labels: Formulas
882 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

Hello everyone,

I have a cell that contains a comma separated list of images, examples below, I’d like to separate each value into a new cell, however I’d like this value to be strictly the url. Does anyone know how I can get this solution?

Thanks in advance

EX:

LIST:
2020-10-09 08.59.08.jpg (https://dl.airtable.com/.attachments/0394c79d/2020-10-0908.59.08.jpg),2020-10-09 08.59.37.jpg (https://dl.airtable.com/.attachments/c9a6eabc/2020-10-0908.59.37.jpg),2020-10-09 09.00.14.jpg (https://dl.airtable.com/.attachments/e15451a9/2020-10-0909.00.14.jpg),2020-10-09 09.00.26.jpg (https://dl.airtable.com/.attachments/cd631799/2020-10-0909.00.26.jpg),2020-10-09 09.00.41.jpg (https://dl.airtable.com/.attachments/6cd5bde0/2020-10-0909.00.41.jpg),2020-10-09 09.01.03.jpg (https://dl.airtable.com/.attachments/fc16571d/2020-10-0909.01.03.jpg)

DESIRED END RESULT

Cell 1
https://dl.airtable.com/.attachments/0394c79d/2020-10-0908.59.08.jpg

Cell 2 (Right of cell 1 on the same row)
https://dl.airtable.com/.attachments/c9a6eabc/2020-10-0908.59.37.jpg

Cell 3 (Right of cell 2 on the same row)
https://dl.airtable.com/.attachments/e15451a9/2020-10-0909.00.14.jpg

etc…

0 Replies 0