01 ngo 01
Imisebenzi ye-LEFT kunye ne-LEFTB
Xa umbhalo ukopishwa okanye ungeniswa kwi-Excel, ngamagama athile afuneki ngamatye ahlawulwa ngamanye amaxesha kunye nedatha efanelekileyo.
Okanye, kukho amaxesha apho kuphela inxalenye yedata yecatshulwa 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 ingekunene kwedatha, sebenzisa umsebenzi WOKUDLA ukuwukhupha.
- Ukuba idatha efanelekileyo inezinhlamvu ezingafunekiyo kumacala omabini, sebenzisa umsebenzi we-MID ukuwukhupha.
- Ukuba idatha efanelekileyo isekho kwicala lasekhohlo lwedatha, sebenzisa umsebenzi we- LEFT ukuze uyikhuphe.
LEFT vs LEFTB
Imisebenzi ye- LEFT ne- LEFTB iyahluka kuphela kwiilwimi abazixhasayo .
I-LEFT yeelwimi ezisetyenziselwa ukusetyenzwa kwempawu-ye-byte- eli qela liquka ezininzi iilwimi ezifana nesiNgesi kunye neelwimi zonke zaseYurophu.
I-LEFT B iilwimi ezisetyenziselwa isetyenzisi somgangatho wesibini-byte ziquka isiJapane, isiTshayina (senziwe lula), isiTshayina (soMveli) kunye nesiKorea.
Imisebenzi ye-LEFT ne-LEFTB i-Syntax kunye neArguments
Kwi-Excel, i-syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, amabakaki kunye neengxabano .
I-syntax yomsebenzi we- LEFT yile:
= LEFT (Umbhalo, Num_chars)
Iingxoxo zomsebenzi zixelela i-Excel yintoni enye idatha ekufuneka isetyenziswe kumsebenzi kunye nobude bomtya ozokhishwa.
I-syntax yomsebenzi we- LEFTB yile:
= LEFT (Umbhalo, Num_bytes)
Iingxoxo zomsebenzi zixelela i-Excel yintoni enye idatha ekufuneka isetyenziswe kumsebenzi kunye nobude bomtya ozokhishwa.
Umbhalo - (ofunekayo kwi- LEFT ne- LEFTB ) ukungena equkethe idatha efunwayo
- le ngxabano ingaba yereferensi yeseli kwendawo yedatha kwiphepha lokusebenzela okanye ingaba yicatshulwa elifakwe kwiimpawu zokucaphulwa
I-Num_chars - ( okhethekileyo kwi- LEFT ) ichaza inani labalinganiswa ngakwesobunxele bexikiswano lomtya oluzogcinwa - bonke abanye abalinganiswa basuswa.
Num_bytes - ( okhethekileyo kwi- LEFTB ) icacisa inani labalinganiswa ngakwesobunxele kwenkcazo yocingo ukuba igcinwe kwi -tes - bonke abanye abalinganiswa basuswa.
Amanqaku:
- Ukuba Num_chars / Num_bytes ishiywe, ixabiso elingagqibekanga lomlingiswa o-1 luboniswa ngumsebenzi - umgca 4 kumzekelo;
- Ukuba Num_chars / Num_bytes mkhulu kunokuba ubude besicatshulwa , umsebenzi ubuyisela umgca wecatshulwa-umqolo wesi-5 kumzekelo;
- Ukuba ixabiso le- Num_chars / Num_bytes Ingxabano ayimbi, umsebenzi ubuyisela i-#VALUE! Ixabiso lesiphene - umgca 6 womfanekiso.
- Ukuba ixabiso le- Num_chars / Num_bytes Ingxabano ibonisa i-cell engenanto okanye ilingana no-zero, umsebenzi ubuyisela inqolobane engenanto engu- 7 yomfanekiso apho Num_chars ibonisa i-cell engenanto engu -B13.
UMSEBENZI WOKUSEBENZA UMSEBENZI - Ukukhupha uLwazi olungileyo oluvela kwi-Bad
Umzekelo kumfanekiso ongasentla ubonisa inani leendlela zokusebenzisa umsebenzi we-LEFT ukukhupha inani elithile labalinganiswa ukusuka kwintambo yombhalo, kuquka ukufaka idatha ngokuchanekileyo njengengxabano yomsebenzi - umqolo wesi-2 - nokufaka iingxelo zeseli zombini iziphakamiso - kumqolo 3.
Ekubeni kulungele ukufaka iingxelo zeefayile zeengxabano kunokubakho idatha yangoku, ulwazi olungezantsi ludwelise amanyathelo asetyenziswayo ukungena umsebenzi we-LEFT kunye neengxabano zayo kwisitokisi C3 ukukhipha igama Iifayile ezivela kumgca wokubhaliweyo kwiseli A3.
Ibhokisi yeNtsebenzo ye-LEFT
Izinketho zokungena kumsebenzi kunye neengxabano zalo kwi-cell B1 ziquka:
- Ukuthayipha umsebenzi opheleleyo: = LEFT (A3.B9) kwi-cell C3;
- 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 yeNtsebenzo ye-LEFT
Uluhlu olungezantsi ngamanyathelo asetyenziswa ukufaka umsebenzi we- LEFT kunye neengxabano zayo kwisitokisi C3 usebenzisa ibhokisi yencoko yencoko yomsebenzi.
- Cofa kwiseli C3 ukwenzela ukuba yenze iseli esebenzayo - yiyo apho iziphumo zomsebenzi ziya kuboniswa;
- Cofa kwiThebhu yefomula yemenyu yebhondi ;
- Khetha umbhalo kwibhanethi ukuze uvule uluhlu lwehla lokuhla;
- Cofa kwi- LEFT kwoluhlu ukuzisa ibhokisi yencoko yencoko yomsebenzi;
- Kwibhokisi yencoko, nqakraza kwi- Text line;
- Cofa kwiseli A3 kwiphepha lokusebenzela ukufaka loo ntetho yeselenki kwibhokisi yencoko;
- Cofa kwiNombolo_chars ;
- Cofa kwifayili B9 kwiphepha lokusebenzela ukuze ufake eso saziso seeseli;
- Cofa u-OK ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela;
- I-widring substring widgets kufuneka ibonakale kwiseli C3;
- Xa ucofa kwiseli C3 umsebenzi opheleleyo = LEFT (A3, B9) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
Ukukhupha iNombolo ngeSebenzi ye-LEFT
Njengoko kuboniswe kumqolo wesibhozo womzekelo ongentla, umsebenzi we- LEFT ungasetyenziselwa ukukhipha i-subset yedata 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 (LEFT (B2, 6))
Inketho yesibini kukusebenzisa intengiso ekhethekileyo ukuguqula itekisi kumanani .