01 ka 01
Imisebenzi ye-LEFT ye-Excel ne-LEFTB
Uma umbhalo ukopishwa noma ungeniswe ku-Excel, izinhlamvu zedaka engafuneki ngezinye izikhathi zifakwe nedatha enhle.
Noma, kunezikhathi lapho kuphela ingxenye yedatha yombhalo 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 ingakwesokudla kwedatha, sebenzisa umsebenzi we-RIGHT ukuyikhipha.
- Uma idatha enhle inezinhlamvu ezingafuneki ezinhlangothini zalo zombili, sebenzisa umsebenzi we-MID ukukhipha.
- Uma idatha enhle ingakwesokunxele kwedatha, sebenzisa umsebenzi we- LEFT ukuze uyisuse.
UKUSEBENZISA vs. LEFTB
Imisebenzi ye- LEFT ne- LEFTB ihluke kuphela ngezilimi abayisekelayo .
I-LEFT yizilimi ezisetshenziselwa ukuhlelwa komlingiswa oyedwa- leli qembu lihlanganisa izilimi eziningi ezifana nesiNgisi nazo zonke izilimi zaseYurophu.
I-LEFT B yimizi esebenzisa isethi yezinhlamvu ezimbili-byte - ihlanganisa isiJapane, isiShayina (Esenziwe Lula), isiShayina (Esivamile) nesiKorea.
Imisebenzi ye-LEFT ne-LEFTB i-Syntax ne-Arguments
Ku-Excel, i-syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we- LEFT yilezi:
= LEFT (Umbhalo, Num_chars)
Izimpendulo zomsebenzi zitshela i-Excel ukuthi iyiphi idatha okufanele isetshenziswe kulo msebenzi nobude bezintambo okufanele zisuswe.
I-syntax yomsebenzi we- LEFTB yilezi:
= LEFT (Umbhalo, Num_bytes)
Izimpendulo zomsebenzi zitshela i-Excel ukuthi iyiphi idatha okufanele isetshenziswe kulo msebenzi nobude bezintambo okufanele zisuswe.
Umbhalo - (odinga i- LEFT ne- LEFTB ) ukungena okuqukethe idatha oyifunayo
- le mpikiswano ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela noma ingaba umbhalo okhona wangena kumamaki okucaphuna
I-Num_chars - (okukhethwa yi- LEFT ) ichaza inani labalingiswa ngakwesokunxele kwempikiswano yocingo okufanele igcinwe - zonke ezinye izinhlamvu zisusiwe.
Ama -_bytes - (okukhethwa ku- LEFTB ) acacisa inani labalingiswa ngakwesokunxele kwempikiswano yocingo okufanele igcinwe ku -teste - zonke ezinye izinhlamvu zisusiwe.
Amanothi:
- Uma Num_chars / Ama -_bytes akhiyiwe, inani elizenzakalelayo lezinhlamvu ezingu-1 liboniswa umsebenzi - irowu 4 kusibonelo;
- Uma Num_chars / Ama -_bytes amakhulu kunombhalo wombhalo, umsebenzi ubuyisela yonke inamba yombhalo - irowu 5 kusibonelo;
- Uma inani lama- Num_chars / Num_bytes Ukungqubuzana akubi, umsebenzi ubuyisela i- #VALUE! inani lephutha - irowu 6 yesithombe.
- Uma inani lama- Num_chars / Num_bytes ukuphikisana kubonisa iseli elingenalutho noma lilingana ne-zero, umsebenzi ubuyisela iseli elingenalutho - irowu 7 yesithombe lapho NUM_chars ibhekisela khona esitokisini esingenalutho B13.
Isibonelo Sokusebenza Kokusebenza - Khipha Idatha Elihle Kubi
Isibonelo esithombeni esingenhla sibonisa izindlela eziningi zokusebenzisa umsebenzi we-LEFT ukukhipha inombolo ethize yezinhlamvu ezivela kulayini wombhalo, kufaka phakathi ukungena kwedatha ngokuqondile njengezingxabano zomsebenzi - umugqa wesibili - nokufaka izingqikithi zamangqamuzana zombili izingxabano - umugqa 3.
Njengoba ngokuvamile kungcono ukufaka izingqikithi zamangqamuzana ezimpikiswano esikhundleni semininingwane yangempela, ulwazi olungezansi lubhale izinyathelo ezisetshenziselwa ukungena emsebenzini we-LEFT kanye nezimpikiswano zayo zibe esitokisini C3 ukuze kukhishwe igama elithi Umjaho kusuka kwichungechunge lombhalo esitokisini A3.
Ibhokisi le-Function LEFT
Izinketho zokufaka umsebenzi kanye nezimpikiswano zalo esitokisini B1 zihlanganisa:
- Ukuthayipha umsebenzi ophelele: = LEFT (A3.B9) ibe yiseli C3;
- 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 lebhokisi lokusebenza le-LEFT
Uhlu olungezansi yizinyathelo ezisetshenziselwa ukungena emsebenzini we- LEFT nezimpikiswano zayo zibe esitokisini C3 usebenzisa ibhokisi lengxoxo lomsebenzi.
- Chofoza kuseli C3 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- LEFT ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi;
- Ebhokisini lengxoxo, chofoza ku- Text line;
- Chofoza ku-cell A3 kushidi lokusebenzela ukuze ufake leyo reference reference ebhokisini lengxoxo;
- Chofoza kumugqa we- Num_chars ;
- Chofoza kuseli B9 kusikripthi sokusebenza ukuze ufake leyo reference reference;
- Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela;
- I-Widget engezansi ekhishwe kufanele ivele kuseli C3;
- Uma uchofoza ku-cell C3 umsebenzi ophelele = LEFT (A3, B9) ibonakala kubha yefomula ngaphezulu kwephepha lokusebenzela.
Ukukhipha Izinombolo nge-LEFT Umsebenzi
Njengoba kuboniswe kusibonelo sesishiyagalombili esilandela ngenhla, umsebenzi we- LEFT ungasetshenziswa ukukhipha i-subset yedatha yenombolo kusuka enombeni ende usebenzisa 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 (LEFT (B2, 6))
Okwesibili ukhethe ukunamathisela okhethekile ukuguqula umbhalo kumanani .