01 ya 01
Ntchito za LEFT ndi LEFTB za Excel
Pamene malemba amalembedwa kapena kutumizidwa ku Excel, malemba osokonezeka omwe nthawi zina amawaphatikiza ndi deta yabwino.
Kapena, pali nthawi pamene mbali yokha ya malemba yomwe ili mu selo ikufunika - monga dzina la munthu koma osati dzina lomaliza.
Pazochitika monga izi, Excel ili ndi ntchito zingapo zomwe zingagwiritsidwe ntchito kuchotsa deta zosayenera kuchokera kwa ena onse. Ntchito yomwe mumagwiritsa ntchito imadalira kumene deta yabwino ilipo pafupi ndi zida zosafunikira mu selo.
- Ngati deta yabwino ili kumanja kwa deta, gwiritsani ntchito LOWANI ntchito kuti mulitenge.
- Ngati deta yabwino ili ndi malemba osafunika pa mbali zonsezi, gwiritsani ntchito MID ntchito kuti muichotse.
- Ngati deta yabwino ili kumanzere kwa deta, gwiritsani ntchito LEFT ntchito kuti muichotse.
KUYAMANA NDI LEFTB
Ma LEFT ndi LEFTB amagwira ntchito mosiyana ndi zilankhulo zomwe amachirikiza.
LEFT ndi zilankhulo zomwe zimagwiritsira ntchito chiwonetsero chimodzi- gululi limaphatikizapo zinenero zambiri monga Chingerezi ndi zinenero zonse za ku Ulaya.
LEFT B ndizo zinenero zomwe zimagwiritsidwa ntchito kawiri kawiri - zimaphatikizapo Chijapani, Chine (Chosavuta), Chine (Chikhalidwe), ndi Chi Korea.
Ntchito ya LEFT ndi LEFTB Ntchito Syntax ndi Arguments
Mu Excel, syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakita, ndi zifukwa .
Chidule cha ntchito ya LEFT ndi:
= LEFT (Malemba, Num_chars)
Maganizo a ntchitoyi amauza Excel zomwe ziyenera kugwiritsidwa ntchito pa ntchito ndi kutalika kwa chingwe kuti chichotsedwe.
Chidule cha ntchito ya LEFTB ndi:
= LEFT (Malemba, Num_bytes)
Maganizo a ntchitoyi amauza Excel zomwe ziyenera kugwiritsidwa ntchito pa ntchito ndi kutalika kwa chingwe kuti chichotsedwe.
Malembo - (ofunika kwa LEFT ndi LEFTB ) cholowera chomwe chili ndi deta yofunidwa
- ndemanga iyi ikhoza kutanthauzira selo kwa deta pamsewu wa ntchito kapena ikhoza kukhala yeniyeni yomwe ili mkati mwa zizindikiro za quotation
Num_chars - (zosankha za LEFT ) imatanthauzira chiwerengero cha malemba kumanzere kwa ndondomeko yogwiritsira ntchito kusungidwa - zilembo zina zonse zachotsedwa.
Num_bytes - (zosankha za LEFTB ) zimatanthauzira chiwerengero cha anthu omwe ali pamanja kumanzere kwa ndondomeko yachingwe kuti ikhale yosungidwa - byunthu zina zonse zachotsedwa.
Mfundo:
- Ngati Num_chars / Num_bytes sizimalephereka , mtengo wosasintha wa chikhalidwe 1 umasonyezedwa ndi ntchito - mzere 4 mu chitsanzo;
- Ngati Num_chars / Num_bytes ndi yayikulu kuposa kutalika kwa malemba, ntchito imabweretsanso mndandanda wa malemba - mzere 5 mu chitsanzo;
- Ngati mtengo wa Num_chars / Num_bytes Mtsutso ndi woipa, ntchito imabwerera #VALUE! Choyipa cholakwika - mzere 6 wa fanolo.
- Ngati mtengo wa Num_chars / Num_bytes Kukangana kumatanthawuza selo lopanda kanthu kapena ndilofanana ndi zero, ntchito imabwerera selo lopanda kanthu - mzere 7 wa fano kumene NUM_chars amawonetsera selo lopanda kanthu B13.
Chitsanzo Chogwira Ntchito - Chotsani Mauthenga Abwino Kuchokera Kuipa
Chitsanzo pa chithunzi pamwambapa chikusonyeza njira zingapo zomwe mungagwiritsire ntchito ntchito ya LEFT kuti muchotse nambala yeniyeni ya malemba kuchokera pamtundu wazinthu, kuphatikizapo kulowetsa deta mwatsatanetsatane monga zifukwa za ntchito - mzere 2 - ndikulowa mafotokozedwe a zifukwa zonsezi - mzere 3.
Popeza kuti ndi bwino kuti mulowetse zifukwa zamagulu m'malo mndondomeko yeniyeni, zomwe zili pansipa, zilembedwe njira zomwe zingagwiritsidwe ntchito polojekiti ya CFF ndi zifukwa zake mu selo C3 kuti atulutse mawu Ophatikizira kuchokera kulemba chingwe mu selo A3.
Bokosi la Kugwiritsa Ntchito la LEFT
Zosankha zolowera ntchito ndi zifukwa zake mu selo B1 zikuphatikizapo:
- Kujambula ntchito yonse: = LEFT (A3.B9) mu selo C3;
- Kusankha ntchito ndi zifukwa pogwiritsa ntchito bokosi la bokosi la ntchito .
Kugwiritsira ntchito bokosilo kuti mulowetse ntchito nthawi zambiri kumachepetsanso ntchito monga bokosi lamasewera limagwiritsira ntchito mawu ogwira ntchito - kulowetsa dzina la ntchito, ogawa makasitomala, ndi mabotolo m'malo oyenera ndi ochuluka.
Kuwonetsera pa Mafotokozedwe a Cell
Ziribe kanthu kuti mungasankhe bwanji kulowa ntchitoyi mu selo lamasewero, ndibwino kuti mugwiritse ntchito mfundo ndikusindikiza kuti mulowetse zolemba zonse zomwe zimagwiritsidwa ntchito ngati zifukwa zochepetsera mwayi wa zolakwika zomwe zimapangidwira pakulemba selo lolakwika.
Pogwiritsa ntchito bokosi loyanjana la ntchito la LEFT
Mndandanda womwe uli pansipa ndi njira zomwe zingagwiritsidwe ntchito polojekiti ya LEFT ndi zifukwa zake mu selo C3 pogwiritsa ntchito bokosi la bokosi.
- Dinani pa selo C3 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za ntchitoyi zidzawonetsedwa;
- Dinani pa Fomu tab ya menyu yowonongeka;
- Sankhani Mawu kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi;
- Dinani pa LEFT mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
- Mu bokosi la bokosi, dinani pa Text line;
- Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog;
- Dinani pa Num_chars line;
- Dinani pa selo B9 mu tsamba lothandizira kuti mulowetse selolo;
- Dinani OK kuti mutsirize ntchitoyi ndi kubwerera ku tsamba la ntchito;
- Majambulo omwe amachokera m'malowa ayenera kuwonekera mu selo C3;
- Mukasindikiza pa selo C3 ntchito yonse = LEFT (A3, B9) ikuwonekera pa bar barolomu pamwamba pa tsamba.
Kuchokera Nambala ndi Ntchito LEFT
Monga momwe tawonetsera mzere wachisanu ndi chitatu chachitsanzo pamwambapa, ntchito ya LEFT ingagwiritsidwe ntchito kuchotsa chigawo cha deta yamtundu kuchokera ku nambala yambiri pogwiritsa ntchito ndondomeko zotchulidwa pamwambapa.
Vuto lokha ndiloti deta yochotsedwa imasinthidwa ndipo sangagwiritsidwe ntchito pakuwerengera ntchito zina - monga SUM ndi AVERAGE ntchito.
Njira imodzi yozungulira vuto ili ndigwiritsira ntchito VALUE ntchito kuti mutembenuzire malemba kukhala nambala monga momwe tawonedwera mzere 9 pamwambapa:
= VALUE (LEFT (B2, 6))
Njira yachiwiri ndigwiritsira ntchito phala lapadera kutembenuza malemba ku manambala .