oop salah !! harusnya =REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B4,10,1, MID(B4,10,1)&":"),8,1,MID(B4,8,1)&":"),6,1,MID(B4,6,1)&":"),4,1, MID(B4,4,1)&":"),2,1,MID(B4,2,1)&":")
dan =REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B4,10,1, MID(B4,10,1)&"-"),8,1,MID(B4,8,1)&"-"),6,1,MID(B4,6,1)&"-"),4,1, MID(B4,4,1)&"-"),2,1,MID(B4,2,1)&"-") atau jika ingin versi AGAK pendek nya (dan lebih mudah difahami) =MID(B4,1,2)&":"&MID(B4,3,2)&":"&MID(B4,5,2)&":"&MID(B4,7,2)&":"&MID(B4,9,2)&":"&MID(B4,10,2) dan =MID(B4,1,2)&"-"&MID(B4,3,2)&"-"&MID(B4,5,2)&"-"&MID(B4,7,2)&"-"&MID(B4,9,2)&"-"&MID(B4,10,2) 2011/10/27 Haps <[email protected]> > > =REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B4,10,1, > MID(B4,2,1)&":"),8,1,MID(B4,8,1)&":"),6,1,MID(B4,6,1)&":"),4,1, > MID(B4,4,1)&":"),2,1,MID(B4,2,1)&":") > dan > =REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B4,10,1, > MID(B4,2,1)&"-"),8,1,MID(B4,8,1)&"-"),6,1,MID(B4,6,1)&"-"),4,1, > MID(B4,4,1)&"-"),2,1,MID(B4,2,1)&"-") > >
(haps) tanda hubung tiap dua karakter .xls
Description: MS-Excel spreadsheet
