Coba pake formula ini
=A2&" | "&B2 From: odong nando [email protected] [belajar-excel] [mailto:[email protected]] Sent: 13 Nopember 2014 12:07 To: [email protected] Subject: [belajar-excel] custom format cell dengan refrensi value cell lain [1 Attachment] dear alll, saya punya kendala untuk membuat, format cell column gabung berformat value cell dari gabungan column kode_barang dan nama_barang dengan menggunakan pipe sebagai pembatas, seperti contoh pada column gabung, terlampir contoh masalah. Saya dapat melakukannya secara manual, namun akan memakan waktu yang sangat lama apabila yang harus di ketik ribuan baris. bagaimanakah caranya agar dapat di permudah. mohon arahan dari rekan2 sekalian thx, odong _____ 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.
