Umsebenzi we-Excel SUBSTITUTE

Umsebenzi we-SUBSTITUTE ungasetshenziswa ukufaka esikhundleni samagama akhona, umbhalo, noma izinhlamvu nge idatha entsha.

Qaphela: Imiphumela yomsebenzi kumele ibonakale endaweni ehlukile kunombhalo wokuqala.

Ukusetshenziswa komsebenzi kuhlanganisa:

• Ukususa izinhlamvu ezingashicileli kusuka kudatha engenisiwe;
• Ukufaka izinhlamvu ezingadingeki ngezikhala;
• Ukhiqiza izinguqulo ezahlukene zeshidi lokusebenzela elifanayo.

01 ngo-04

Ukuhambisa umbhalo omdala weNew

I-Syntax YemiSebenzi Yesikhashana kanye Neziphakamiso

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-SUBSTITUTE yilezi:

= SUBSTITUTE (Umbhalo, Old_text, New_text, Instance_num)

Amaphuzu alo msebenzi yilezi:

Umbhalo - (okudingekayo) idatha equkethe umbhalo okumele ushintshwe. Le mpikiswano ingaqukatha

• idatha yangempela ehlanganisiwe kumamaki okucaphuna - irowu ezimbili esithombeni ngenhla;
• ireferensi yeseli endaweni yedatha yombhalo ekhasini lokusebenzela - irowu ezintathu ngenhla;

I-Old_text - (edingekayo) umbhalo ozoshintshwa .

I-new_text - (edingekayo) umbhalo ozothatha isikhundla se- Old_text .

Isimo_noma - (ngokuzithandela) inombolo

• Uma kukhishiwe, yonke into ye- Old_text ithathelwe indawo nge- New_text .
• Uma kuhlanganisiwe, kuphela isibonelo se- Old_text eshiwo - njengezikhathi zokuqala noma zesithathu - zithathwa esikhundleni - imigqa emihlanu nesithupha ngaphezulu.

02 ka 04

Isimo Sensitivity

Iziphakamiso ze-SUBSTITUTE umsebenzi zibucayi, okusho ukuthi uma idatha ingena kwi- Old_text ingxabano ayinayo icala elifanayo njengedatha kwi- Text argument cell, akukho ukufaka endaweni.

Isibonelo, emgqeni wesine isithombe esingenhla, ukubukwa komsebenzi Ukuthengisa (iselula A4) kuhlukile ekudayiseni (i-Old_text argument ) , ngakho-ke, akufaki esikhundleni seRevenue njengo- New_text .

03 ka 04

Ukufaka umsebenzi ongasese

Nakuba kungenzeka ukuthayipha yonke ifomula njenge

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

ngokuzenzekelayo ube yiseli lokusebenzela, enye indlela ukusebenzisa ibhokisi lengxoxo lomsebenzi - njengoba kuchazwe ezinyathelweni ezingezansi - ukufaka umsebenzi kanye nezingxabano zalo esitokisini njenge-B3.

Izinzuzo zokusebenzisa ibhokisi lebhokisi yilabo i-Excel inakekela ukuhlukanisa i-argument ngayinye nge-comma futhi ifaka idatha yesikhathi esidala neyemisha kumamaki okucaphuna.

1. Chofoza kuseli B3 - ukwenza kube iseli esebenzayo
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon
3. Chofoza ku- Itheksthi yombhalo ku-Ribbon ukuze uvule uhlu lwezincwadi ezibhekiswe phansi
4. Chofoza ku- SUBSTITUTE ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi
5. Ebhokisini lebhokisi, chofoza ku- Text line
6. Chofoza kwiseli A3 ukungena kule nkomba yebheli ebhokisini lengxoxo
7. Chofoza ku- Old_text line ebhokisini lengxoxo
8. Thayipha Ukuthengisa , okuyinto umbhalo esifuna ukufaka esikhundleni - asikho isidingo sokufaka umbhalo kumamaki okucaphuna;
9. Chofoza ku- New_text line ebhokisini lengxoxo
10. Thayipha Imali engenayo , njengoba umbhalo ozofakwa endaweni ;;
11. I-argument ye- Instance ishiywa ingenalutho - ngoba kukhona isibonelo esisodwa segama elithi Sales in cell A3;
12. Chofoza OK ukuze uqedele umsebenzi bese uvala ibhokisi lengxoxo;
13. Umbhalo weRevenue Report kufanele uvele esitokisini B3;
14. Uma uchofoza ku-cell B3 umsebenzi ophelele
    = SUBSTITUTE (A3, "Sales", "Revenue")
    ibonakala kubha yefomula ngaphezulu kwephepha lokusebenzela

04 ka 04

Yenza okunye esikhundleni sakho

I-SUBSTITUTE ihluke emsebenzini we-REPLACE ngoba isetshenziselwa ukushintshanisa umbhalo othize kunoma iyiphi indawo ku-data ekhethiwe ngenkathi i-REPLACE isetshenziselwa ukufaka esikhundleni sombhalo owenzeka endaweni ethize yedatha.