example, if A1="abc def 2016 ghi jkl"

B1 should="abc def "
C2 should="2016 ghi jkl"

It also needs to account for multiple instances of years in some strings and only extract the first instance. I would prefer not to use VBA if possible.

I would use a search/replace technique but there are more than 70 different years, and that would be too tedious and time-consuming. Thanks!