3 New Messages
Digest #2433
| 1a Re: Keanehan Excel by "Kid Mr." nmkid.family@ymail.com 1b Re: Keanehan Excel by "Fajri" s_fajri 1c Re: Keanehan Excel by "NANG Agus" |
Fri Jun 29, 2012 11:09 am (PDT) . Posted by: "Kid Mr." nmkid.family@ymail.com
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 <has.bullah@sanmina-sci.com >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.
>
>
>
>
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 <has.bullah@sanmina-
> **
>
>
> 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)
>
>
>
>
Fri Jun 29, 2012 11:20 am (PDT) . Posted by: "Fajri" s_fajri
Perbedaannya terletak di spasi antara "HEATSINK," dengan "ESB".
Spasi di cell C5 bukan spasi biasa. Tetapi spasi yang bukan untuk pemisah
kata. Kemungkinan spasi tersebut bukan dgn mengetik space bar di keyboard,
tetapi copy dari bahasa program yang berbeda, atau insert simbol.
Regards,
SF
On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-sci.com >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.
>
>
>
>
Spasi di cell C5 bukan spasi biasa. Tetapi spasi yang bukan untuk pemisah
kata. Kemungkinan spasi tersebut bukan dgn mengetik space bar di keyboard,
tetapi copy dari bahasa program yang berbeda, atau insert simbol.
Regards,
SF
On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-
> **
>
>
> 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)
>
>
>
>
Fri Jun 29, 2012 11:25 am (PDT) . Posted by: "NANG Agus"
Dear Hasbullah,
File yang anda kirimkan bukan hal yang aneh. perbedaan terdapat pada
karakter ke 11, (dilihat mata manusia karakter tersebut sama yaitu spasi
kosong, namun Excel tahu bahwa kedua karakter tersebut adalah berbeda) yang
satu karakter no 32 yang lainnya karakter no 160.
coba jika kedua karakter tersebut disamakan (sama-sama 32 atau sama-sama
60) maka jawabnya akan sama.
Lihat attachment
salam
NangAgus
On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-sci.com >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
>
> Reply to sender<has.bullah@sanmina-sci.com ?subject=Re%3A%20Keanehan%20Excel>| Reply
> to group <XL-mania@yahoogroups.com ?subject=Re%3A%20Keanehan%20Excel> | Reply
> via web post<http://groups.yahoo.com/group/XL-mania/post;_ylc=X3oDMTJyMjJobnF0BF9TAzk3MzU5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMyMDczNwRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzNDA5NjAxMTA-?act=reply&messageNum=20737 >| Start
> a New Topic<http://groups.yahoo.com/group/XL-mania/post;_ylc=X3oDMTJmb3E4MHUzBF9TAzk3MzU5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzEzNDA5NjAxMTA- >
> Messages in this topic<http://groups.yahoo.com/group/XL-mania/message/20737;_ylc=X3oDMTM3bWduYXNsBF9TAzk3MzU5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMyMDczNwRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzNDA5NjAxMTAEdHBjSWQDMjA3Mzc- >(
> 1)
> Recent Activity:
>
> - New Members<http://groups.yahoo.com/group/XL-mania/members;_ylc=X3oDMTJnN21vcW0wBF9TAzk3MzU5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxMzQwOTYwMTEw?o=6 >
> 45
>
> Visit Your Group<http://groups.yahoo.com/group/XL-mania;_ylc=X3oDMTJmdG1kaWVmBF9TAzk3MzU5NzE0BGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEzNDA5NjAxMTA- >
> +-:: XL-mania ::::::::::::::::::::----------------------------------+
> | Woooowwww... member XL-mania tembus 20,000!!! |
> +----------------------------------------------------------+
> | DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
> | pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
> +----------------------------------------------------------+
> | Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
> | Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
> +----------------------------------------------------------+
> | Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
> | XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
> | http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
> +----------------------------------------------------------+
> | Berikan testimoni di : |
> | http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
> +----------------------------------------------------------+
> | Message lama ada di : |
> | http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
> | http://www.mail-archive.com/xl-mania@yahoogroups.com |
> +----------------------------------------------------------+
> [image: Yahoo! Groups]<http://groups.yahoo.com/;_ylc=X3oDMTJlZ2EzZ2s1BF9TAzk3NDc2NTkwBGdycElkAzE1MTk3MTk2BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTM0MDk2MDExMQ-- >
> Switch to: Text-Only<XL-mania-traditional@yahoogroups.com ?subject=Change+Delivery+Format:+Traditional>,
> Daily Digest<XL-mania-digest@yahoogroups.com ?subject=Email+Delivery:+Digest>•
> Unsubscribe <XL-mania-unsubscribe@yahoogroups.com ?subject=Unsubscribe> • Terms
> of Use <http://docs.yahoo.com/info/terms/ >
> .
>
>
>
File yang anda kirimkan bukan hal yang aneh. perbedaan terdapat pada
karakter ke 11, (dilihat mata manusia karakter tersebut sama yaitu spasi
kosong, namun Excel tahu bahwa kedua karakter tersebut adalah berbeda) yang
satu karakter no 32 yang lainnya karakter no 160.
coba jika kedua karakter tersebut disamakan (sama-sama 32 atau sama-sama
60) maka jawabnya akan sama.
Lihat attachment
salam
NangAgus
On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-
> **
>
>
> 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
>
> Reply to sender<has.bullah@sanmina-
> to group <XL-mania@yahoogroup
> via web post<http://groups.
> a New Topic<http://groups.
> Messages in this topic<http://groups.
> 1)
> Recent Activity:
>
> - New Members<http://groups.
> 45
>
> Visit Your Group<http://groups.
> +-:: XL-mania ::::::::::::
> | Woooowwww... member XL-mania tembus 20,000!!! |
> +-----------
> | DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
> | pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
> +-----------
> | Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
> | Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
> +-----------
> | Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
> | XL-mania-subscribe@
> | http://groups.
> +-----------
> | Berikan testimoni di : |
> | http://www.xl-
> +-----------
> | Message lama ada di : |
> | http://groups.
> | http://www.mail-
> +-----------
> [image: Yahoo! Groups]<http://groups.
> Switch to: Text-Only<XL-mania-traditiona
> Daily Digest<XL-mania-digest@
> Unsubscribe <XL-mania-unsubscrib
> of Use <http://docs.
> .
>
>
>
GROUP FOOTER MESSAGE
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Woooowwww... member XL-mania tembus 20,000!!! |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
| Woooowwww... member XL-mania tembus 20,000!!! |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Tidak ada komentar:
Posting Komentar