Maitiro ekubvisa mitsara yekutyora muExcel 2010, 2013, 2016 zvinyorwa - nhanho nhanho mirairo

Ichi chinyorwa chinokurukura nzira dzaungabvisa nadzo kupeta mutsara (ngoro yekudzoka kana kutyora kwemutsara) muExcel zvinyorwa. Mukuwedzera, pano iwe unowana ruzivo rwekuti ungaitsiva sei nemamwe mavara. Nzira dzese dzakakodzera shanduro dzeExcel 2003-2013 uye 2016.

Zvikonzero zvekuonekwa kwekuputsika kwemutsara mugwaro zvakasiyana. Zvinowanzoitika kana uchikopa ruzivo kubva kune peji rewebhu, kana mumwe mushandisi achikupa rakapedzwa Excel bhuku rebasa, kana iwe ukamisa chimiro ichi pachako nekudzvanya makiyi eAlt + Enter.

Saka, dzimwe nguva nekuda kwekutyora kwemutsara zvinonetsa kuwana mutsara, uye zviri mukati mecolumn zvinotaridzika zvakapusa. Ndokusaka iwe uchifanira kuve nechokwadi chekuti data rese riri pamutsara mumwe. Nzira idzi dziri nyore kushandisa. Shandisa yaunoda zvakanyanya:

• Bvisa nemaoko kutyora kwemitsara kuunza data pabepa 1 kudzoka kune zvakajairika.
• Bvisa mitsara yekutyora nemafomula kuti utange imwe yakaoma ruzivo kugadzirisa. 
• Shandisa VBA macro. 
• Bvisa kutyora kwemitsara neText Toolkit.

Ndokumbira utarise kuti mazwi ekutanga ekuti "Carriage return" uye "Line feed" akashandiswa pakushanda pamatapureta. Mukuwedzera, ivo vakaratidza 2 zviito zvakasiyana. Rumwe ruzivo nezve izvi runogona kuwanikwa pane chero referensi rekushandisa.

Makomputa ega uye zvirongwa zvekugadzirisa zvinyorwa zvakagadziridzwa zvakatenderedza maitiro etapureta. Ndicho chikonzero, kuratidza kuputsa kwemutsara, kune 2 mavara asina kudhindwa: "Carriage return" (kana CR, code 13 muASCII table) uye "Line feed" (LF, code 10 mu ASCII table). PaWindows, mavara eCR+LF anoshandiswa pamwechete, asi pa *NIX, LF chete ndiyo inogona kushandiswa.

Attention: Excel ine zvese zvingasarudzwa. Paunenge uchiunza data kubva ku .txt kana .csv mafaira, CR+LF character musanganiswa ingango shandiswa. Paunenge uchishandisa iyo Alt + Enter musanganiswa, mitsara yekutyora chete (LF) ndiyo ichashandiswa. Zvimwe chete zvichaitika kana uchigadzirisa faira rakagamuchirwa kubva kumunhu anoshanda pa *Nix system yekushandisa.

Bvisa line break manually

Advantages: iyi ndiyo nzira iri nyore.

payakaipira: hapana mamwe maficha. 

Tevera matanho aya:

1. Sarudza maseru auri kuda kubvisa kana kutsiva mutsara wekutyora. 

2. Dzvanya Ctrl + H kuvhura basa “Tsvaga uye Tsiva”. 
3. Mu “Wana” nyora Ctrl + J, mushure mezvo dot duku richaonekwa mariri. 
4. Mumunda"Yakatsiviwa na” pinda chero chimiro kutsiva mutsara wekutyora. Unogona kupinda munzvimbo kuitira kuti mazwi ari mumasero asabatana. Kana iwe uchida kubvisa mitsara yekutyora, usaise chero chinhu mu "Yakatsiviwa na”.

5. Dhinda bhatani “Siva Zvose”. 

Bvisa mitsara yekutyora neExcel mafomula

Advantages: zvinokwanisika kushandisa ketani yemafomula ekugadzirisa data yakaoma. Semuenzaniso, unogona kubvisa mitsara yekutyora uye kubvisa dzimwe nzvimbo. 

Zvakare, ungangoda kubvisa kuputira kuti ushande nedata senharo yebasa.

payakaipira: iwe unofanirwa kugadzira imwe column uye kuita zviito zvekubatsira.

1. Wedzera imwe mbiru kurudyi. Ipe zita rekuti "mutsara wekutanga".
2. Musero rekutanga rekoramu iyi (C2), isa fomula inobvisa kutyora kwemutsara. Pazasi pane akasiyana masanganiswa akakodzera kune ese kesi: 

• Inokodzera Windows uye Unix masisitimu anoshanda: 

=CHINJA(CHINZVIMBO(B2,CHAR(13),»»),CHAR(10),»»)

• Iyi fomula inokutendera iwe kutsiva mutsara wekutyora nemumwe hunhu. Muchiitiko ichi, data haizosanganisike kuita imwe chete, uye nzvimbo dzisina kufanira hadzizoonekwe: 

=KUTAURA(SUBSTITUTE(B2,CHAR(13),»»),CHAR(10),», «)

• Kana iwe uchida kubvisa ese asingadhindike mavara, kusanganisira mitsara yekutyora, iyo fomula ichauya inobatsira:

=KUCHENA(B2)

3. Dudzira fomula mune mamwe maseru ekoramu. 
4. Kana zvichidikanwa, iyo data kubva kune yekutanga column inogona kutsiviwa nemhedzisiro yekupedzisira:

• Sarudza maseru ese mukoramu C uye tinya Ctrl + C kukopa iyo data.
• Zvino sarudza sero B2 wodzvanya Shift + F10 wobva wadzvanya V.
• Bvisa imwe column.

VBA macro kubvisa mitsara yekutyora

Advantages: Kana yangogadzirwa, macro inogona kushandiswa zvakare mune chero bhuku rebasa.

payakaipira: Zvakakosha kunzwisisa VBA. 

Iyo macro inoita basa rakakura rekubvisa mitsara yekutyora kubva kumaseru ese pane inoshanda shizha rebasa. 

Bvisa mutsara wekutyora neText Toolkit

Kana iwe ukashandisa Text Toolkit kana iyo Ultimate Suite yeExcel, haufanirwe kupedza nguva pane chero manipulations. 

Zvese zvaunoda kuti uite:

1. Sarudza maseru aunoda kubvisa mutsara wekutyora.
2. PaExcel ribhoni, enda kune tab "Ablebits Data", ipapo kune sarudzo "Text Group” uye tinya bhatani "Shandura" .

3. Papanera "Shandura Mavara" sarudza bhatani reredhiyo"Shandura kutyora kwemutsara kuve ", pinda "Kutsiva" mumunda uye tinya "Shandura".

Pano, mutsara wega wega unotsiviwa nenzvimbo, saka unofanirwa kuisa mutsara wembeva mumunda uye wodzvanya Enter kiyi.

Paunenge uchishandisa nzira idzi, iwe uchawana tafura ine data rakarongeka.