A RUMUS EXCEL
RUMUS EXCEL
TEMPAT
=LEFT(A1;FIND(",";A1)-1)
=LEFT(E6;FIND(",";E6)-1)
TANGGAL
=MID(A1;FIND(",";A1)+2;LEN(A1))
=RIGHT(A1;LEN(A1)-FIND(",";A1)-1)
=RIGHT(E6;LEN(E6)-FIND(",";E6)-1)
=LEFT(A1;FIND(",";A1)-1)
=LEFT(E6;FIND(",";E6)-1)
TANGGAL
=MID(A1;FIND(",";A1)+2;LEN(A1))
=RIGHT(A1;LEN(A1)-FIND(",";A1)-1)
=RIGHT(E6;LEN(E6)-FIND(",";E6)-1)
diposting oleh fikron @ 14.58
0 Komentar
0 Komentar:
Posting Komentar
Berlangganan Posting Komentar [Atom]
<< Beranda