Re: ]] XL-mania [[ Memisahkan huruf dalam 1 kolom part. 2

 

tidak sulit kok, misal data ada di B3 ke bawah

tulis formula di D3

=LEFT(B3,F3-1)

copy-kan ke cells di bawahnya

lihat workbook terlampir

 

 

	kolom B	kolom C	kolom D
2	Awal	Yg Di inginkan	formula
3	Muhammad Mutaqin / Rahadian Hadi	Muhammad Mutaqin	Muhammad Mutaqin
4	Kudus Firdaus 85624764996	Kudus Firdaus	Kudus Firdaus
5	Asep Purbaya	Asep Purbaya	Asep Purbaya
6	Irfan Hadiyanto 0813-8376-2503	Irfan Hadiyanto	Irfan Hadiyanto
7	Rahadian /M Mutaqin	Rahadian	Rahadian
8	Kudus Firdaus 85624764996	Kudus Firdaus	Kudus Firdaus
9	Freddinandus / Riko	Freddinandus	Freddinandus
10	Syamsudin 25945127	Dst……	Syamsudin
11	M Khadafi		M Khadafi
12	Arie Hardyanto		Arie Hardyanto
13	Cipto 85210980481		Cipto
14	Bambang Triaji		Bambang Triaji
15	Sukardi		Sukardi
16	Irfan Hadiyanto 0813 83762503		Irfan Hadiyanto
17	iwan hanafi		iwan hanafi
18	Asep Purbaya		Asep Purbaya
19	Muhammad Mutaqin / Rahadian Hadi		Muhammad Mutaqin
20	Cahyadi Heru Nugroho 0813 5942 4305		Cahyadi Heru Nugroho

 

 

 

---

----- Original Message -----
From: Dewanto Agung Budiman
To: XL-mania@yahoogroups.com
Sent: Tuesday, February 23, 2010 1:40 PM
Subject: ]] XL-mania [[ Memisahkan huruf dalam 1 kolom part. 2

Dear Para master
Mohon di bantu saya lagi yg masih junior ini.
Terima kasih yg sebanyak banyaknya…
 

 

__._,_.___

Reply to sender | Reply to group

Messages in this topic (2)

Recent Activity:

• New Members 97

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| huaaaa... momods sakit... *sob*                                   | 
| 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              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___