Grind-my-teeth: The year isn't set off by a unique delimiter.
Bang-my-head-on-the-desk: The year does not necessarily appear in the same spot in the text string from one cell to the next.

I have a supplier that provides access to new product information; we log in, generate a report of the new products being released, and then export that to a local Excel file.
This used to work pretty well; we got the data we needed, and it took relatively little massaging to prep it for our e-commerce platform.
The essential data was in discrete, separate columns: UPC, Title, Studio, Street Date, Format, Year, Number of Discs.

They've evidently changed where they are sourcing their data, or how they are compiling it.
The new format is just a nightmare. They've combined the data from a number of formerly separate columns into a single column.
Where once had:
012584875982 | Ten Seconds to Hell | Warner Bros. | 09/13/2016 | Blu-ray | 1944 | 2

We now get:
012584875982 | Ten Seconds to Hell (1944/Blu-ray/2Disc) | Warner Bros. | 09/13/2016

To make things much worse, they are not consistent with the mashed-up data. The next row below might look like:
886985473254 | Running Scared (DVD/Ws/1986) | New Video | 09/13/2016

or:
886741282145 | Viva Maria (Dvd/1965/Ws 2.35/French/English Subtitles) (2 Discs) | Lorber | 09/13/2016

I can figure out how to extract the format, and probably even the number of discs, but I haven't the faintest idea where to start on the years.
I can't possibly do an If-Then for every potential year from 1922 through 2016.
What I need is some code that would look at each cell and go, "If you see 4 numbers in a row in this string of text,then assume that's a year and extract it." I'm pretty sure that Excel won't make that distinction.
I don't think I can do it with wild-cards, because "look for '19??' or '20??' would get tripped up by something like Imax-Wonders Of The Arctic (Blu Ray W/Digital) (Ws/Hd/1920X1080/Eng)


I'm wide open to suggestions that don't involve "ask your supplier to provide better data," because that ain't gonna happen
I've got to make this work somehow; it's far too many rows to clean up manually each week.
I'm really hoping somebody out there has some insight.