Terima kasih Mr. DD formulanya berhasil, tapi apakah ada formula lain tanpa harus me-Replace (=) ?
On 30/06/2015 15:21, Dede [email protected] [belajar-excel] wrote: > > Dear Mr Maman, > > Sambil menunggu dari Master-master yang lain, coba masukan rumus di > cell B3 : > > =MID(A3;FIND("/";A3)+1;9) > > Kemudian lakukan langkah seperti ini : > > 1.Blok kolom A > > 2.Tekan Ctrl +F > > 3.Pilih Replace > > a.Find What diisi = > > b.Replace with diisi # > > c.Replace All > > d.Close > > Selesai. > > Salam, > > DD > > *From:*Maman [email protected] [belajar-excel] > [mailto:[email protected]] > *Sent:* 30 Juni 2015 13:35 > *To:* [email protected] > *Subject:* [belajar-excel] Mencari Nilai Pembagi [1 Attachment] > > Assalaamu'alaikum Wr. Wb. > > Dear Master Excel, mohon sharing ilmunya untuk mencari Nilai Pembagi > dari file terlampir. > > Terima Kasih > > ------------------------------------------------------------------------ > > 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. > >
