Image URL Formula?

I’m hoping someone might be able to help me figure this out… To put it simply I have one column full of images (just one image in each cell) but 1000’s of images total. I need another column, residing next to it that contains the URL for each image, and I haven’t found an easy way to do this aside from just copy and pasting each individual URL. Which gets very repetitive and time consuming doing this thousands of times. Is there a formula out there that could pull these image URL’s and fill each corresponding cell (to the right of the image cell) with the URL (of the image in the cell to the left of it)? Maybe I’ve just been looking at it for too long and there’s a much simpler solution?

Hi @Michael_Baugher ,

You can use a formula like this:

SUBSTITUTE(
  MID(
    {Attachment Field},
    FIND(
      "https://dl",
      {Attachment Field}
    ),
    250
  ),
  ")",
  ""
)

Just make sure to replace {Attachment Field} with the actual name of the field you’re using to store them.

Worked like a charm! Thanks so much, saved me hours of copy/pasting!

1 Like

Happy to help Michael!