01 ka 01
Imisebenzi ye-Excel MID ne-MIDB
Uma umbhalo ukopishwa noma ungeniswe ku-Excel, izinhlamvu zedaka engafuneki ngezinye izikhathi zifakwe nedatha enhle.
Noma, kunezikhathi lapho kuphela ingxenye yocingo yocingo esitokisini edingekayo - njengegama lomuntu lokuqala kodwa hhayi igama lokugcina.
Ngezimo ezinjengalezi, i-Excel inemisebenzi eminingi engasetshenziselwa ukususa idatha engadingeki kusuka kwabanye.
Yimuphi umsebenzi oyisebenzisayo kuncike lapho idatha enhle itholakala khona ngokuhambisana nezinhlamvu ezingadingeki esitokisini.
- Uma idatha enhle, noma engaphansi kokugcinwa, ingakwesokudla kwedatha, sebenzisa umsebenzi WOKULUNGA ukukhipha.
- Uma lo mshini ungakwesokunxele kwedatha, sebenzisa umsebenzi we- LEFT ukuze uwususe.
- Uma lo mshini unezinhlamvu ezingadingeki ezinhlangothini zalo zombili, sebenzisa imisebenzi ye- MID noma ye-MIDB ukuze uyisuse.
I-MID vs. MIDB
Imisebenzi ye-MID ne-MIDB ihluke kuphela ngezilimi abayisekelayo.
I-MID yiyona yezilimi ezisetshenziselwa ukusethwa komlingiswa owodwa- leli qembu lihlanganisa izilimi eziningi ezifana nesiNgisi nazo zonke izilimi zaseYurophu.
I-MIDB yimizi esebenzisa isethi yezinhlamvu ezimbili-byte - ihlanganisa isiJapan, isiShayina (Esenziwe Lula), isiShayina (Esivamile) nesiKorea.
I-Syntax ne-Arguments ye-MID ne-MIDB
Ku-Excel, i- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-MID yilezi:
= MID (Umbhalo, Qala_num, Num_chars)
I-syntax yomsebenzi we-MIDB yile:
= MIDB (Umbhalo, Qala_num, Num_bytes)
Lezi zimpikiswano zitshela i-Excel
- iyiphi idatha okufanele isetshenziswe kulo msebenzi;
- isikhundla sokuqala se-data enhle noma engxenyeni engezansi okumelwe isuswe;
- ubude be-substring.
Umbhalo - (okudingekayo kumsebenzi we- MID ne- MIDB ) uchungechunge lwetheksi equkethe idatha oyifunayo
- le mpikiswano ingaba yocingo langempela noma ireferensi yeseli endaweni yedatha ekhasini lokusebenzela - imigqa 2 no-3 esithombeni ngenhla.
I-Start_num - (edingekayo kumsebenzi we- MID ne- MIDB ) ichaza umlingisi wokuqala ukusuka kwesobunxele kwendawo engezansi ukuze igcinwe.
I-Num_chars - (edingekayo kumsebenzi we- MID ) ichaza inani labalingiswa ngakwesokudla kwe-Start_num okufanele igcinwe.
Ama -_bytes (adingekayo kumsebenzi we- MIDB ) acacisa inani labalingiswa - nge-bytes - ngakwesokudla se-Start_num okufanele igcinwe.
Amanothi:
Uma i- Start_num mkhulu kunebude bezintambo zomculo, i- MID / MIDB ibuyisa isilawuli esingenalutho - irowu 4 yesithombe, lapho i- Start_num ilingana no-14, futhi i-string string inezinhlamvu ezingu-13 kuphela.
Uma i- Start_num ingaphansi kwe-1 noma i- Num_chars / Num_bytes ayinayo umsebenzi we- MID / MIDB ubuyisa i- #VALUE! inani lephutha - irowu 6 yesithombe, lapho i-Start_num ilingana ne--1.
Uma i- Num_chars / Num_bytes ibhekisela esitokisini esingenalutho noma isethelwe ku-zero, i- MID / MIDB ibuyisela ingqamuzana engu-7 yesithombe, lapho i- Num_chars ibonisa khona isilwane esingenalutho esingu-B13.
Isibonelo Sokusebenza Kokusebenza - Khipha Idatha Elihle Kubi
Isibonelo esithombeni esingenhla sibonisa izindlela ezimbalwa zokusebenzisa umsebenzi we-MID ukukhipha inombolo ethile yezinhlamvu ezivela kwichungechunge lombhalo, kufaka phakathi ukufaka idatha ngokuqondile njengezingxabano zomsebenzi - irowu 2 - nokufaka izingqikithi zamangqamuzana kuzo zonke izimpikiswano ezintathu - umugqa 5.
Njengoba kungcono kakhulu ukufaka izingqikithi zamangqamuzana ezimpikiswano kunokuba idatha yangempela, ulwazi olungezansi ludwe izinyathelo ezisetshenziselwa ukungena umsebenzi we-MID kanye nezimpikiswano zalo esitokisini C5.
Ibhokisi le-MID Function
Izinketho zokungena emsebenzini kanye neziphakamiso zalo zibe esitokisini C5 zibandakanya:
- Ukuthayipha umsebenzi ophelele: = MID (A3, B11, B12) esitokisini C5.
- Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi
Ukusebenzisa ibhokisi lengxoxo ukufaka umsebenzi ngokuvamile kuvamise umsebenzi njengoba ibhokisi lengxoxo lizinakekela i-syntax yomsebenzi - ukungena egameni lomsebenzi, ama-separators wama-commas, nabakaki ezindaweni ezifanele nobuningi.
Ukubhekisela ekubhekisweni kwezingcingo
Kungakhathaliseki ukuthi iyiphi inketho oyikhethayo yokufaka umsebenzi kwiseli lokusebenzela, kungcono kakhulu ukusebenzisa iphuzu bese uchofoze ukufaka noma yikuphi futhi zonke izinkomba ezisetshenziswa njengezingqinamba ukunciphisa ithuba lamaphutha abangelwa ukuthayipha kusithenjwa esingalungile samaseli.
Ukusebenzisa ibhokisi le-MID Function Box
- Chofoza kuseli C1 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi izoboniswa khona;
- Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
- Khetha Umbhalo kusuka kubhebhoni ukuze uvule uhlu oluhlehlisiwe lomsebenzi;
- Chofoza ku- MID ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
- Ebhokisini lengxoxo, chofoza kulayini wombhalo ebhokisini lengxoxo;
- Chofoza kuseli ye-A5 kusikripthi sokusebenzela ukufaka le nkomba ye-cell njenge- Arguments Text ;
- Chofoza ku- Start_num line
- Chofoza kuseli B11 kusikripthi sokusebenza ukuze ufake leli referensi yeseli;
- Chofoza kumugqa we- Num_chars ;
- Chofoza kuseli B12 kusikripthi sokusebenza ukuze ufake leli referensi yeseli;
- Chofoza OK ukuze uqedele umsebenzi bese uvala ibhokisi lengxoxo;
- Ifayili engezansi ekhishwe # 6 kufanele ivele kuseli C5;
- Uma uchofoza kumakhalekhukhwini C5 umsebenzi ophelele = MID (A3, B11, B12) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
Ukukhipha Izinombolo nge-MID Umsebenzi
Njengoba kuboniswe emgqeni isibonelo esishiyagalombili ngenhla, umsebenzi we-MID ungasetshenziswa ukukhipha i-subset yedatha yenombolo kusukela enombolweni ende usebenzise izinyathelo ezibalwe ngenhla.
Inkinga kuphela ukuthi idatha ekhishwe ishintshiwe futhi ayikwazi ukusetshenziswa ekubaleni okubandakanya imisebenzi ethile - njengemisebenzi ye- SUM kanye ne- AVERAGE .
Enye indlela ezungeze le nkinga ukusebenzisa umsebenzi we-VALUE ukuguqula umbhalo ube yinombolo njengoba kuboniswe kulayini 9 ngenhla:
= VALUE (MID (A8,5,3))
Okwesibili ukhethe ukunamathisela okhethekile ukuguqula umbhalo kumanani .