Umsebenzi we-Excel SUBSTITUTE

Umsebenzi we-SUBSTITUTE ungasetyenziselwa ukufaka endaweni yamagama akhoyo, itekisi, okanye abalinganiswa abaneenkcukacha ezintsha.

Qaphela: Iziphumo zomsebenzi kufuneka zivele kwindawo eyahlukileyo kunombhalo wokuqala.

Ukusetyenziswa komsebenzi kubandakanya:

• Ukususa abalinganiswa bokungabonakali kwiedatha ezingenisiwe;
• Ukutshintshela abalinganiswa abangafuneki ngeendawo;
• Ukuvelisa iinguqu ezahlukeneyo zephepha elifanayo.

01 ngo 04

Ukuhambisa i-Old Text kwi-New

I-Syntax yeSigqeba somSebenzi kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-SUBSTITUTE yile:

= SUBSTITUTE (Umbhalo, Old_text, New_text, Instance_num)

Iingxoxo zomsebenzi zi:

Umbhalo - (efunekayo) idatha equkethe isicatshulwa esiya kutshintshwa. Le ngxabano ingaba nayo

• idatha echanekileyo edibeneyo kumanqaku-quotation - umqolo wesibini kumfanekiso ongentla;
• ireferensi yeseli kwendawo yedata yombhalo kwiphepha lokusebenzela - umqolo wesithathu ngentla;

Old_text - (efunekayo) isicatshulwa sokutshintshwa .

I -_iyomxholo- (efunekayo) itekisi eya kutshintsha i- Old_text .

I-Instant_num - (ukhetho) inombolo

• Ukuba uyashiywe, yonke imeko ye- Old_text ithathelwe indawo ngeNew_text .
• Ukuba kubandakanywa, kuphela umzekelo we- Old_text ochaziweyo - njengamaxesha okuqala okanye wesithathu - athatyathwa - yimigangatho emihlanu neyesithandathu.

02 we 04

Ubume bobuzwe

Iingxoxo zomsebenzi we-SUBSTITUTE zinobuchule obuthathaka, oko kuthetha ukuba idatha ingenwe kwiArgu_text ingxabano ayinayo imeko efana nedatha kwi- Text argument cell, akukho ndawo ithatha indawo.

Ngokomzekelo, kumqolo wesine umfanekiso ongentla, umsebenzi wokujonga Ukuthengisa (iseli A4) ehlukileyo ekuthengiseni (i-Old_text argument ) kwaye, ngenxa yoko, ayifaki iRevenue kwi- New_text .

03 we 04

Ukufaka iSiSebenzi esiSebenzi

Nangona kunokwenzeka ukuba uthayiphe yonke ifomula efana nayo

= SUBSTITUTE (A3, "Sales", "Revenue")

ngokuzenzekelayo kwisitoreji somsebenzi, enye inxaxheba kukusebenzisa ibhokisi yencoko yencoko yomsebenzi - njengoko kuchaziwe kumanyathelo angezantsi - ukufaka umsebenzi kunye neengxabano zalo kwisisele njengeB3.

Inzuzo yokusebenzisa ibhokisi yencoko yababini kukuba i-Excel iyayinyamekela ukwahlukana kweengxabano nganye kunye ne-comma kwaye ifaka idatha yedatha endala kunye neyesitsha kwiimpawu zokucaphuna.

1. Cofa kwifowuni B3 - ukwenza iseli esebenzayo
2. Cofa kwiTrafom ithebhu yemenyu yebhondi
3. Cofa kwi Ikhonkco yombhalo kwibhanethi ukuvula imisebenzi yeTekisi yehlisa uluhlu
4. Cofa kwi- SUBSTITUTE kwoluhlu ukuzisa le bhokisi yencoko yencoko yomsebenzi
5. Kwibhokisi yencoko, nqakraza kwi- Text line
6. Cofa kwifowuni A3 ukungena kule fayile yeselenki kwibhokisi yencoko
7. Cofa kwi- Old_text line kwibhokisi yencoko
8. Uhlobo loThengiso , olubhaliweyo sifuna ukutshintsha-akukho mfuneko yokufaka isicatshulwa kumanqaku okucaphulwa;
9. Cofa kwiNew_ext line kwibhokisi yencoko
10. Uhlobo lweNgeniso , njengombhalo oza kufakwa endaweni ;;
11. I-argument ye- Instance ishiywe ingenanto - kuba kukho umzekelo omnye wegama Ukuthengiswa kwiseli A3;
12. Cofa u- OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko;
13. Ingxelo yeRevenue Report kufuneka ibonakale kwiseli B3;
14. Xa ucofa kwi-cell B3 umsebenzi opheleleyo
    = SUBSTITUTE (A3, "Sales", "Revenue")
    ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela

04 we 04

Umxhasi kunye noTshintsho

I-SUBSTITUTE iyahlukana nomsebenzi we-REPLACE ekubeni isetyenziselwa ukutshintshela itekisi ethile kunoma yiphi indawo kwi-data ekhethiweyo ngelixa i-REPLACE isetyenziselwa ukutshintsha nayiphi na isicatshulwa esenzeka kwindawo ethile kwindawo.