Dzidza Sei Kubvisa Zvimwe Zvimwe Kubva ku Excel

Ita shanduro yako yakaita seyakanaka uye yakanaka

Kana dhidhi data ichibudiswa kana kunyoreswa mune imwe nzvimbo ye Excel worksheet dzimwe nzvimbo dzimwe nguva ingabatanidzwa pamwe chete nemashoko ekunyora. Basa reTIMI rinogona kushandiswa kubvisa nzvimbo dzinowanikwa kubva pakati pemashoko kana zvimwe zvinyorwa zvemashoko mu Excel - sezvinoratidzwa muchitokisi A6 mumufananidzo uri pamusoro.

Basa racho rinoda, zvisinei, kuti zvinyorwa zvepakutanga zvichange zviripo pane imwe nzvimbo zvimwe basa racho rinopera.

Kazhinji, zvakanakisisa kuti uchengetedze data yepakutanga. Inogona kuvanzwa kana iri pane imwe pepaji yepamusoro kuti uchengetedze kunze kwenzira.

Kushandisa Maitiro Okutevedzera Nebasa re TRIM

Kana, kunyange zvakadaro, zvinyorwa zvepakutanga hazvisati zvichishandiswa, Excel's paste mararamiro anosarudza inoita kuti zvive nyore kuchengeta rugwaro rwakagadziridzwa paunenge uchibvisa data yepakutanga uye basa re TRIM.

Kuti izvi zvinoshanda sei, sezvinotsanangurwa pasi apa, iyo iyo mitemo inoshandiswa kubatanidza basa re TRIM rinodzoka shure pamusoro pe data yepakutanga kana kune imwe nzvimbo inenge yadiwa.

Iko Syntax Yemashandiro eTIMS uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Izwi rechiito che TRIM ndiro:

= TRIM (Nyaya)

Nyora - iyo data yaunoda kubvisa nzvimbo kubva. Iyi nharo inogona kuva:

• iyo chaiyo data yakapoteredzwa muzvinyorwa zvinyorwa.
• sero rinotarisa kune nzvimbo yemashoko ekunyora mubhuku rekushanda.

TRIM Runoshanda Muenzaniso

Mumufananidzo wepamusoro, basa reTIM - riri muchitokisi A6 - rinoshandiswa kubvisa nzvimbo dzakawanda kubva mberi uye kubva pakati pezvinyorwa zvese zviri muchitokisi A4 chebasa rekushanda.

Basa racho rinowanikwa muA6 rinonyorwa uye rakatevedzwa - kushandiswa kwemaitiro - kudzokera muchikamu cheA4. Kuita saizvozvo kunongedza kopi chaiyo yezvinhu zviri muA6 muchitokisi A4 asi pasina TRIM basa.

Danho rekupedzisira raizove kubvisa basa re TRIM muchitokisi A6 richisiya kungodhindwa kwemashoko deta muchitokisi A4.

Kupinda Basa re TRIM

Zvisarudzo zvekupinda mubasa uye nharo yaro inosanganisira:

1. Kunyora basa rakakwana: = TRIM (A4) muchitokisi A6.
2. Kusarudza basa uye mazano aro uchishandisa TRIM basa dialog box.

Nhanho dziri pasi dzinoshandisa TRIM basa dialog box kuti uise basa iri muchikamu cheA6 chebasa.

1. Dzvanya pachitokisi A6 kuti uite sero rinoshanda - iyi ndiyo iyo basa richawanikwa.
2. Dzvanya paMafomu yebhu yebhoni yebhoni .
3. Sarudza Rugwaro kubva kubhoni kuti uzarure basa rinoderera pasi.
4. Dzvanya pa TRIM mumutsara kuti uunze bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi, chengeta paMagwaro .
6. Dzvanya pane sero A4 mune pepa rekushandisa kuti uise iyo sero reference seyo basa's Text argument.
7. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
8. Mutsara wehurukuro Bvisa Zvimwe Zvikwata kubva Pakati Pemazwi kana Text zvinofanira kuonekwa muchitsetse A6, asi nechikamu chimwe bedzi pakati pezwi rimwe nerimwe.
9. Kana iwe ukatora pane cell A6 basa rakakwana = TRIM (A4) inowanikwa mubhairi yepamusoro pane pepa pepaji.

Kupfurikidza Pamusoro Pokutanga Dheyo Nekutevedzera Maitiro

Matanho ekubvisa data yepakutanga uye pakupedzisira TRIM basa muchitokisi A6:

1. Dzvanya pane sero A6.
2. Dhinda maki eCtrl + c pabhobhoyo kana tora paKopi bhokisi paImba yebhu yebhoni - data yakasarudzwa ichakomberedzwa neMarching Ants.
3. Dzvanya pane sero A4 - nzvimbo ye data yepakutanga.
4. Dzvanya pamutsara muduku uri pasi pebhokisi reKutani paImba yebhu yebhoni kuitira kuti uzarure Zvinyorwa Zvinyorwa pasi.
5. Dzvanya paZvirevo zveZvirevo mumadonho ekuderera - sezvinoratidzwa mumufananidzo uri pamusoro - kunyora mharidzo yakagadziridzwa kuti idzoke muchitokisi A4.
6. Bvisa basa re TRIM muchitokisi A6 - kusiya chete data yakagadzirirwa muchitokisi chepakutanga.

Kana iyo TRIM Inoshanda Isingashande

Pakombiyuta, nzvimbo iri pakati pemashoko haisi chinhu chisina chinhu asi chimiro, uye, kana chichitenda kana kwete, pane imwe nzvimbo yakasiyana yemunhu.

Basa re TRIM harifaniri kubvisa mashizha ose epakati. Kunyanya, imwe inowanzoshandiswa space character iyo TRIM haizobvisi iyo isiri kuputsa nzvimbo () inoshandiswa mumapeji ewebhu.

Kana iwe une webpage yedhadha nedzimwe nzvimbo iyo TRIM isingagoni kubvisa, edza iyi TRIM basa imwe nzira inogona kugadzirisa dambudziko.