Dear Mr ASL,
Sudah coba formula ini :
=MID(“biaya produksi - proyek a”;FIND("-";“biaya produksi - proyek a”)+2;100)
Salam,
DD
From: Ahmad Syaifullah Lubis [email protected] [belajar-excel]
[mailto:[email protected]]
Sent: 04 Maret 2015 15:14
To: [email protected]
Subject: [belajar-excel] fungsi menghilangkan sebagian setelah tanda "-"
Dear BeExceller,
Fungsi Excel yang bisa menghapus kata/kalimat setelah tanda "-" atau "/" apa ya?
Sudah lama saya pernah sih melakukannya, tetapi sudah lupa. saya kotak - katik
gak dapet-dapet.
seperti contoh ini :
biaya produksi - proyek a
biaya manager - mr b
biaya transport - jakarta
dengan mengklik fungsi yang ada pada menu excel dan diindikasikan tanda "-",
maka hasilnya akan menjadi :
proyek a
mr b
jakarta
mohon dibantu.
terima kasih,
ASL
_____
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.
