Dear Pak Erwin Marfana, Berikut saya coba bantu dgn fungsi mid & right sbb : cell C2 : =MID(B2,3,10) cell D2 : =RIGHT(B2,(LEN(B2)-14)) *selanjutnya copy kebawah sesuai jumlah row yg berisi data cost element
Semoga bermanfaat & sesuai harapan.. Best regards, Primas Adexa ________________________________ From: Erwin Marfana <[email protected]> To: [email protected] Sent: Saturday, January 4, 2014 6:40 AM Subject: ]] XL-mania [[ Angka vs kalimat [1 Attachment] Dh,, Temen2 XL-Mania mohon infonya mengenai kasus saya terlampir Salam
Solusi - Angka vs Kalimat.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
