Bagaimana kalau formula kolom susunan asli yang diubah menjadi : [baris 2
Excel]
*(asumsi data di kolom A sampai D -> jadi susunan asli sepertinya di kolom
E kalau ndak ada merge cell)
*=*Mid(* *Rept(", "&a2,a2<>"")* & *Rept(", "&b2,b2<>"") *& *Rept(",
"&c2,c2<>"")* & *Rept(", "&d2,d2<>"") , 3 , 99 )*atau menggunakan IF : =*Mid(* *IF( Len(a2) , ", "&a2, "" )* & *IF( Len(b2) , ", "&b2 , "" )* & *IF( Len(c2) , ", "&c2 , "" )* & *IF( Len(d2) , ", "&d2 , "" )* *, 3 , 99 )* Jika tetap akan memanfaatkan formula susunan asli yang sudah ada, kemudian menghilangkan delimiter berlebihnya : [baris 2 Excel] *(asumsi susunan asli di kolom E)* =*Substitute(* *Mid(* *Substitute(* *Substitute( ", " & e2 & ", ," , ", , " , ", " )* *, ", , " , ", " )** , 3 , 99 )* *, ", ," , "" )* Wassalam, Kid. 2012/6/20 Ratno Hadi Suswanto <[email protected]> > ** > > > Dear Be-exceler, > > Ada yang minta bantuan berikut ke saya, minta tolong di bantu temen2 > be-exceler karena saya sedang ada "workshop" yang sangat tight waktunya. > > Salam, > Ratno > > > From: Ratno.SUSWANTO > > To: [email protected] > > Date: Wed, 20 Jun 2012 12:45:52 +0200 > > Subject: FW: Menghilangkan Karakter tidak berguna > > > > > > > > -----Original Message----- > > From: Randy Hattianto > > Sent: 19 June 2012 16:18 > > To: Ratno SUSWANTO > > Subject: Menghilangkan Karakter tidak berguna > > > > Dear Mas Ratno, > > > > Tolong dibantu, saya berkeinginan menghilangkan karekater (,) yang tidak > berguna dari hasil penggabungan kata sebagaimana terlampir. > > Bagaima formula praktisnya. > > > > Thx a lot Mas, sampai ketemu di Jakarta > > Randy Hr > > > > ********************************************************************** > > DISCLAIMER > > This email and any files transmitted with it, including replies and > forwarded copies (which may contain alterations) subsequently transmitted > from Firmenich, are confidential and solely for the use of the intended > recipient. The contents do not represent the opinion of Firmenich except to > the extent that it relates to their official business. > > ********************************************************************** > > > > >
