Re: ]] XL-mania [[ Pemisahan data exsport

 

Coba dengan menggunakan fasilitas Text to colums,

1. Higlight column A atau colomn data yang ingin diubah.
2. Pilih Menu "Text to Columns", (Data - Text to Columns or Alt D+E).
3. Pilih Delimited,
4. Pilih Semicolon,
5. Tekan Finish.
6. Jangan lupa di-save dalam format xls jika menginginkan hasil dalam bentuk MIcrosoft XL type.

Sekian
OC

"acep" <acep@bks.sulindafin.com> Sent by: XL-mania@yahoogroups.com 08/18/2009 08:29 AM Please respond to XL-mania@yahoogroups.com

To <XL-mania@yahoogroups.com> cc Subject ]] XL-mania [[ Pemisahan data exsport

 

Dear all,

 

Mohon bantuannya bagaimana cara pemisahan data yang tergabung dalam 1 kolom (digabungkan oleh semicolon tanpa space) agar data bisa saya analisa dengan jelas.

Data saya exsport dari operasional gas engine (genset 60 hz 2,6 MW) yang di connect dari sensor operasional pada engine ke server.

 

Thanks & Regards,

Handoko

 

Staff Engineering

Diesel & Gas Engine Power Plant Dept.

PT.Sulindafin Bekasi.

0812.1886.3544[attachment "TrendData Test Full Load 080709.csv" deleted by CAD/PT.ORIX Indonesia Finance] [attachment "Messages Test Full Load III.csv" deleted by CAD/PT.ORIX Indonesia Finance]

__._,_.___

Messages in this topic (2) Reply (via web post) | Start a new topic

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| I love you full XL-maniawan & XL-maniawati :D :D :D               |
| 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              |
+-------------------------------------------------------------------+

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Recent Activity

•  61
  New Members
•  2
  New Files

Visit Your Group

Give Back

Yahoo! for Good

Get inspired

by a good cause.

Y! Toolbar

Get it Free!

easy 1-click access

to your groups.

Yahoo! Groups

Start a group

in 3 easy steps.

Connect with others.

.

__,_._,___