Zina mwa ntchito zosiyanasiyana mu Excel, zomwe zimagwiritsidwa ntchito pogwiritsa ntchito malemba, wogwiritsira ntchito amadziwika kuti angathe kuchita zachilendo. Kulondola. Ntchito yake ndikutenga nambala yeniyeni ya malemba kuchokera ku selo yeniyeni, kuwerengera kuchokera kumapeto. Tiyeni tiphunzire zowonjezereka za mwayi wa woyendetsa makinawa ndi zokhudzana ndi ziganizo zogwiritsira ntchito pogwiritsa ntchito zitsanzo zenizeni.
Wogwira ntchitoyo akulondola
Ntchito Kulondola imachokera ku zinthu zomwe zafotokozedwa pa pepala chiwerengero cha anthu omwe ali nawo kumanja komwe mtumiki mwiniyo akuwonetsera. Iwonetsa zotsatira zomaliza mu selo yomwe ili. Ntchitoyi ndi ya olemba ntchito a Excel. Mawu ake omasulira ndi awa:
= LOYO (malemba; chiwerengero cha anthu)
Monga mukuonera, ntchitoyi ili ndi zifukwa ziwiri zokha. Choyamba mwa izi "Malembo" Ikhoza kutenga mawonekedwe a malemba enieni ndi mafotokozedwe a chigawo cha pepala chomwe chili. Pachiyambi choyamba, wogwiritsira ntchitoyo adzatulutsa nambala yeniyeni ya malemba kuchokera m'mawu omasuliridwa monga kutsutsana. Pachiwiri chachiwiri, ntchitoyi "idzachotsa" zilembo zomwe zili mu selo lomwe latchulidwa.
Kukangana kwachiwiri ndi "Number of characters" - ndi mtengo wamtengo wapatali womwe umasonyezeratu kuti ndi angati omwe ali m'mawu olembedwa, kuwerengera kuchokera kumanja, ayenera kuwonetsedwa mu selo lolunjika. Mtsutso uwu ndi wosankha. Ngati muzisiya, zimayesedwa kuti ndizofanana ndi, ndiye kuti khalidwe lokhalo labwino kwambiri lawonetsedwa mu selo.
Chitsanzo cha ntchito
Tsopano tiyeni tikambirane kugwiritsa ntchito ntchitoyi Kulondola pachitsanzo chapadera.
Mwachitsanzo, tengani mndandanda wa antchito a malonda. Mu ndime yoyamba ya tebulo ili ndi mayina a antchito, pamodzi ndi manambala a foni. Timafunikira manambala awa pogwiritsa ntchito ntchitoyi Kulondola ikani mu gawo losiyana, limene limatchedwa "Nambala yafoni".
- Sankhani selo yoyamba yopanda kanthu. "Nambala yafoni". Dinani pazithunzi "Ikani ntchito"yomwe ili kumanzere kwa bar.
- Kusintha kwazenera kumachitika Oyang'anira ntchito. Pitani ku gawo "Malembo". Kuchokera pandandanda wa mayina, sankhani dzina "MUZIKHALA". Dinani pa batani. "Chabwino".
- Fayilo yotsutsana ndi otsogolera imatsegula Kulondola. Lili ndi minda iwiri yomwe ikugwirizana ndi zotsutsana za ntchito yowonjezedwa. Kumunda "Malembo" muyenera kufotokoza chiyanjano ku selo yoyamba ya chigawocho "Dzina"lomwe liri ndi dzina lomaliza la antchito ndi nambala ya foni. Adilesi ikhoza kufotokozedwa mwaulere, koma tidzakwanitsa. Ikani cholozera mmunda "Malembo"ndiyeno dinani batani lamanzere la selo m'seri yomwe maulumikizowo ayenera kulowa. Pambuyo pake, adiresi ikuwonetsedwa muzenera zotsutsana.
Kumunda "Number of characters" lowetsani nambala kuchokera ku kibodibodi "5". Ilo liri ndi zilembo zisanu za foni ya wogwira ntchito aliyense. Kuwonjezera apo, manambala onse a foni ali pamapeto a maselo. Potero, kuti tisonyeze iwo mosiyana, tifunika kuchotsa ku maselowa ndendende kasanu pamanja.
Pambuyo pa deta ili pamwambayi, dinani pa batani "Chabwino".
- Pambuyo pachitachi, nambala ya foni ya wogwira ntchitoyo yodziwika imachotsedwa mu selo yoyamba yosankhidwa. Zoonadi, kulowetsa ndondomeko yeniyeni kwa munthu aliyense m'ndandanda ndizochita masewera olimbitsa thupi, koma mukhoza kuzichita mofulumira, zomwe ndizokopera. Kuti muchite izi, ikani cholozeracho kumbali ya kumanja ya selo, yomwe ili ndi kalembedwe Kulondola. Pankhaniyi, mtolowo umatembenuzidwa kukhala chizindikiro chodzaza ndi mawonekedwe a mtanda wawung'ono. Gwiritsani batani lamanzere lachitsulo ndikukoka khola mpaka kumapeto kwa tebulo.
- Tsopano mzere wonsewo "Nambala yafoni" wodzazidwa ndi mfundo zofanana kuchokera pazomwezo "Dzina".
- Koma, ngati tiyesera kuchotsa manambala a foni kuchokera ku chigawochi "Dzina"ndiye iwo ayamba kufota ndi kuchokera ku chigawocho "Nambala yafoni". Ichi ndi chifukwa chakuti zipilala zonsezi zikugwirizana ndi ndondomekoyi. Kuchotsa chiyanjano ichi, timasankha zonse zomwe zili m'ndandanda. "Nambala yafoni". Kenaka dinani pazithunzi "Kopani"yomwe ili pa katoni mu tab "Kunyumba" mu gulu la zida "Zokongoletsera". Mukhozanso kutumizira njirayo Ctrl + C.
- Kenaka, popanda kuchotsa kusankha kuchokera pamtundu wapamwambawu, dinani pamenepo ndi batani lakumanja. M'ndandanda wamakono mu gululo "Njira Zowonjezera" sankhani malo "Makhalidwe".
- Pambuyo pake, deta yonseyi m'ndandanda "Nambala yafoni" adzafotokozedwa ngati zida zodziimira, osati osati chifukwa cha kuwerengera. Tsopano, ngati mukukhumba, mukhoza kuchotsa manambala a foni kuchokera m'mbali "Dzina". Izi sizidzakhudza zomwe zili m'ndandanda. "Nambala yafoni".
Phunziro: Wowonjezera Wogwira Ntchito
Monga mukuonera, zinthu zomwe ntchitoyi imapereka Kulondola, khalani ndi zothandiza zenizeni. Mothandizidwa ndi woyendetsa makinawa, mukhoza kusonyeza malo odziwika chiwerengero chofunikira cha zilembo kuchokera ku maselo omwe akufotokozedwa, kuwerengera kuchokera kumapeto, ndiko kuti, kumanja. Wogwiritsira ntchitoyi ndiwothandiza kwambiri ngati mukufuna kuchotsa nambala yofanana ya olemba kuchokera kumapeto mu maselo ambirimbiri. Kugwiritsira ntchito ndondomeko muzochitika zotero kudzapulumutsa kwambiri nthawi ya wosuta.
