Excel: Extract Data to Date Format


hi all.. i need excel formula how to extract data this below "

sample raw after formula (date format)...dd/mm/yy
7143/R/DJSDPPI.3/KOMINFO/11/2012 Tgl.19 Nopember 2012 19/11/2012
100/R/DJSDPPI.3/KOMINFO/11/2012 Tgl.10 Januari 2012 10/01/2012
45/R/DJSDPPI.3/KOMINFO/11/2012 Tgl.26 Maret 2012 26/03/2012
note : red font just clue.. not using vba any assistance, thanks in advance.. m.susanto


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of October 31, 2014.


For more resources for Microsoft Excel