Mbak Siti,
Celengnya sdh ketangkep
Salam,
Hendrik Karnadi
Celengnya sdh ketangkep
Salam,
Hendrik Karnadi
From: siti Vi <setiyowati.devi@
To: XL-mania@yahoogroup
Sent: Friday, November 27, 2009 13:39:34
Subject: ]] XL-mania [[ Konversi Text Angka ke Bilangan terurut menaik.
Dear XL-maniawan / XL-maniawati. ..
Daripada bengong.. ini ada hiburan "CelengPalsu( 1) edisi Akhir Nov 09:
Bagaimana cara mengkonversi data seperti di bawah ini
Data Referensi (INPUT) : Text gabungan banyak angka dlm 1 cell, tanda pemisah "-"
Data Hasil (OUTPUT) : Bilangan dlm cell terpisah terurut menaik.
data | contoh hasil yang diinginkan | ||||||||||||
38-44-23-19- 02-15-91- 01-45-32 | 1 | 2 | 15 | 19 | 23 | 32 | 38 | 44 | 45 | 91 | |||
05-89-43-11- 56-03-25- 81-67-29 | 3 | 5 | 11 | 25 | 29 | 43 | 56 | 67 | 81 | 89 | |||
11-93-42-81- 10-01-97- 36-17-72 | 1 | 10 | 11 | 17 | 36 | 42 | 72 | 81 | 93 | 97 | |||
87-15-22-73- 23-46-09- 03-38-17 | 3 | 9 | 15 | 17 | 22 | 23 | 38 | 46 | 73 | 87 | |||
38-44-23-19- 02-15-91- 01-45-32- 22 | 1 | 2 | 15 | 19 | 22 | 23 | 32 | 38 | 44 | 45 | 91 | ||
05-89-43-11- 56-03-25- 81-67-29- 41-05-34 | 3 | 5 | 5 | 11 | 25 | 29 | 34 | 41 | 43 | 56 | 67 | 81 | |
11-93-42-81- 10-01-97- 36-17 | 1 | 10 | 11 | 17 | 36 | 42 | 81 | 93 | 97 | ||||
87-15-22-73- 23-46-09 | 9 | 15 | 22 | 23 | 46 | 73 | 87 | ||||||
~ctv~
mari kita [belajar-excel]
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Momods lagi hanimuuunnn... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| 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.friendster.com/xlmania atau... |
| 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 |
+-------------------------------------------------------------------+
| Momods lagi hanimuuunnn... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| 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.friendster.com/xlmania atau... |
| 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 |
+-------------------------------------------------------------------+
MARKETPLACE
.
__,_._,___
Nenhum comentário:
Postar um comentário