coba juga, =REPLACE(REPLACE(B2,MATCH(1,INDEX(-MID(B2,ROW($1:$8),1),))+1,,"-"),3-(MI\ D(B2,2,1)<"A"),,"-") KT2153AV hasilnya: KT-2153-AVKT2879R hasilnya: KT-2879-RB2332JP hasilnya: B-2332-JP
>semoga bermanfaat --- In [email protected], "Kid Mr." <mr.nmkid@...> wrote: > > C2 : > =REPLACE(REPLACE(B2,LOOKUP(2,1/(MID(B2&REPT("x",10),ROW($1:$10),1)<"A"),\ ROW($2:$11)),0,"-"),3-(MID(B2,2,1)<"A"),0,"-") > > Kid > > 2012/10/9 hendra Sembiring hcpt@... > > > ** > > > > > > DEar Para Suhu, > > Mohon saya di bantu untuk membuat jarak di no polisi, > > terlampir di attacment. > > Terima kasih > > > > > > > > >
