Help

Convert comma separated listed into individual cells

Topic Labels: Formulas
612 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