Extract date with word/number from the sentence

[chetan123]

Raw Data <colgroup><col width="773"></colgroup><tbody> </tbody>	Desire data 1 <colgroup><col width="125"></colgroup><tbody> </tbody>	Desire data 2 <colgroup><col width="125"></colgroup><tbody> </tbody>	Desire data 3 <colgroup><col width="87"></colgroup><tbody> </tbody>
KANSAS ST DEV FIN AUTH REV UNIV KANS CTR RESH INC CALLABLE 02/01/16 @100 4% 02/01/17 <colgroup><col width="773"></colgroup><tbody> </tbody>	CALLABLE 03/01/16 <colgroup><col width="125"></colgroup><tbody> </tbody>	4% <colgroup><col width="125"></colgroup><tbody> </tbody>	02/01/17 <colgroup><col width="87"></colgroup><tbody> </tbody>
SAN ANTONIO TEX ELEC & GAS REV REF-SER B (TX)* 4% 2/1/2017 <colgroup><col></colgroup><tbody> </tbody> <colgroup><col width="773"></colgroup><tbody> </tbody>	NA <colgroup><col width="125"></colgroup><tbody> </tbody>	4% <colgroup><col width="125"></colgroup><tbody> </tbody>	2/1/2017 <colgroup><col width="87"></colgroup><tbody> </tbody>
CITY OF COPPELL, TEXAS GENERAL OBLIGATION REFUNDING AND IMPROVEMENT BONDS, SERIES 2011 (TX) 3.00% 3/1/2017 <colgroup><col></colgroup><tbody> </tbody>	NA <colgroup><col width="125"></colgroup><tbody> </tbody>	3% <colgroup><col width="125"></colgroup><tbody> </tbody>	3/1/2017 <colgroup><col width="87"></colgroup><tbody> </tbody>
OMAHA PUB PWR DIST NEB ELEC REV PREREFUNDED-SER B CALLABLE 03/01/16 @100 5.00% 2/1/2017 <colgroup><col width="773"></colgroup><tbody> </tbody>	CALLABLE 03/01/16 <colgroup><col width="125"></colgroup><tbody> </tbody>	5% <colgroup><col width="125"></colgroup><tbody> </tbody>	2/1/2017 <colgroup><col width="87"></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[Warship]

-assuming Data starts in A2

data 1 formula:
=IF(ISERR(SEARCH("CALLABLE",A2)),"NA",MID(A2,SEARCH("CALLABLE",A2),SEARCH("@",A2)-SEARCH("CALLABLE",A2)-1))

data 2 formula:
=VALUE(LEFT(MID(A2,FIND("|",SUBSTITUTE(A2," ","|",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))-1))+1,255),SEARCH(" ",MID(A2,FIND("|",SUBSTITUTE(A2," ","|",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))-1))+1,255))))

data 3 formula:
=DATEVALUE(TRIM(RIGHT(SUBSTITUTE(TRIM(A2), " ", REPT(" ", LEN(TRIM(A2)))), LEN(TRIM(A2)))))