01 ngo 01
Imisebenzi ye-MID ne-MIDB
Xa umbhalo ukopishwa okanye ungeniswa kwi-Excel, ngamagama athile afuneki ngamatye ahlawulwa ngamanye amaxesha kunye nedatha efanelekileyo.
Okanye, kukho amaxesha apho kuphela inxalenye yomtya wesicatshulwa kwiseli iyadingeka - njengegama lokuqala lomntu kodwa kungekhona igama lokugqibela.
Kwiimeko ezifana nalezi, i-Excel inemisebenzi emininzi ingasetyenziselwa ukususa idatha engafunekiyo.
Yiyiphi umsebenzi oyisebenzisayo kuxhomekeke apho idilesi efanelekileyo ifumaneka malunga neenhlamvu ezingafuneki kwiseli.
- Ukuba idatha efanelekileyo, okanye i- substtion egcinwe kuyo, ingakwesokunene kwedatha, sebenzisa UMSEBENZI WOKUBA ukuwukhupha.
- Ukuba umgca wecala lusekhohlo lwedatha, sebenzisa umsebenzi we- LEFT ukukhipha.
- Ukuba i-substring inezinhlamvu ezingafunekiyo kumacala omabini alo, sebenzisa imisebenzi ye- MID okanye ye-MIDB ukuyikhupha.
MID kunye neM MIDB
Imisebenzi ye-MID kunye ne-MIDB iyahluka kuphela kwiilwimi abazixhasayo.
I-MID iilwimi ezisetyenziselwa isetyenzisi se- single-byte - eli qela liquka ezininzi iilwimi ezifana nesiNgesi kunye neelwimi zonke zaseYurophu.
I-MIDB yeelwimi ezisetyenziselwa isetyenzisi somgangatho wesibini-byte ziquka isiJapane, isiTshayina (senziwe lula), isiTshayina (isiShayina) nesiKorea.
I-MID ne-MIDB Imisebenzi yeSintax kunye neArguments
Kwi-Excel, i- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, amabakaki kunye neengxabano .
I-syntax yomsebenzi we-MID yile:
= MID (Umbhalo, Qala_num, Num_chars)
I-syntax yomsebenzi we-MIDB yile:
= MIDB (Umbhalo, Qala_num, Num_bytes)
Ezi ngxabano zixelela i-Excel
- yiyiphi idatha ekufuneka isetyenziswe kulo msebenzi;
- indawo yokuqala yeedatha ezilungileyo okanye i-substtion eyokukhishwa;
- ubude bendawo.
Umbhalo - (ofunekayo kumsebenzi we- MID kunye ne- MIDB ) umtya wombhalo oqukethe idatha efunwayo
- le ngxabano ingaba yintambo yomgca okanye isetyenzisi yeseli kwindawo yendawo kwiphepha lokusebenzela - imigqa 2 kunye no-3 kumfanekiso ongentla.
I-Start_num - (efunekayo kumsebenzi we- MID kunye ne- MIDB ) ichaza isalathisi sokuqala ukusuka ngakwesobunxele kwendawo engasemva ukuba igcinwe.
Num_chars - (efunekayo kumsebenzi we- MID ) ichaza inani labalinganiswa ngakwesokudla kwi-Start_num ukuba igcinwe.
Num_bytes (efunekayo kumsebenzi we- MIDB ) ichaza inani labalinganiswa - kwi-bytes-ngakwesokudla se-Start_num ukuba igcinwe.
Amanqaku:
Ukuba i- Start_num mkhulu kunebude bomtya wombhalo, i- MID / MIDB ibuyisela i-cell engqaliweyo -umgca 4 womfanekiso, apho i- Start_num ilingana ne-14, kwaye umtya weetekisi ulingezinhlamvu ezili-13 kuphela.
Ukuba i- Start_num ingaphantsi kwe-1 okanye i- Num_chars / Num_bytes ayiyiyo umsebenzi we MID / MIDB ubuyisela i-#VALUE! Ixabiso lesiphene - umgca 6 womfanekiso, apho i-Start_num ilingana ne--1.
Ukuba i_ Num_chars / Num_bytes ibonisa isalathisi esingenanto okanye isetyenziswe kwi-zero, i- MID / MIDB ibuyisela i-cell cell-row 7 yomfanekiso, apho i- Num_chars ibonisa i-cell engenanto engu -B13.
Umzekelo Wemisebenzi ye-MID - Susa iDatha efanelekileyo esuka kwi-Bad
Umzekelo kumfanekiso ongasentla ubonisa inani leendlela zokusebenzisa umsebenzi we-MID ukukhupha inani elithile labalinganiswa ukusuka kwintambo yombhalo, kuquka ukufaka idatha ngokuchanekileyo njengengxabano yomsebenzi - umqolo wesi-2 - nokufaka iingxelo zeseli kuzo zonke iingxoxo ezintathu umgca 5.
Ekubeni kulungele ukufaka iingcamango zeselferensi kwiingxoxo kunokubakho idatha yangoku, ulwazi olungezantsi ludwelise amanyathelo asetyenziswa ukufaka umsebenzi we-MID kunye neengxabano zalo kwi-cell C5.
Ibhokisi yeNtsebenzo ye MID
Izinketho zokungena kumsebenzi kunye neengxabano zalo kwi-cell C5 zibandakanya:
- Ukuthayipha umsebenzi opheleleyo: = MID (A3, B11, B12) kwi-cell C5.
- Ukukhetha umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi
Ukusebenzisa ibhokisi yencoko yokufaka umsebenzi ngokuqhelekileyo kunciphisa umsebenzi njengoko ibhokisi yencoko yebhokisi yencoko iyakhathalela i-syntax yomsebenzi - ukungena kwigama lomsebenzi, abahluli bama-commas, kunye nabakhonkco kwiindawo ezichanekileyo kunye nobungakanani.
Ukubhekisela kwiiNgxelo zeeSeli
Kungakhathaliseki ukuba yiyiphi inyulo oyikhethayo yokungena kumsebenzi kwiseli yomsebenzi, mhlawumbi kulungele ukusebenzisa iphoyinti kwaye nqakraza ukungena nayiphi na imiqondiso yeselenzisi esetyenziswe njengeengxabano zokunciphisa ithuba lokuphosakela okubangelwa ukuthayipha kwi-cell reference reference.
Ukusebenzisa ibhokisi yeDVD yokuSebenza
- Cofa kwifowuni C1 ukwenzela ukuba yenze iseli esebenzayo- yilapho iziphumo zomsebenzi ziza kuboniswa;
- Cofa kwiThebhu yefomula yemenyu yebhondi ;
- Khetha umbhalo kwibhanethi ukuze uvule uluhlu lwehla lokuhla;
- Cofa kwi- MID kwisahlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
- Kwibhokisi yencoko, nqakraza kwi- Text line kwibhokisi yencoko;
- Cofa kwi-cell A5 kwiphepha lokusebenzela ukuze ufake le fom yeferensi njengengqinano yeTekisi ;
- Cofa kwi- Start_num line
- Cofa kwifowuni B11 kwiphepha lokusebenzela ukufaka le referensi yeseli;
- Cofa kwiNombolo_chars ;
- Cofa kwifowuni B12 kwiphepha lokusebenzela ukufaka le referensi yeseli;
- Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko;
- Ifayile engaphantsi kwefayile engama-6 kufuneka ibonakale kwiseli C5;
- Xa ucofa kwi-cell C5 umsebenzi opheleleyo = I-MID (A3, B11, B12) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
Ukukhupha iinombolo kunye neMisebenzi ye-MID
Njengoko kuboniswe kumqolo wesibhozo umzekelo ongentla, umsebenzi we-MID ungasetyenziselwa ukukhipha i-subset yedatha yenombolo ukusuka kwinani elide usebenzisa amanyathelo alwe apha ngasentla.
Ingxaki kuphela yinto yokuba idatha echitshiweyo iya guqulwa ibe yombhalo kwaye ayikwazi ukusetyenziswa kwizibalo ezibandakanya imisebenzi ethile - njengemisebenzi ye- SUM ne- AVERAGE .
Enye indlela ejikeleze le ngxaki kukusebenzisa umsebenzi we-VALUE ukuguqula isicatshulwa kwinani njengoko kuboniswe kumgca 9 ngentla:
= VALUE (MID (A8,5,3))
Inketho yesibini kukusebenzisa intengiso ekhethekileyo ukuguqula itekisi kumanani .