Hi guys,

I am trying to Find specific text in a cell (2014) as it happens and require to copy from 4 characters in front of the found text so example.

Cell K6 contains A01677623022014AH014302BOX3 8ED

I want to find 2014 and past from 23022014 into another cell.

Any ideas how I can do this.

The numbers of characters in the cell changes daily and 2014 is the only constant (untill 2015 that is)

regards