Nthawi zambiri, chilembo choyamba pagome la tebulo chimayenera kukhala chapamwamba. Ngati wogwiritsa ntchito molakwika adalowa zilembo zotsika pena paliponse kapena kukopera mu data ya Excel kuchokera kwina komwe mawu onse amayamba ndi chilembo chochepa, ndiye kuti nthawi yochulukirapo ndi kulimbikira zingagwiritsidwe ntchito kubweretsa mawonekedwewo patebulo. Koma mwina Excel ili ndi zida zapadera zomwe zingapangire njira iyi? Zowonadi, pulogalamuyi ili ndi ntchito yosinthira zolemba zapamwamba kukhala zapamwamba. Tiyeni tiwone momwe imagwirira ntchito.
Njira yosinthira kalata yoyamba kukhala yapamwamba
Simuyenera kuyembekezera kuti Excel ili ndi batani losiyana, mwa kuwonekera pomwe mungasinthe zilembo zochepa kukhala kalata yayikulu. Kuti muchite izi, muyenera kugwiritsa ntchito ntchito, komanso zingapo nthawi imodzi. Komabe, mulimonsemo, njirayi imakhala yolipira ndalama zogulira nthawi zomwe zingafunikire kusintha pamalowo.
Njira 1: m'malo mwake lilembeni kalata yoyamba ndi zilembo zazikulu
Kuti muthane ndi vutoli, ntchito yayikulu imagwiritsidwa ntchito. KUSINTHA, komanso ntchito zochepetsedwa za dongosolo loyamba ndi lachiwiri CHITSANZO ndi LEVSIMV.
- Ntchito KUSINTHA amasintha mtundu umodzi kapena gawo la chingwe ndi ena, malinga ndi mfundo zomwe zaperekedwa;
- CHITSANZO - amapanga zilembo zazikulu, ndiko kuti, zilembo zazikulu, zomwe ndi zomwe tikufuna;
- LEVSIMV - imabweza nambala yomwe yatchulidwa m'selo.
Ndiye kuti, potengera dongosolo ili la ntchito, pogwiritsa ntchito LEVSIMV tidzabweza kalata yoyamba ku cell yomwe tikugwiritsa ntchito CHITSANZO pangani kukhala likulu kenako ndikugwira ntchito KUSINTHA sinthani mabokosi ang'ono ndi apamwamba.
Ma template onse a ntchitoyi adzaoneka motere:
= REPLACE (akale_mawu; Start_pos; kuchuluka kwa otchulidwa; CAPITAL (LEVSIMV (zolemba; chiwerengero cha zilembo))
Koma ndibwino kuganizira zonsezi ndi chitsanzo chotsimikizika. Chifukwa chake, tili ndi tebulo lomalizidwa momwe mawu onse amalembedwa ndi kalata yaying'ono. Tiyenera kupanga munthu woyamba mu selo iliyonse yemwe ali ndi mayina ochulukitsidwa. Selo loyamba lomwe lili ndi dzina lomaliza limakhala ndi zogwirizanitsa B4.
- Pamalo aliwonse aulemu a pepalali kapena pepala lina, lembani zotsatirazi:
= REPLACE (B4; 1; 1; KULITI (LEVISIM (B4; 1))) - Kuti musanthule deta ndikuwona zotsatira, dinani batani Lowani pa kiyibodi. Monga mukuwonera, tsopano mu cell mawu oyamba amayamba ndi zilembo zazikulu.
- Timakhala chidziwitso pakona yakumanzere ya foni ndi chilinganizo ndipo timagwiritsa ntchito cholemba chodzaza kutengera chilinganizo ku maselo apansi. Tiyenera kuzikopera monga kuchuluka kwa maselo okhala ndi mayina omaliza ali ndi kapangidwe kake.
- Monga mukuwonera, poganiza kuti maulalo mu formula ndi achibale, osati amtheradi, kukopera kunachitika ndi kusintha. Chifukwa chake, m'maselo am'munsi zomwe zili m'malo otsatirawa adawonetsedwa, komanso ndi zilembo zazikulu. Tsopano tikufunika kuyika zotsatira mu tebulo la magwero. Sankhani masanjidwe osiyanasiyana. Timadina ndikusankha chinthucho menyu Copy.
- Pambuyo pake, sankhani magwero omwe ali ndi mayina omaliza pa tebulo. Timayitanitsa menyu wanthawi yonse ndikudina batani lakumanja. Mu block Ikani Zosankha sankhani "Makhalidwe", yomwe imawonetsedwa ngati chithunzi ndi manambala.
- Monga mukuwonera, zitatha izi deta yomwe timafunikira idayikidwira pazoyambira patebulopo. Nthawi yomweyo, zilembo zapansi m'mawu oyamba a maselo adasinthidwa ndi topset. Tsopano, kuti musawononge mawonekedwe a pepalalo, muyenera kufufuta maselo ndi mawonekedwe. Ndikofunikira kwambiri kuchotsa ngati mutasinthira pepala limodzi. Sankhani mtundu wotchulidwa, dinani kumanja ndipo menyu muzakakambirana, siyani kusankha pa chinthucho Chotsani ... ".
- Mukabokosi kakang'ono kamene kamawonekera, ikani kusintha kwa "Mzere". Dinani batani "Zabwino".
Zitatha izi, zowonjezera ziwonetseredwa, ndipo tidzapeza zomwe tidakwanitsa: mu khungu lililonse la tebulo, mawu oyamba amayamba ndi zilembo zazikulu.
Njira 2: gwiritsani ntchito liwu lililonse
Koma pali nthawi zina pamene mufunika kuti musangopanga liwu loyamba m'chipindacho, kuyambira ndi dzina lalikulu, koma ambiri, liwu lililonse. Palinso ntchito yina yosiyananso ndi izi, ndizosavuta kwambiri kuposa yoyamba. Ntchito iyi imatchedwa PROPNACH. Syntax yake ndi yosavuta:
= EXTRACT (cell_address)
Mu zitsanzo zathu, kugwiritsidwa ntchito kwake kumawoneka motere.
- Sankhani malo a pepala. Dinani pachizindikiro "Ikani ntchito".
- Mu Wizard Wogwira Ntchito watsegulidwa, yang'anani PROPNACH. Popeza mwapeza dzinali, sankhani ndikudina batani "Zabwino".
- Windo la mkangano likutseguka. Ikani wolemba m'munda "Zolemba". Sankhani foni yoyamba ndi dzina lomaliza pagulu la magwero. Pambuyo adilesi yake ali m'munda wa zenera la mikangano, dinani batani "Zabwino".
Pali njira inanso osayambitsa Wizard wa Ntchito. Kuti tichite izi, tiyenera, monga momwe tinachitira kale, kuti tizilowa mu chipinda chamanja ndi kujambula zolumikizira za zomwe zikuchokera. Pankhaniyi, kulowetsaku kumawoneka motere:
= SIGNAL (B4)Kenako muyenera kukanikiza batani Lowani.
Kusankhidwa kwa njira inayake kuli konse kwa wogwiritsa ntchito. Kwa ogwiritsa ntchito omwe sazigwiritsa ntchito ndikusunga machitidwe ambiri pamitu yawo, ndizosavuta kuchitapo kanthu mothandizidwa ndi Wizard Yogwira Ntchito. Nthawi yomweyo, ena amakhulupirira kuti kuwongolera kwa operekera pamanja kumathamanga kwambiri.
- Njira iliyonse yomwe idasankhidwa, mu cell momwe timagwirira ntchito timapeza zomwe timafunikira. Tsopano liwu lililonse latsopano m'selo limayamba ndi zilembo zazikulu. Monga nthawi yotsiriza, koperani formula ku maselo pansipa.
- Pambuyo pake, koperani zotsatila pogwiritsa ntchito menyu yankhaniyo.
- Ikani zidziwitso kudzera pazinthuzo "Makhalidwe" ikani zosankha mu gwero la magwero.
- Chotsani mfundo zapakati pa menyu.
- Pazenera latsopano, tsimikizirani kufufutidwa kwa mizere ndikukhazikitsa kusintha kwa malo oyenera. Kanikizani batani "Zabwino".
Pambuyo pake, tidzapeza gwero lazomwe sizinasinthidwe, koma mawu onse omwe ali mu maselo omwe adasindikizidwa ndiomwe tsopano azilembedwa ndi zilembo zazikulu.
Monga mukuwonera, ngakhale kuti kusintha kwamitundu yayikulu mpaka zilembo zazikulu ku Excel kudzera munjira yapadera sikungatchulidwe njira zoyambira, komabe, ndizosavuta komanso kosavuta kuposa kusintha zilembo pamanja, makamaka pakakhala zambiri. Ma algorithm omwe ali pamwambapa samapulumutsa mphamvu zokha za wogwiritsa ntchito, komanso zofunikira kwambiri - nthawi. Chifukwa chake, ndikofunikira kuti wogwiritsa ntchito Excel nthawi zonse azitha kugwiritsa ntchito zida izi pantchito yawo.
