Bisa juga dengan ini :
MID(A2;FIND(",";A2)+1;50) DD From: ris ha har1sn.ex...@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 02 Maret 2015 09:02 To: BeExcel Subject: [belajar-excel] Formula Menghilangkan Nama Kota [1 Attachment] Assalamu'alaikum Selamat pagi semua. Mohon bantuannya. saya punya kasus (terlampir). Bagaimana formulanya untuk menghilangkan nama kota, sehingga yang tertinggal hanya tanggalnya saja seperti pada kolom hasil? Data Hasil Surabaya, 02 Januari 2015 02 Januari 2015 Jakarta, 02 Desember 2015 02 Desember 2015 Gresik, 02 Mei 2015 02 Mei 2015 Cilacap, 02 Maret 2015 02 Maret 2015 Cepu, 02 Agustus 2015 02 Agustus 2015 Salam Haris _____ 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.