Find text in cell and copy from 4 characters in front of the found text.

[dgenty]

Hi guys,

I am trying to Find specific text in a cell (2014) as it happens an
require to copy from 4 characters in front of the found text s
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 onl
constant (untill 2015 that is)

regard

 

[Claus Busch]

Hi,

Am Thu, 20 Feb 2014 14:51:03 +0000 schrieb dgenty:

Cell K6 contains A01677623022014AH014302BOX3 8ED

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

try:
=IF(ISNUMBER(FIND(2014,K6)),MID(K6,FIND(2014,K6)-4,8),"")


Regards
Claus B.

 

[Claus Busch]

Hi,

Am Thu, 20 Feb 2014 16:58:17 +0100 schrieb Claus Busch:

=IF(ISNUMBER(FIND(2014,K6)),MID(K6,FIND(2014,K6)-4,8),"")

or:
=IFERROR(MID(K6,FIND(2014,K6)-4,8),"")


Regards
Claus B.