01 ye 01
Excel MID uye MIDB Mabasa
Kana mashoko akakopizwa kana kutumirwa kuExcel, zvidhakwa zvisingabvumirwi marara dzimwe nguva zvinosanganiswa nemashoko akanaka.
Kana kuti, pane dzimwe nguva apo chikamu chemashoko akaiswa 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 yakanaka yedhesi, kana kuti ichienda kune iyo yekuchengetedzwa, iri kurudyi rwe data, shandisa RIGHT function kuti ibvise iyo.
- Kana chikamu chiri kurutivi rworuboshwe rwemashoko, shandisa basa re LEFT kuti ribvise.
- Kana iyo yakasvibirira ine zvinyorwa zvisingadikanwi kumativi maviri acho, shandisa MID kana kuti MIDB mabasa kuti ibvise iyo.
MID vs. vs. MIDB
Iyo MID uye MIDB mabasa zvinopesana chete mumitauro yavanotsigira.
MID ndiyo yemitauro inoshandisa imwe-byte yakagadzirirwa - boka iri rinosanganisira mitauro yakawanda yakadai seChirungu nemitauro yose yekuEurope.
MIDB ndeyemitauro inoshandiswa kaviri-byte character set - inosanganisira chiJapane, chiChinese (Chinojekeswa), Chinese (Traditional), uye Korean.
Iyo MID uye MIDB Function Syntax uye Arguments
MuExpcel, syntax yebasa inoreva kurongeka kwebasa uye inosanganisira zita rebasa, mabheketi, uye nharo .
Izwi rechiito che MID rinoshanda nderekuti:
= MIDI (Nyaya, Start_num, Num_chars)
Izwi rechirevo cheMDCB ndechekuti:
= MIDB (Magwaro, Start_num, Num_bytes)
Izvozvi nharo dzinoudza Excel
- iyo inoshandiswa sei kuti ishandiswe mubasa racho;
- nzvimbo yekutanga yenhau yakanaka kana kuti iyo inofanira kubudiswa;
- kureba kwemukoko.
Mhemberero - (inoda kuti MID uye MIDB ishande) basa rakanyora rine data inoda
- nharo iyi inogona kunge iri chinyorwa chaiyo kana sechitinho chetare pane nzvimbo yedhesi mubasa rekushanda - mitsetse 2 ne3 mumufananidzo uri pamusoro.
Start_num - (inoda kuti MID uye MIDB ishande) inotsanangura unhu hwokutanga kubva kuruboshwe rwechipiri kuti uchengeterwe.
Num_chars - (inotarisirwa kuti MID basa) inotsanangura nhamba yevanyori kusvika kurudyi kweKutanga_no kuchengetwa.
Num_bytes (inotarisirwa kuti iite MIDB ) inotsanangura nhamba yevarimi - mumagetsi - kurudyi kweChitsuwa_kuti ichengetwe.
Notes:
Kana Start_num yakakura kudarika urefu hwemashoko akabatwa, MID / MIDB inodzorera chinhu chisina chigadziko-rutsara 4 rwechifananidzo, apo Start_num yakaenzana ne14, uye zvinyorwa zvinyorwa zvinongoda 13 chete marefu.
Kana Start_num iri pasi pe1 kana Num_chars / Num_bytes haina kunaka MID / MIDB basa rinodzorera #VALUE! kukanganisa kukosha - mutsara 6 wemufananidzo, apo Start_num yakaenzana ne1.
Kana Num_chars / Num_bytes inodzokorora seki isina chinhu kana yakasarudzwa kusvika zero, MID / MIDB inodzorera chinhu chisina chinhu-mutsara we 7 wemufananidzo, uko Num_chars inoratidzira bhokisi risina chinhu B13.
MID Kushanda Muenzaniso - Kubudisa Mashoko Akanaka Kubva Zvakaipa
Muenzaniso uri mumufananidzo uri pamusoro apa unoratidza nzira dzinoverengeka dzokushandisa MID basa kuti abvise nhamba yakasiyana yevanyori kubva pane zvinyorwa chinyorwa, kusanganisira kuisa data zvakananga semafungiro emabasa - rutsva 2 - uye kupinda muchikamu chezvinyorwa zvese nhatu nharo - mutsara 5.
Sezvo zvichinyanya kukosha kupinda muchitokisi zvinyorwa nekuda kwemashoko pane zvayo chaiyo, mashoko ari pasi apa anonyora matanho anoshandiswa kupinda mu MID basa uye nharo dzaro muchikamu cheC5.
Bhokisi reDI Rinobata Dhiyabhorosi
Zvisarudzo zvekupinda mubasa uye zvarinotaura muchitokisi C5 zvinosanganisira:
- Kunyora basa rakakwana: = MID (A3, B11, B12) muchitokisi C5.
- 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 reDI reKushandura
- Dzvanya pachitokisi C1 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 MID mumutsetse kuti uburise hurukuro yebhokisi rebasa;
- Mubhokisi rebhokisi, chengetedza paIndaneti mutsara mubhokisi rebhokisi;
- Dzvanya pane sero A5 mune pepa rekushanda kuti uise iyi sereferensi seThe Text argument;
- Dzvanya paNot_numurongo
- Dzvanya pane sero B11 mune pepa rekushanda kuti uise iyi seferensi yekero;
- Dzvanya pane Num_chars line;
- Dzvanyira pane sero B12 mune pepa rekushanda kuti uite iyi seferensi yekare;
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi;
- Iko yakabudiswa pasi pefaira # 6 inofanira kuonekwa muchitokisi C5;
- Paunenge uchinyora pachitsime C5 yakakwana basa = MID (A3, B11, B12) inowanikwa mubhadha yepamusoro pane pepa pepaji.
Kubvisa Numeri neMAS Function
Sezvinoratidzwa mumutsara masere emuenzaniso wepamusoro, MID inoshanda inogona kushandiswa kubvisa subset ye data yenhamba kubva kune imwe nhamba 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 (MID (A8,5,3))
Chinhu chechipiri ndechokushandisa pasa yakakosha yekushandura zvinyorwa kune nhamba .