Zamkatimu
Dzulo pa marathon 30 Excel imagwira ntchito m'masiku 30 tinagwiritsa ntchito INDEX (INDEX) kuti mubweze mtengo wa selo yomwe ili pamzerewu ndi mzere womwe waperekedwa.
Pa tsiku la 25 la marathon, tidzapereka phunziro la ntchitoyi Sinthanitsani (REPLACE), yomwe ili m'gulu lazolemba. Imalowetsamo chiwerengero cha zilembo zamtundu wina ndi zolemba zina.
Choncho, tiyeni tione mwatsatanetsatane zambiri ndi zitsanzo pa ntchito Sinthanitsani (REPLACE), ndipo ngati muli ndi zowonjezera kapena zitsanzo, chonde gawanani nawo mu ndemanga.
Ntchito 25: M'MALO
ntchito Sinthanitsani (REPLACE) imalowa m'malo mwa zilembo zomwe zili mkati mwamawu potengera kuchuluka kwa zilembo komanso malo oyambira.
Kodi ntchito ya REPLACE ingagwiritsidwe ntchito bwanji?
ntchito Sinthanitsani (REPLACE) atha kusintha zilembo pamndandanda wamawu, mwachitsanzo:
- Sinthani nambala yadera mu nambala yafoni.
- Sinthani danga ndi colon ndi danga.
- Gwiritsani ntchito cholembera Sinthanitsani (REPLACE) kuti muyike ma hyphens angapo.
BWINO KWAMBIRI Syntax
ntchito Sinthanitsani (REPLACE) ili ndi mawu awa:
REPLACE(old_text,start_num,num_chars,new_text)
ЗАМЕНИТЬ(старый_текст;нач_поз;число_знаков;новый_текст)
- zakale_lemba (old_text) - zingwe zomwe zilembo zidzasinthidwe.
- chiyambi_nambala (start_pos) - malo oyambira a zilembo zakale.
- nambala_chars (num_chars) - chiwerengero cha zilembo zakale.
- new_text (new_text) - malemba omwe adzalowetsedwe m'malo mwa zilembo zakale.
Misampha REPLACE (REPLACE)
ntchito Sinthanitsani (REPLACE) imalowa m'malo mwa chiwerengero cha zilembo kuyambira pa malo otchulidwa. Kuti mulowe m'malo mwa mzere wina wa mawu paliponse m'mawu oyamba, mutha kugwiritsa ntchito ntchitoyi WOLEMBEDWA ( SUBSTITUTE ), zomwe tiwona pambuyo pake mu mpikisano wathu.
Chitsanzo 1: Kusintha kachidindo kagawo mu nambala yafoni
Kugwiritsa ntchito Sinthanitsani (REPLACE) Mukhoza kusintha manambala atatu oyambirira a nambala ya foni, mwachitsanzo, pamene code yatsopano yakhazikitsidwa. Kwa ife, nambala yatsopano yadera imalowetsedwa mugawo C, ndipo manambala a foni okonzedwa amawonetsedwa pagawo D.
=REPLACE(B3,1,3,C3)
=ЗАМЕНИТЬ(B3;1;3;C3)
Chitsanzo 2: Bweretsani danga ndi koloni ndi danga
Kutanthauzira malo oyambira ntchito Sinthanitsani (REPLACE), Mutha kugwiritsa ntchito ntchitoyi DZIWANI (PEZANI) kuti mupeze mzere wina wa mawu kapena zilembo. Muchitsanzo ichi, tikufuna kusintha malo oyamba omwe amapezeka muzolemba ndi colon yotsatiridwa ndi danga.
=REPLACE(B3,FIND(" ",B3,1),1,": ")
=ЗАМЕНИТЬ(B3;НАЙТИ(" ";B3;1);1;": ")
Chitsanzo 3: Ntchito zokhazikika za REPLACE kuti muyike ma hyphens angapo
ntchito Sinthanitsani (REPLACE) amaloledwa kupanga chisa chimodzi mkati mwa chinzake, kotero kuti zosintha zingapo zitha kupangidwa m'mawu oyambira. Muchitsanzo ichi, manambala a foni ayenera kukhala ndi ma hyphens pambuyo pa zilembo zitatu zoyambirira komanso pambuyo pa chachiwiri. Kugwiritsa Zero, monga kuchuluka kwa zilembo zomwe zingasinthidwe, tipeza zotsatira kuti palibe zilembo za nambala yafoni zomwe zidzachotsedwe, ma hyphens awiri okha ndi omwe adzawonjezedwe.
=REPLACE(REPLACE(B3,4,0,"-"),8,0,"-")
=ЗАМЕНИТЬ(ЗАМЕНИТЬ(B3;4;0;"-");8;0;"-")