Hot Fox

domingo, 23 de junho de 2013

Bls: ]] XL-mania [[ Mengubah 1 spasi menjadi 3 spasi

pakai saja rumus terlampir

Dari: pd_03 <pd_03@sami.co.id>
Kepada: XL-mania@yahoogroups.com
Dikirim: Senin, 10 Juni 2013 10:33
Judul: ]] XL-mania [[ Mengubah 1 spasi menjadi 3 spasi

Hello Pakar EXCEL,

Minta tolong dong, gimana caranya mengubah spasi dari 1 spasi menjadi 3 spasi menggunakan rumus EXCEL (data terlampir).

Terima kasih atas bantuannya.

Bowo

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 41

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| 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              |
+-------------------------------------------------------------------+

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

__,_._,___

sexta-feira, 21 de junho de 2013

]] XL-mania [[ [ask] excel error

Pagi,

Mohon bantuannya,

Tiap saya buka excel selalu muncul :

Dan,

Recent file di taskbar tidak muncul.

Ada solusikah?

Best Regards & Thank You

Marthien

" Do all the goods you can, All the best you can, In all times you can, In all places you can, For all the creatures you can..."

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

New Members 39

Visit Your Group

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

__,_._,___

quinta-feira, 20 de junho de 2013

RE: ]] XL-mania [[ Input huruf kecil, hasil HURUF BESAR

P’Helmi,

Bapak bisa menggunakan perintah “ucase”, contohnya;

Private Sub tbRemark_AfterUpdate()

Range("Nama").Value = UCase(Range("Nama").Value)

End Sub

Thanks in advance,

Nico

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Helmi
Sent: Thursday, June 20, 2013 11:18 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Input huruf kecil, hasil HURUF BESAR

To XL-Mania
bagaimana cara atau rumus jika kita input nama pegawai dengan huruf kecil (tanpa Caps Lock), ttp tersimpan menjadi hurup besar semua, contoh :
Input : hasanuddin
Tersimpan : HASANNUDIN.
Inputnya melalui macro office 2003.
Makasih sebelumnya

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Recent Activity: