Hal tersebut disebabkan karena adanya karakter spasi berkode 160. Coba cek dengan : =Code( Mid( teksnya , karakter ke , 1 ) ) Ganti teksnya dengan rujukan cell si data, Ganti karakter ke dengan angka posisi karakter yang tampak sebagai spasi.
Wassalam, Kid. On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <[email protected]>wrote: > ** > > > Hallo pakar excel > > saya menemukan kejanggalan untuk cell value seperti yang ada di lampiran. > untuk 2 cell value yang sama tapi ternyata dianggap berbeda (setelah > ditelusuri dengan formula) > mohon dibantu apa yang meyebabkan perbedaan tersebut > terima kasih atas bantuannya > > > Hasbullah > > CONFIDENTIALITY > This e-mail message and any attachments thereto, is intended only for use by > the addressee(s) named herein and may contain legally privileged and/or > confidential information. If you are not the intended recipient of this > e-mail message, you are hereby notified that any dissemination, distribution > or copying of this e-mail message, and any attachments thereto, is strictly > prohibited. If you have received this e-mail message in error, please > immediately notify the sender and permanently delete the original and any > copies of this email and any prints thereof. > ABSENT AN EXPRESS STATEMENT TO THE CONTRARY HEREINABOVE, THIS E-MAIL IS NOT > INTENDED AS A SUBSTITUTE FOR A WRITING. Notwithstanding the Uniform > Electronic Transactions Act or the applicability of any other law of similar > substance and effect, absent an express statement to the contrary > hereinabove, this e-mail message its contents, and any attachments hereto are > not intended to represent an offer or acceptance to enter into a contract and > are not otherwise intended to bind the sender, Sanmina-SCI Corporation (or > any of its subsidiaries), or any other person or entity. > > > >
