Aku coba bikinin pake rumus sebisaku.. kali aja bener....

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yanti
Sent: Friday, May 19, 2006 1:50 PM
To: xl-mania
Subject: ]] XL-mania [[ menghilangkan character/symbol

 

Dear para master XL-mania 

 

Saya mau menanyakan  bagaimana rumusnya untuk

menghilangkan character/symbol pada bagian kanan kata.

sesuai dengan contoh list data terlampir.

 

Di tunggu jawabannya

 

Thanks

 

yanti

         

 



+-:: XL-mania ::::::::::::::::::::----------------------------------+
|                                                                   |
| 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  |
| [EMAIL PROTECTED] atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni Anda tentang XL-mania di :                      |
| http://www.friendster.com/profiles/xlmania                        |
+-------------------------------------------------------------------+



SPONSORED LINKS
Microsoft excel Microsoft business solution Microsoft excel help
Microsoft small business manager Microsoft excel training


YAHOO! GROUPS LINKS




Attachment: character-symbol.xls
Description: MS-Excel spreadsheet

Kirim email ke