01 ye 02
Google Spreadsheets'TRIM Basa
Apo deta deta inotengeswa kana kunyoreswa mune imwe nzvimbo yeGoogle Spreadsheet dzimwe nzvimbo dzinowanikwa pamwe chete nedheteti deta.
Pakombiyuta, nzvimbo iri pakati pemashoko haisi nzvimbo isina chinhu asi unhu, uye, izvi zvinyorwa zvinogona kukanganisa mashandiro ekushandiswa kweshoko - seCONCATENATE basa rinobatanidza masero akawanda e data munzvimbo imwe.
Panzvimbo pokunyora manyore data kuti ubvise nzvimbo dzisingadiwi, shandisa basa re TRIM kubvisa nzvimbo dzakawanda kubva pakati pemashoko kana mamwe mashoko emagwaro .
Iko Syntax Yemashandiro eTIMS uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Izwi rechiito che TRIM ndiro:
= TRIM (zvinyorwa)
Nharo yebasa re TRIM ndeyokuti:
zvinyorwa - data yaunoda kubvisa nzvimbo kubva. Izvi zvinogona kuva:
- iyo chaiyo data inogadziriswa
- sero rinotarisa kune nzvimbo yemashoko ekunyora mubhuku rekushanda
Cherechedza: Kana iyo chaiyo inodonhedzwa inoshandiswa semashoko ekunyora , inofanira kuvharwa mumagwaro ekudzokorora, akadai se:
= TRIM ("Bvisa nzvimbo dzakawedzerwa")Kuchenesa Chekutanga Data neKunyanya Kukosha
Kana tsanangudzo yesero kune nzvimbo yedhesi inofanira kugadziriswa inoshandiswa semashoko ekunyora , basa harigoni kugara mumusero iwoyo se data yepakutanga.
Somugumisiro, mutsara unobatwa pakutanga unofanirwa kuramba uri munzvimbo yawo yepakutanga mune pepa rekushanda. Izvi zvinogona kuunza matambudziko kana pane yakawanda yemhando yakagadzirirwa kana kana data yepakutanga iri munzvimbo inokosha yebasa.
Imwe nzira inopoteredza dambudziko iri nderokushandisa Nyaya Yakafanira kuti ichengetedze mararamiro mushure mekunge data yakadhindwa. Izvi zvinoreva kuti migumisiro yebasa reTIMI inogona kuderedzwa pamusoro pe data yepakutanga uye basa re TRIM rinobviswa.
Muenzaniso: Bvisa Zvikwata Zvimwe Nebasa reTIM
Muenzaniso uyu unosanganisira matanho anodiwa kuti:
- bvisa dzimwe nzvimbo kubva pakati pemitsara mitatu yemashoko mumitsara 1 kusvika ku3 mubasa rekushanda - sezvinoratidzwa mumufananidzo uri pamusoro;
- deta yakagadzirirwa ichakopiwa uye wozonyanya kushandiswa yakashandiswa kutora dhenda yepakutanga mumitsara mitatu yokutanga;
- iyo mitambo yeTIM inoshandiswa kubvisa nzvimbo dzakawedzerwa ichabva yabviswa.
Kupinda Tutorial Data
- Vhura Google Spreadsheet ine zvinyorwa zvine nzvimbo dzakawanda dzinoda kubviswa, kana kopi uye unyore mitsetse iri pasi apa mumasero A1 kusvika kuA3 mune pepa Row Row 1 rweDhipatimendi neZvamwe Zvimwe Row Row 2 rweDheta neZvamwe Zvikamu Row 3 yeData ne Zvimwe nzvimbo
02 of 02
Kupinda Basa re TRIM
Kupinda Basa re TRIM
Google Spreadsheets haishandisi dialog boxes kuti iite nharo dzebasa sezvazvinogona kuwanikwa mu Excel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.
- Kana uri kushandisa data yako pachako, chengetedza pane chese re worksheet apo iwe unoda kuti deta yakagadzirirwa igare
- kana uri kutevera muenzaniso uyu, sarudza pane cell A6 kuti iite iyo inoshandiswa seyero - iyi ndiyo iyo basa re TRIM richapinda uye apo mharidzo yakarongwa icharatidzwa
- Tora mufananidzo wakaenzana (=) uchitevedzwa nezita rebasa trim
- Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita emabasa anotanga netsamba T
- Apo zita rokuti TRIM rinowanikwa mubhokisi, chengetedza zita nezita rinoshandisa mouse kuti uise zita rebasa uye uzarure bhatikiti rakapinda muchikamu cheA6
Kupinda Basa reMabasa
Sezvakaratidzwa mumufananidzo uri pamusoro apa, nharo ye TRIM basa inopinda mushure mokuzaruka kwebhuka rakapoteredza.
- Dzvanya pane sero A1 mune pepa rekushanda kuti uise iyi seferensi yesero semashoko argument
- Dhinda pikicha inopinda mubhobhoyo kuti uise bhokisi rakapoteredza " ) " mushure mekushanda kwebasa uye kupedza basa
- Mutsara wekutumira kubva pachitokisi A1 inofanira kuonekwa muchitokisi A6, asi ine imwe chete nzvimbo pakati pezwi rimwe nerimwe
- Paunenge uchibvisa pane cell A6 zvakakwana basa = TRIM (A1) inowanikwa mubhairi yepamusoro pane pepa pepaji.
Kukopa Basa nekuzadza Mashekeri
Chigadziro chinoshandiswa chinoshandiswa kukodha basa re TRIM muchikamu cheA6 kusvika kumasero A7 neA8 kuitira kuti abvise nzvimbo dzakawedzerwa kubva mumitsetse yemashoko mumasero A2 neA3.
- Dzvanya pachitokisi A6 kuti uite sero rinoshanda
- Isai peinter mouse pamusana wekona mutsvuku muzasi kwekona yekona yechitanhatu A6 - iyo pointer ichachinja kune imwe chiratidzo " + "
- Dzvanya uye ubatisise ibhokisi reboshwe rebundu uye dhonzai kuzadza tsvimbo pasi kune cell A8
- Dzosera mutsara wemagetsi - masero A7 neA8 inofanira kuva nemiganhu yakagadzirirwa yemagwaro kubva kumasero A2 neA3 sezvaratidzwa mumufananidzo uri papeji 1
Kuchenesa Chekutanga Data neKunyanya Kukosha
Nhamba yepakutanga iri mumasero A1 kusvika kuA3 inogona kubviswa pasina kuchinja dambudziko rakagadziriswa uchishandisa pata yakakosha yezvinyorwa zvinosarudzwa kusarudza pamusoro pezvinyorwa zvepakutanga mumasero A1 kusvika kuA3.
Kutevera izvi, maitiro eTTIM mumasero A6 kusvika kuA8 achabviswa zvakare sezvo vasisina kudiwa.
#REF! zvikanganiso : kana kopi yenguva dzose uye kushandiswa kushandiswa kunoshandiswa panzvimbo pokunyanya kukoshesa , basa re TRIM richaiswa mumasero A1 kusvika kuA3, izvo zvichaita kuti #REF zhinji! zvikanganiso zvichiratidzwa mune pepa rekushanda.
- Simbisai masero A6 kusvika kuA8 mubasa rekushanda
- Kopa data iri mumasekeri uchishandisa Ctrl + C pane keyboard kana Hora> Kopi kubva kumamenyu - aya masero akafanirwa kurondedzerwa nemuganhu wakarongedzwa kuti aratidze kuti ari kunyorwa
- Dzvanya pane sero A1
- Dzvanya pane Hora> Nyora zvakakosha> Nyora maitiro chete mumamenu kuti unamatire chete zviitiko zveTIRIM mumasero A1 kusvika kuA3
- Mutsara wakagadzirwa unofanirwa kuvapo mumasero A1 kusvika kuA3 uye masero A6 kusvika A8
- Simbisai masero A6 kusvika kuA8 mubasa rekushanda
- Dhinda reChenesa kiyi pane keyboard kuti ubvise zvitatu zve TRIM
- Nhamba yakagadzirirwa inofanira kunge iripo mumasero A1 kusvika kuA3 mushure mokubvisa mabasa