Kusintha kwa kalata yoyamba kuchokera pansi mpaka ku Microsoft Excel

Nthaŵi zambiri, amafunikanso kuti kalata yoyamba mu sebulo la tebulo ikhale yaikulu. Ngati wogwiritsa ntchitoyo mwachindunji amalowa makalata ochepera m'munsi kulikonse kapena kukopera deta kuchokera ku gwero lina kupita ku Excel, momwe mawu onse adayambira ndi kalata yaying'ono, ndiye mutha kugwiritsa ntchito nthawi yochuluka kwambiri ndi khama kuti mubweretse maonekedwewo ku dziko lomwe mukufuna. Koma, mwinamwake Excel ili ndi zipangizo zapadera zomwe mungathe kuzichita motere? Inde, pulogalamuyi ili ndi ntchito yosinthira makalata ochepa kuti akhale ochuluka. Tiyeni tiwone momwe zimagwirira ntchito.

Ndondomeko yosinthira kalata yoyamba kukhala yaikulu

Simuyenera kuyembekezera kuti Excel ili ndi batani losiyana, podalira zomwe mungathe kutembenuza kalata yotsika pansi kukhala kalata yaikulu. Pachifukwa ichi, m'pofunikira kugwiritsa ntchito ntchito, ndi angapo nthawi yomweyo. Komabe, mulimonsemo, njirayi idzaposa kulipiritsa nthawi yomwe mungafunike kusintha kusintha deta.

Njira 1: Bwerezerani kalata yoyamba mu selo ndi likulu

Kuti athetse vutoli, ntchito yaikulu imagwiritsidwa ntchito. Pewani, komanso ntchito zamakhalidwe zoyambirira ndi zachiwiri UPPER ndi MALAMULO.

• Ntchito Pewani amalowetsa chikhalidwe chimodzi kapena gawo la chingwe ndi wina, malingana ndi ziganizo zanenedwa;
• UPPER - zimapangitsa makalata kukhala ovuta, ndiko kuti, ochulukitsa, zomwe ndi zomwe timafunikira;
• MALAMULO - kubwezeretsa chiwerengero cha zilembo zapadera pa selo.

Izi ndizo, pogwiritsa ntchito ntchitoyi, pogwiritsa ntchito MALAMULO Tibwereranso kalata yoyamba ku selo yeniyeniyo pogwiritsira ntchito woyendetsa UPPER likhale likulu ndikugwira ntchito Pewani lembani kalata yapansi ndi kalata yosavuta.

Chiwonetsero chachikulu cha opaleshoniyi chidzakhala motere:

= REPLACE (chakale_kulemba; kuyambira_kuyamba; nambala_masamba; PROPISN (LEFT (malemba; nambala_nambala)))

Koma ndi bwino kuganizira zonsezi ndi chitsanzo cha konkire. Kotero, ife tiri ndi tebulo yodzaza kumene mawu onse alembedwa ndi kalata yaying'ono. Tiyenera kupanga khalidwe loyamba mu selo iliyonse ndi maina otsiriza omwe ali nawo. Selo yoyamba ndi dzina lomalizira ili ndi ndondomeko B4.

1. Mu danga lililonse laulere la pepala ili kapena pa pepala lina lembani ndondomeko zotsatirazi:

   = REPLACE (B4; 1; 1; PROPISN (LEFT (B4; 1)))



2. Kuti mugwirizane ndi deta ndikuwonani zotsatira, panizani batani lolowani mukibodi. Monga mukuonera, tsopano mu selo mawu oyambirira akuyamba ndi kalata yaikulu.



3. Timakhala chithunzithunzi m'makona otsika kumanzere a selo ndi ndondomeko ndikugwiritsa ntchito chikhomo chodzaza chikhomo mu maselo apansi. Tiyenera kuwatsanzira molingana ndi malo omwe pansi, ndi maselo angati omwe ali ndi maina otsiriza omwe ali nawo tebulo lapachiyambi.



4. Monga momwe mukuonera, atapatsidwa kuti maulumikizidwewo ali ofanana, osati omveka, kukopera zomwe zinachitika ndi kusintha. Choncho, maselo apansi amasonyeza zomwe zili mu malo otsatirawa, komanso ndi kalata yaikulu. Tsopano tikufunika kuyika zotsatirazo mu tebulo lapachiyambi. Sankhani zamtunduwu ndi ma formula. Dinani botani lamanja la mouse ndipo sankhani chinthucho m'ndandanda "Kopani".



5. Pambuyo pake, sankhani maselo amtundu ndi mayina otchulidwa patebulo. Lembani mndandanda wa masewerawa powakweza batani lamanja la mbewa. Mu chipika "Njira Zowonjezera" sankhani chinthu "Makhalidwe"zomwe zimaperekedwa mwa mawonekedwe a chizindikiro ndi manambala.



