Momwe mungachotsere zosweka pamzere mu Excel 2010, 2013, 2016 zolemba - sitepe ndi sitepe malangizo

Nkhaniyi ikufotokoza momwe mungachotsere kukulunga mizere (kubwerera pangolo kapena kuswa mzere) muzolemba za Excel. Kuphatikiza apo, apa mupeza zambiri zamomwe mungasinthire ndi zilembo zina. Njira zonse ndizoyenera kumasulira kwa Excel 2003-2013 ndi 2016.

Zifukwa za maonekedwe a mzere wosweka mu chikalata ndizosiyana. Nthawi zambiri zimachitika mukakopera zambiri patsamba, wogwiritsa ntchito wina akakupatsani buku lomaliza la Excel, kapena ngati muyambitsa izi nokha podina makiyi a Alt + Enter.

Chifukwa chake, nthawi zina chifukwa cha kusweka kwa mzere kumakhala kovuta kupeza mawuwo, ndipo zomwe zili mgululi zimawoneka ngati zonyozeka. Ndicho chifukwa chake muyenera kuonetsetsa kuti deta yonse ili pamzere umodzi. Njirazi ndizosavuta kugwiritsa ntchito. Gwiritsani ntchito yomwe mumakonda kwambiri:

• Chotsani pamanja nthawi yoduka mizere kuti data yomwe ili patsamba loyamba ibwerere mwakale.
• Chotsani zoduka pamzere ndi ma formula kuti muyambe kukonza zambiri zovuta. 
• Gwiritsani ntchito VBA macro. 
• Chotsani zoduka mizere ndi Text Toolkit.

Chonde dziwani kuti mawu oyambilira akuti “Kubwerera kwa Carriage” ndi “Line feed” adagwiritsidwa ntchito popanga mataipi. Komanso, iwo ankatanthauza 2 zochita zosiyanasiyana. Zambiri za izi zitha kupezeka pazidziwitso zilizonse.

Makompyuta aumwini ndi mapulogalamu osintha malemba adapangidwa mozungulira mawonekedwe a makina olembera. Ndicho chifukwa chake, kusonyeza kusweka kwa mzere, pali zilembo za 2 zosasindikizidwa: "Cariage return" (kapena CR, code 13 pa tebulo la ASCII) ndi "Line feed" (LF, code 10 mu tebulo la ASCII). Pa Windows, zilembo za CR+LF zimagwiritsidwa ntchito palimodzi, koma pa *NIX, LF yokha ingagwiritsidwe ntchito.

chisamaliro: Excel ili ndi njira zonse ziwiri. Mukatumiza deta kuchokera kumafayilo a .txt kapena .csv, kuphatikiza zilembo za CR+LF zitha kugwiritsidwa ntchito. Mukamagwiritsa ntchito kuphatikiza kwa Alt + Enter, kuphwanya kwa mzere (LF) kudzagwiritsidwa ntchito. Zomwezo zidzachitikanso mukakonza fayilo yolandilidwa kuchokera kwa munthu yemwe akugwira ntchito pa *Nix system.

Chotsani mzere wopuma pamanja

ubwino: iyi ndi njira yophweka.

kuipa: palibe zina zowonjezera. 

Tsatirani izi:

1. Sankhani maselo omwe mukufuna kuchotsa kapena kusintha mzere wopuma. 

2. Dinani Ctrl + H kuti mutsegule ntchitoyi “Pezani ndi Kusintha”. 
3. Mu "Pezani" lembani Ctrl + J, pambuyo pake kadontho kakang'ono kadzawoneka mmenemo. 
4. M'munda"Wasinthidwa ndi” lowetsani munthu aliyense kuti alowe m'malo opuma mzere. Mutha kulowa mudanga kuti mawu omwe ali m'maselo asaphatikizidwe. Ngati mukufuna kuchotsa zoduka pamzere, musalowe chilichonse mu "Wasinthidwa ndi”.

5. Dinani batani “Sinthani Zonse”. 

Chotsani zoduka mizere ndi ma fomula a Excel

ubwino: ndizotheka kugwiritsa ntchito mndandanda wazinthu zopangira zovuta za data. Mwachitsanzo, mukhoza kuchotsa mizere yopuma ndikuchotsa malo owonjezera. 

Komanso, mungafunike kuchotsa chokulungacho kuti mugwire ntchito ndi deta ngati mkangano wantchito.

kuipa: muyenera kupanga ndime yowonjezera ndikuchita zinthu zothandizira.

1. Onjezani ndime yowonjezera kumanja. Tchulani "mzere 1".
2. Mu selo yoyamba ya ndime iyi (C2), lowetsani chilinganizo chomwe chidzachotsa kusweka kwa mzere. M'munsimu muli mitundu yosiyanasiyana yomwe ili yoyenera pazochitika zonse: 

• Zoyenera pa Windows ndi Unix machitidwe: 

=MALOWA(MALOWA(B2,CHAR(13),»»),CHAR(10),»»)

• Fomula iyi ikulolani kuti musinthe mzere wopuma ndi munthu wina. Pachifukwa ichi, deta sidzaphatikizidwa pamodzi, ndipo malo osafunikira sangawonekere: 

=KUCHEZA(M'MALOWA(B2,CHAR(13),»»),CHAR(10),», «)

• Ngati mukufuna kuchotsa zilembo zonse zosasindikizidwa, kuphatikizapo zoduka mizere, ndondomekoyi idzakhala yothandiza:

= CHOYERA(B2)

3. Fananizani chifanizirocho m'maselo ena agawoli. 
4. Ngati ndi kotheka, zomwe zachokera pamndandanda woyambirira zitha kusinthidwa ndi zotsatira zomaliza:

• Sankhani maselo onse omwe ali mugawo C ndikusindikiza Ctrl + C kuti mukopere deta.
• Tsopano sankhani selo B2 ndikusindikiza Shift + F10 ndiyeno V.
• Chotsani ndime yowonjezera.

VBA macro kuchotsa zopuma mizere

ubwino: Akapangidwa, macro atha kugwiritsidwanso ntchito m'buku lililonse lantchito.

kuipa: Ndikofunikira kumvetsetsa VBA. 

Macro imagwira ntchito yabwino yochotsa zoduka m'maselo onse patsamba logwira ntchito. 

Chotsani mzere wodutsa ndi Text Toolkit

Ngati mugwiritsa ntchito Text Toolkit kapena Ultimate Suite ya Excel, simudzasowa kuwononga nthawi pazinthu zilizonse. 

Zomwe muyenera kuchita:

1. Sankhani maselo amene mukufuna kuchotsa mzere yopuma.
2. Pa riboni ya Excel, pitani ku tabu "Ablebits Data", kenako ku kusankha "Text Group” ndipo dinani batani "Sinthani" .

3. Pa gulu "Sinthani Malemba" sankhani batani la wailesi"Sinthani kuthyoka kwa mzere kukhala “, lowani "M'malo" m'munda ndikudina "Sinthani".

Apa, mzere uliwonse wosweka umasinthidwa ndi danga, kotero muyenera kuyika cholozera cha mbewa m'munda ndikusindikiza Enter key.

Mukamagwiritsa ntchito njirazi, mupeza tebulo lomwe lili ndi deta yokonzedwa bwino.