01 ye 01
Excel's LEFT uye LEFTB Mabasa
Kana mashoko akakopizwa kana kutumirwa kuExcel, zvidhakwa zvisingabvumirwi marara dzimwe nguva zvinosanganiswa nemashoko akanaka.
Kana, pane dzimwe nguva apo chikamu bedzi chemashoko deta iri muchitokisi chinodikanwa - zvakadai sezita remunhu rokutanga asi kwete zita rekupedzisira.
Kune zviitiko zvakadai, Excel ine mabasa akawanda anogona kushandiswa kubvisa data isina kudiwa kubva kune vamwe vose. Iko basa raunoshandisa kunobva pane iyo yakanaka data iripo maererano nevanenge vasingadiwi muchitokisi.
- Kana iyo data yakanaka iri kurutivi rworudyi rwemashoko, shandisa RIGHT function kuti ibvise iyo.
- Kana iyo data yakanaka ine zvinyorwa zvisingadikanwi kumativi maviri acho, shandisa MID basa kuti ibvise.
- Kana data yakanaka iri kuruboshwe rwemashoko, shandisa basa re LEFT kuti ribudise.
NOKWADI vs. LEFTB
IEFT ne LEFTB zvinoshanda zvakasiyana chete mumitauro yavanotsigira .
CHITSAUKO ndechokuti mitauro inoshandisa imwe-byte yakagadzirirwa - boka iri rinosanganisira mitauro yakawanda yakafanana neChirungu nemitauro yose yekuEurope.
CHITSAUKO B ndechemitauro inoshandiswa kaviri-byte character set - inosanganisira chiJapane, chiChinese (chakareruka), chiChinese (Traditional), uye chiKorea.
Basa re LEFT neLeFTB Sangano neArguments
MuExpcel, syntax yebasa inoreva kurongeka kwebasa uye inosanganisira zita rebasa, mabheketi, uye nharo .
Mutsara webasa re LEFT ndewokuti:
= CHINHU (Nhamba, Num_chars)
Nharo dzebasa dzinoudza Excel kuti chii iyo inofanira kushandiswa mubasa uye kureba kwetambo kubudiswa.
Izwi rechirevo chebasa re LEFTB nderokuti:
= CHINHU (Nhamba, Num_bytes)
Nharo dzebasa dzinoudza Excel kuti chii iyo inofanira kushandiswa mubasa uye kureba kwetambo kubudiswa.
Nheyo - (inotarisirwa kuti LEFT ne LEFTB ) ivanyo rine data inoda
- nharo iyi inogona kuva sechiteteri chekero kune nzvimbo yedhesi mubasa rekushandura kana inogona kunge iri mavara chaiwo akaiswa muzvinyorwa zvinyorwa
Num_chars - (kusarudzwa kweLeFT ) inotsanangura nhamba yevanhu vari kuruboshwe rwechikwata chetambo kuti chichengetwe - mamwe mazita anobviswa.
Num_bytes - (kusarudzwa kweLeFTB ) inotsanangura nhamba yevarimi vari kuruboshwe rwechikwata chechikwata chekuchengetedzwa mumabheti - mamwe mavara anobviswa.
Notes:
- Kana Num_chars / Num_bytes haibvumirwi , kukosha kwehutano hwemhando 1 kunoratidzwa nemabasa - mutsara 4 mune muenzaniso;
- Kana Num_chars / Num_bytes yakakura kudarika urefu hwemavara , basa rinodzoka rose rutsamba rwonzi-mutsara 5 mune muenzaniso;
- Kana kukosha kweNumer_chars / Num_bytes kukakavara kwakaipa, basa rinodzorera #VALUE! kukanganisa kukosha - mutsara 6 wemufananidzo.
- Kana kukosha kweNumer_chars / Num_bytes Nhaurirano dzinoshandiswa pasina chinyorwa kana zvakaenzana ne zero, basa rinodzoka musina chinhu chisina mutsara-mutsara we 7 wechifananidzo apo Num_chars inotaura nezvechitsauko B13 chisina chinhu.
BASA ROKUSHANDISA Muenzaniso - Kuwedzera Dhikanhau Yakanaka kubva kune Zvakaipa
Muenzaniso uri mumufananidzo wepamusoro unoratidza nzira dzinoverengeka dzokushandisa basa re LEFT kubvisa nhamba chaiyo yevanyori kubva pane zvinyorwa zvinyorwa, kusanganisira kupinda mu data zvakananga semafungiro emabasa - rutsva 2 - uye kupinda muchikamu chezvinyorwa zvemashoko maviri - mutsara 3.
Sezvo zvinowanzova zvakanaka kupinda muchikamu chemaferensi nokuda kwemashoko panzvimbo pezvazviri chaiwo, mashoko ari pasi apa anonyora matanho anoshandiswa kupinda mu LEFT basa uye nharo dzayo muchitokisi C3 kuti abvise shoko rokuti Widgets kubva pane zvakanyorwa chinyorwa muchitokisi A3.
Dhiyabhorosi Dhiyabhorosi Dhiyabhorosi Dhiyabhorosi
Zvisarudzo zvekupinda mubasa uye zvarinotaura muchitokisi B1 zvinosanganisira:
- Kunyora basa rakakwana: = KUSA (A3.B9) muchikamu C3;
- Kusarudza basa uye nharo kushandisa sarudzo yebhokisi rebasa.
Kushandisa bhokisi rekugovera kupinda basa rinowanzoita kuti basa rive nyore sezvo bhokisi rebhokisi rinotarisira shanduro yebasa - kupinda muzita rebasa, maparasator emakasita, uye mabheketi munzvimbo dzakakodzera uye kuwanda.
Kutarisa paCheferensi dzeChechi
Hazvina mhosva kuti wakasarudzei kuti upinde mubasa rekushanda kwepafashiti, zvichida zvakanakisa kushandisa pfungwa uye chefa kuti uise chero yese uye zvese zvinyorwa zvinoshandiswa sezvikonzero kuti kuderedze mukana wekanganiso dzinokonzerwa nekunyora mune zvisina kururama sechitsetse.
Kushandisa Bhokisi reDhiyabhorosi reSefth Function
Zvinyorwa pasi apa ndezvikwiriso zvinoshandiswa kupinda muEFT basa uye nharo dzayo muchitokisi C3 uchishandisa basa rebhokisi rebhokisi.
- Dzvanya pachitokisi C3 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro yebasa icharatidzwa;
- Dzvanya paMafomu tab yebhoni yebhoni ;
- Sarudza Rugwaro kubva kubhoni kuti uzarure basa rinoyerera pasi;
- Dzvanya pa LEFT murugwaro kuti ubudise bhokisi rebasa rebasa;
- Mubhokisi rebhokisi, chengeta paIndaneti mutsara;
- Dzvanya pane sero A3 mune pepa rekushanda kuti uise iyo seferensi iri mubhokisi rebhokisi;
- Dzvanya pane Num_chars line;
- Dzvanyira pane sero B9 mubasa rekushandisa kuti uise iyo sero reference;
- Dzvanya OK kuti upedze basa uye dzokera kubheji rekushanda;
- Iyo yakabudiswa pane iyo Widgets inofanira kuonekwa muchitokisi C3;
- Paunenge uchinyora pachitseko C3 zvakakwana basa = LEFT (A3, B9) inowanikwa mubhairi yepamusoro pane pepa pepaji.
Kuchengeta Numeri neBASA REFT
Sezvinoratidzwa mumutsara humwechete wemuenzaniso wepamusoro, basa re LEFT rinogona kushandiswa kubvisa subset ye data yenhamba kubva kune nhamba refu uchishandisa matanho ari pamusoro apa.
Dambudziko rega nderokuti iyo yakabudiswa yedhiyabhorosi inoshandurirwa kunyoresa uye haigoni kushandiswa mukuverenga inosanganisira mamwe mabasa - akadai seSUM neAVERAGE mabasa.
Imwe nzira inotarisana nechinetso ichi ndoshandisa basa re VALUE kuti uchinje mashoko acho kuenhamba sezvinoratidzwa mumutsara 9 kumusoro:
= VALUE (KUSA (B2, 6))
Chinhu chechipiri ndechokushandisa pasa yakakosha yekushandura zvinyorwa kune nhamba .