6. Monga momwe mukuonera, patatha izi tikufunikira detayi italowetsedwa ku malo oyambirira a tebulo. Pachifukwa ichi, makalata otsika pansi m'mawu oyambirira a maselo adaloledwa ndi mphamvu. Tsopano, kuti musasokoneze mawonekedwe a pepala, muyenera kuchotsa maselo ndi maulendo. Ndikofunikira makamaka kuchotsa ngati mutasintha pa pepala limodzi. Sankhani ndondomeko yeniyeni, pindani pomwepo ndikuyimitsa kusankha mndandanda wamakono. "Chotsani ...".



7. Mu kanyumba kakang'ono ka bokosi komwe kapezeka, kanikeni kasinthasintha "Mzere". Timakanikiza batani "Chabwino".

Pambuyo pake, deta yowonjezera idzachotsedwa, ndipo tidzalandira zotsatira zomwe zinakwaniritsidwa: mu selo iliyonse ya tebulo, mawu oyambirira amayamba ndi kalata yaikulu.

Njira 2: Mawu aliwonse ndi kalata yaikulu

Koma pali zifukwa pamene kuli kofunika kupanga mawu oyamba mu selo, kuyambira ndi kalata yaikulu, koma kawirikawiri, mawu alionse. Kwa ichi, palinso ntchito yosiyana, ndipo ndi yosavuta kuposa yoyamba. Izi zimatchedwa PROPNACh. Mawu ake omasulira ndi osavuta:

= PROPNACH (adilesi ya selo)

Mu chitsanzo chathu, ntchito yake idzakhala motere.

1. Sankhani malo omasuka a pepala. Dinani pazithunzi "Ikani ntchito".



2. Mu ntchito ya wizara yomwe imatsegula, yang'anani PROPNACH. Kupeza dzina ili, lisankheni ndipo dinani pa batani. "Chabwino".



3. Fesholo yotsutsana ikutsegula. Ikani cholozera mmunda "Malembo". Sankhani selo yoyamba ndi dzina lomaliza mu tebulo la gwero. Pambuyo pa adiresi yake ikafika kumunda wawindo latsutso, timasindikiza batani "Chabwino".

   

   Pali njira ina popanda kuyamba Wachipangizo Wothandizira. Kuti tichite izi, tiyenera, monga momwe tinayambira kale, tilowetseni ntchito mu selo pamanja ndi kulembera makonzedwe a deta yapachiyambi. Pachifukwa ichi, zolowera izi ziwoneka ngati izi:

   = PROPNAC (B4)

   Ndiye mudzafunika kusindikiza batani Lowani.

   Kusankha njira inayake kumadalira kwathunthu kwa wosuta. Kwa ogwiritsa ntchito omwe sakhala akuzoloŵera kukumbukira njira zosiyanasiyana, mwachibadwa zimavuta kuchita ndi chithandizo cha Master of Functions. Panthawi imodzimodziyo, ena amakhulupirira kuti kulowa kolowera mofulumira kuli mofulumira kwambiri.

4. Mulimonse momwe mungasankhire, mu selo ndi ntchito tili ndi zotsatira zomwe tinkafunikira. Tsopano, mawu atsopano mu selo amayamba ndi kalata yaikulu. Mofanana ndi nthawi yotsiriza, lembani fomuyi kumaselo omwe ali pansipa.



5. Pambuyo pake, lembani zotsatirazo pogwiritsa ntchito makondomu.



6. Timayika deta kupyolera mu chinthucho "Makhalidwe" onetsani zosankha ku gome la gwero.



7. Chotsani malingaliro apakati kudzera mndandanda wamkati.



8. Muwindo latsopano, timatsimikiza kuchotsa mizere poika chosinthira ku malo oyenerera. Timakanikiza batani "Chabwino".

Pambuyo pake, tidzakhala ndi tebulo yosinthika yosasinthika, koma mau onse mu maselo osinthidwa tsopano adzalembedwa ndi kalata yaikulu.

Monga momwe mukuonera, ngakhale kuti kusintha kwa malembo ochepa kwambiri ku Excel kupyolera muyeso yapadera sizingatchulidwe koyambirira, komabe, ndi kosavuta komanso kosavuta kusiyana ndi kusintha malembawo, makamaka pamene pali ambiri. Zomwe zili pamwambapa sizikuteteza mphamvu ya wogwiritsa ntchito, komanso nthawi yamtengo wapatali. Choncho, ndizofunika kuti ogwiritsira ntchito nthawi zonse Excel angagwiritse ntchito zipangizozi kuntchito yawo.