Coba juga, tanpa formula array
=SUBSTITUTE(A3,-LOOKUP(1,-MID(A3,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A3&"0123456789")),{1;2;3;4})),
"-"&-LOOKUP(1,-MID(A3,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A3&"0123456789")),{1;2;3;4}))&"-")From: [email protected] [mailto:[email protected]] On Behalf Of ghozi alkatiri Sent: Sunday, November 11, 2012 9:16 PM To: [email protected] Subject: Bls: [belajar-excel] Plat Kendaraan misalkan data ada di A3 maka formula (formula array di enter dengan menahan tobol Ctrl +Shift) {=SUBSTITUTE($A3;MID($A3;MIN(IF(ISNUMBER(--MID($A3;ROW($1:$10);1));ROW($1:$10)));COUNT(IF(ISNUMBER(--MID($A3;ROW($1:$10);1));ROW($1:$10))));"-"&MID($A3;MIN(IF(ISNUMBER(--MID($A3;ROW($1:$10);1));ROW($1:$10)));COUNT(IF(ISNUMBER(--MID($A3;ROW($1:$10);1));ROW($1:$10))))&"-")} penjelasan langkah ada di attachment wassalam Ghozi Alkatiri ________________________________________ Dari: Andrie - <[email protected]> Kepada: [email protected] Dikirim: Minggu, 11 November 2012 17:05 Judul: [belajar-excel] Plat Kendaraan Dear all, bagaimana sih caranya membuat format cell plat kenderaan ex : B1234AC = B-1234-AC BA1234AC = BA-1234-AC tq
Plat kendarann.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
