Mengganti Karakter Tertentu dalam Microsoft Excel

20 04 2012

Kita dapat mengganti karakter tertentu yang terdapat dalam cell Microsoft Excel, contoh dalam suatu cell terdapat data : 01-064-120-9, kemudia data tersebut akan kita ganti karakter “-” menjadi karakter “/”. Kita dapat mengubahnya menggunakan fungsi SUBSTITUTE Microsoft Excel. Rumus umum Fungsi SUBSTITUTE adalah :

Baca selengkapnya >>

About these ads



2 responses

16 06 2013
core training

I have been surfing online more than three hours today, yet I never found any interesting article like yours.
It is pretty worth enough for me.
Personally, if all webmasters and bloggers made good
content as you did, the internet will be
a lot more useful than ever before.

10 04 2013
insurance company ratings

Hi I am so thrilled I found your web site, I really found you by accident, while I
was searching on Yahoo for something else, Nonetheless I am here now and would just like to say many thanks for a fantastic post and
a all round interesting blog (I also love the
theme/design), I don’t have time to browse it all at the moment but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the great work.

Berikan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in: Logo

You are commenting using your account. Logout / Ubah )

Twitter picture

You are commenting using your Twitter account. Logout / Ubah )

Facebook photo

You are commenting using your Facebook account. Logout / Ubah )

Google+ photo

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s


Get every new post delivered to your Inbox.

Bergabunglah dengan 197 pengikut lainnya.

%d blogger menyukai ini: