I've seen this asked on the forum before and I've done some researching, but those questions/answers are more complex than my simple need.

I have a string of characters that I need to 'trim' to the far left and the far right of the desired data.

Example: blahblah.jpg ( https://busyevent.thingy.com/yupyup/...D/blahblah.jpg )

I would like to remove all of the data in bold/red and put the remaining string/URL in the target cell.

Your help is appreciated.