Iko SUBSTITUTE basa rinogona kushandiswa kutora mamwe mazwi aripo, mavara, kana vatsva vane data itsva.
Cherechedza: Migumisiro yebasa rinofanira kuonekwa pane imwe nzvimbo pane yepakutanga.
Zvishandiso zvebasa zvinosanganisira:
- Kubvisa vasiri-kudhinda vatambi kubva kudhipatimendi inotumirwa;
- Kudzorera vanhu vasingadiwi mavara nezvivako;
- Kubudisa zvinyorwa zvakasiyana zvepajiro rimwechete.
01 ye 04
Kushandisa Old Old Text for New
Syntax Yechibvumirano Chebasa uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara we SUBSTITUTE basa ndewokuti:
= SUBSTITUTE (Magwaro, Old_text, New_text, Instance_num)
Nharo dzebasa iri:
Mhemberero - (inodikanwa) data ine ndima inofanira kuchinjwa. Iyi nharo inogona kuva
- iyo chaiyo data yakavharwa muzvinyorwa zvinyorwa-mutsara maviri mumufananidzo uri pamusoro;
- sero rinotarisa kune nzvimbo yemashoko zvakanyorwa mubasa rekushanda - rutsara matatu pamusoro;
Old_text - (inoda) mutsara inofanira kuchinjwa.
Mutsva_text - (inodikanwa) mutsara uchashandura Old_text .
Instance_num - (kusarudza) nhamba
- Kana akasiya, mamiriro ose eAkare_text anotsiviwa neNew_text .
- Kana yakabatanidzwa, chete chiitiko chekare-chinyorwa chakatsanangurwa - sechiitiko chekutanga kana chechitatu - chinotsiviwa - mitsetse yechishanu uye nhanhatu pamusoro apa.
02 of 04
Mhosva Sensitivity
Nhaurirano dze SUBSTITUTE basa ndedzemhosva, izvo zvinoreva kana data inopinda ye Old_text argument haina mhaka imwechete iyo data in Text argument cell, hapana kuchinja kunoitika.
Semuenzaniso, mumutsara mana wemufananidzo wepamusoro, basa rinoona Sales (cell A4) yakasiyana nekutengesa (Old_text argument ) uye, naizvozvo, haisi kutsiva Revenue muNew_text .
03 of 04
Kupinda Basa Rinosimudzira
Kunyange zvazvo zvichikwanisika kunyora zvose zvakasarudzwa zvakadai se
= SUBSTITUTE (A3, "Sales", "Revenue")
zvinyorwa mumashini ekushanda, rimwe sarudzo nderokushandisa sarudzo yebhokisi rebasa - sezvinotsanangurwa mumatanho ari pasi - kuisa basa uye nharo dzaro mune sero seB3.
Kubatsirwa kwekushandisa bhokisi rebhokisi nderokuti Excel inotarisira kuparadzanisa nharo imwe neimwe nekomma uye inovhara deta yekare uye itsva pane zvinyorwa zvinyorwa.
- Dzvanya pane sero B3 - kuti riite sero rinoshanda
- Dzvanya paMafomu yebhu yebhoni yebhoni
- Dzvanya paIndaneti icon pane ribhoni kuti uzarure Maitiro emitemo inowira pasi
- Dzvanya ku SUBSTITUTE murugwaro kuti ubudise bhokisi rebasa iri
- Mubhokisi rebhokisi, chengeta paMagwaro
- Dzvanya pachitokisi A3 kuti uise iyo rekero rekero mubhokisi rebhokisi
- Dzvanya pane Old_text line mubhokisi rebhokisi
- Tora Mitengo , iyo ndiyo yenyaya yatinoda kutora - hapana chidimbu chekuvhara mashoko mumashoko ekudzokorora;
- Dzvanya paNew_text line mubhokisi rebhokisi
- Tora Revenue , sezvinonzi text to substituted ;;
- The Instance argument yasara isina chinhu - sezvo pane imwe chete yezwi rinonzi Sales in cell A3;
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi;
- Nheyo Revenue Report inofanira kuonekwa muchitokisi B3;
- Paunenge uchinyora pa cell B3 basa rakakwana
= SUBSTITUTE (A3, "Sales", "Revenue")
inowanikwa mubhairi yepamusoro pane pepa rekushanda
04 we 04
Substitute vs. Replace
SUBSTITUTE inopesana nebasa re REPLACE pakuti inoshandiswa kuparadzanisa zvinyorwa zvakasiyana chero kupi zvako munzvimbo yakasarudzwa apo REPLACE inoshandiswa kutsvaga chero rugwaro runowanikwa pane imwe nzvimbo munharaunda.