Mengganti Karakter Tertentu dalam Microsoft Excel
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 :
(Visited 116 times, 1 visits today)
4 thoughts on “Mengganti Karakter Tertentu dalam Microsoft Excel”
Comments are closed.
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.
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.
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.
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.