Dear Mr. Kid,
Makasih atas responnya. Salam, DD From: 'Mr. Kid' [email protected] [belajar-excel] [mailto:[email protected]] Sent: 19 Maret 2015 17:51 To: BeExcel Subject: Re: [belajar-excel] Substitue ? hmmm... mungkin gini : =Substitute( Trim( Substitute( Substitute( datanya , "0" , " " ) , ";" , " " ) ) , " " , ";" ) *** jika regional setting komputer setempat adalah Indonesian, ganti karakter koma menjadi titik koma. *** pastikan menggunakan spasi yang diketik langsung di formula bar (bukan copas formula di atas) agar spasi yang terbentuk lebih pasti adalah spasi dengan ASCII 32 yang bisa dikenai fungsi TRIM Wassalam, Kid On Thu, Mar 19, 2015 at 7:43 PM, Dede [email protected] [belajar-excel] <[email protected]> wrote: Dear BeExceller, Ada yang punya solusi untuk masalah ini: Email Hasil yang diharapkan <mailto:[email protected];0;[email protected];> 0;[email protected];0;[email protected];0 <mailto:[email protected];0;[email protected];> [email protected];[email protected] <mailto:[email protected];0;[email protected]> 0;[email protected];0;[email protected] <mailto:[email protected];0;[email protected]> [email protected];[email protected] <mailto:[email protected];0;[email protected]> 0;[email protected];[email protected] <mailto:[email protected];0;[email protected]> [email protected];[email protected] <mailto:[email protected];[email protected];0> [email protected];[email protected];0 <mailto:[email protected];[email protected];0> [email protected];[email protected] Saya ingin menghilangkan “0;” dan “;0” pada kolom Email, apa rumusnya yah....? Salam, DD _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
