SUBSTITUTE kev ua haujlwm siv tau los hloov cov lus uas twb muaj lawm, ntawv nyeem, los yog cov cim nrog cov ntaub ntawv tshiab.
Lus Cim: Qhov kev tshwm sim ntawm txoj haujlwm yuav tsum tshwm sim nyob rau lwm qhov chaw tshaj li cov ntawv nyeem.
Siv rau kev ua haujlwm xws li:
- Tshem tawm cov cim tsis yog luam tawm ntawm cov ntaub ntawv tawm los;
- Hloov cov cim tsis txaus siab nrog cov chaw;
- Ua ntau hom versions ntawm tib daim ntawv .
01 ntawm 04
Hloov cov ntawv qub rau Cov Tshiab
Lub Hloov Haujlwm Cov Lus Teb thiab Cov Kev Sib Tham
Ib qho kev ua haujlwm syntax hais txog qhov teeb tsa ntawm txoj haujlwm thiab suav nrog txoj haujlwm, lub npe, thiab sib cam .
Lub syntax rau lub luag haujlwm SUBSTITUTE yog:
= SUBSTITUTE (Ntawv nyeem, Old_text, New_text, Instance_num)
Cov lus sib tham txog kev ua haujlwm yog:
Cov ntawv nyeem - (yuav tsum tau) cov ntaub ntawv uas muaj cov ntawv nyeem los hloov. Qhov kev sib cav no muaj peev xwm muaj
- cov ntaub ntawv tiag tiag ntawm cov lus sau hais tias - ob qho tib si hauv daim duab saum toj no;
- lub xov tooj xa mus rau qhov chaw nyob ntawm cov ntawv sau hauv cov ntawv ua haujlwm - thib peb saum toj no;
Old_text - (yuav tsum tau) cov ntawv luam yuav raug hloov.
New_text - (yuav tsum tau) cov ntawv nyeem uas yuav hloov tau Old_text .
Instance_num - (optional) tus nab npawb
- Yog hais tias rho, txhua yam ntawm Old_text hloov nrog New_text .
- Yog tias muaj, tsuas yog qhov piv txwv ntawm Old_text uas tau teev tseg - xws li thawj zaug lossis zaum peb - hloov - tsib zaug thiab rau saum toj.
02 ntawm 04
Case Mob Siab
Cov lus sib cav rau SUBSTITUTE muaj nuj nqi yog cov ntaub ntawv rhiab, uas txhais tau tias yog cov ntaub ntawv nkag rau hauv Old_text cav tsis muaj qhov teeb meem tib yam li cov ntaub ntawv hauv phau ntawv sib cav, tsis muaj kev hloov.
Piv txwv, nyob rau hauv kab plaub ntawm daim duab saum toj no, qhov kev ua hauj lwm views muag (cell A4) raws li sib txawv ntawm kev muag khoom (Old_text sib cav ) thiab, yog li ntawd, tsis hloov nyiaj hauv New_text .
03 ntawm 04
Nkag Tsav Hloov Kev Ua Haujlwm
Txawm hais tias nws muaj peev xwm los qhia tag nrho cov mis nyuj xws li
= SUBSTITUTE (A3, "Sales", "Revenue")
manually rau hauv ib daim ntawv ntawm tes, lwm qhov kev xaiv yog siv qhov kev ua haujlwm lub thawv tawm tswv yim - raws li tau teev nyob rau hauv cov kauj ruam hauv qab no - nkag mus rau qhov kev ua haujlwm thiab cov lus sib tham rau hauv ib lub xov tooj ntawm tes xws li B3.
Cov txiaj ntsig ntawm kev siv lub thawv ntawv sib txuas lus yog tias Excel siv kev cais ntawm txhua qhov sib cav nrog ib qho tsis nco qab thiab nws nkag tau cov ntaub ntawv qub thiab cov ntawv qhia tshiab hauv cov lus hais.
- Nias ntawm tes B3 - ua kom nws ua haujlwm ntawm tes
- Nias rau ntawm tus qauv tab ntawm daim ntawv tais cai
- Nias rau ntawm Daim Ntawv Teev Tseg rau ntawm daim ntawv sau kom qhib tau cov ntawv sau cia
- Nias ntawm SUBSTITUTE nyob rau hauv daim ntawv los coj mus rau qhov no muaj nuj nqi lub dialog box
- Hauv lub thawv ntawv, nyem rau ntawm kab ntawv
- Nias ntawm A3 Cell nkag mus rau qhov siv xovtooj ntawm tes rau hauv lub thawv dialog
- Nias ntawm phau ntawv Old_text hauv lub thawv ntawv
- Hom Muag , uas yog cov ntawv peb xav hloov - tsis tas yuav tsum muab cov ntawv hauv cov lus cim tseg;
- Nias ntawm New_text kab hauv lub thawv ntawv
- Hom Nyiaj , raws li cov ntawv nyeem uas yuav tsum tau hloov;
- Qhov sib cav sib cav tseem tshuav dawb paug - vim tias tsuas yog ib qho ntawm lo lus muag hauv xov tooj ntawm tes A3;
- Nias OK los ua kom tiav cov kev ua thiab kaw lub thawv ntawv;
- Cov ntawv xov xwm Cov Nyiaj Tshaj Tawm yuav tsum tshwm sim hauv xov tooj ntawm B3;
- Thaum koj nias ntawm tes B3 ua tiav tiav
= SUBSTITUTE (A3, "Sales", "Revenue")
tshwm nyob rau ntawm qhov formula mis saum toj ntawm daim ntawv ua haujlwm
04 ntawm 04
Hloov thiab hloov
SUBSTITUTE sib txawv ntawm txoj kev hloov hauv qhov kev siv los ua kom siv cov ntaub ntawv ntawm qhov chaw nyob rau hauv cov ntaub ntawv xaiv thaum HOM REPLACE siv los hloov cov ntawv uas tshwm sim nyob rau ntawm ib qho chaw hauv cov ntaub ntawv.