Hai Haris,
Coba formula ini :
MID(LEFT(A2;FIND("2015";A2)+3);FIND(",";A2)+1;50)
Salam,
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.
