Home » » FUNGSI REPLACE

FUNGSI REPLACE

Pak Guru | 12:32 PM | 0 komentar


FUNGSI  REPLACE UNTUK   MENGGANTI KARAKTER TERTENTU PADA TEKS, MULAI DARI POSISI TERTENTU.

DATA
HASIL
PENULISAN FUNGSI
Joko Susilo
0oko Susilo
=REPLACE(C6,1,1,"O")
Aku Aminah
Uu Aminah
=REPLACE(C7,1,2,"O")
                                                 
BENTUK PENULISAN FUNGSI :                                                                               
                =REPLACE(X,Y1,Y2,Z)

Share this article :

0 komentar:

Post a Comment

 
Support : Creating Website | Johny Template | Mas Template
Copyright © 2011. Belajar Membuat Excel - All Rights Reserved
Template Modify by Creating Website | More Trick | IVY Themes
Proudly powered by Blogger