Coba formula ini di cell B2
=MID(LEFT(A2;FIND("_";A2)-1);1;100)
Wslm,
From: alam syah [email protected] [belajar-excel]
[mailto:[email protected]]
Sent: 19 Desember 2014 01:43
To: [email protected]
Subject: [belajar-excel] tampilan tanpa 4 karakter belakang [1 Attachment]
assalamualaikum para master
mohon bantuannya untuk tampilan tanpa 4 karakter dibelakang. (pemula nih)
terlampir. makasih banyak.
Wassalam
syah
_____
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.
