Ezimweni eziningi, kuyadingeka ukuthi incwadi yokuqala esitokisini setafula ibe nekhanda. Uma umsebenzisi ekuqaleni engena ngokungenayo amagama angaphansi kwamagama noma akopishwe idatha esuka komunye umthombo kuya ku-Excel, lapho wonke amagama aqala ngencwadi encane, khona-ke ungasebenzisa isikhathi esiningi kakhulu nomzamo wokuletha ukubonakala kwetafula esifundeni esifisa. Kodwa, mhlawumbe i-Excel ineamathuluzi akhethekile ongayisebenzisa ngayo le nqubo? Ngempela, lolu hlelo lunomsebenzi wokushintsha izinhlamvu ezincane ukuze kube lula. Ake sibheke ukuthi isebenza kanjani.
Inqubo yokuguqula incwadi yokuqala ibe yinhloko
Akufanele ulindele ukuthi i-Excel inenkinobho ehlukile, ngokuchofoza ukuthi ungayithumela kanjani ngokuzenzakalelayo incwadi ephansi ngaphansi kwencwadi. Ngenxa yalokhu, kubalulekile ukusebenzisa imisebenzi, futhi eziningana ngesikhathi esisodwa. Noma kunjalo, kunoma yikuphi, le ndlela iyoba ngaphezu kokukhokha izindleko zesikhathi okuzodingeka ukuze ushintshe ngesandla.
Indlela 1: Faka esikhundleni sencwadi yokuqala esitokisini ngenhloko
Ukuxazulula le nkinga, umsebenzi oyinhloko uyasetshenziswa. REPLACE, kanye nemisebenzi emihle ye-oda lokuqala neyesibili UPPER futhi BHEKA.
- Umsebenzi REPLACE shintsha umlingisi owodwa noma ingxenye yochungechunge ngolunye, ngokuvumelana neziphakamiso ezicacisiwe;
- UPPER - yenza izinhlamvu ziqhubekele, okungukuthi, ezingokoqobo, yilokho esikudingayo;
- BHEKA - ubuyisa inombolo ecacisiwe yezinhlamvu zombhalo othile esitokisini.
Okusho ukuthi, ngokusekelwe kulolu hlelo lwemisebenzi, ukusebenzisa BHEKA sizobuyisa incwadi yokuqala esitokisini esacacisiwe besebenzisa opharetha UPPER yenza kube yinhloko bese esebenza REPLACE shintsha incwadi encane ngencwadi ebhalwe phansi.
Ithemplate evamile yalo msebenzi izoba kanje:
= REPLACE (old_text; kuqala_kuqala; inombolo_izinhlamvu; PROPISN (LEFT (umbhalo; inombolo_amagama)))
Kodwa kungcono ukucabangela konke lokhu ngesibonelo sokhonkolo. Ngakho-ke, sinetafula eligcwele lapho wonke amagama alotshwe ngencwadi encane. Kufanele senze umlingisi wokuqala esitokisini ngasinye ngamagama wokugcina aqoshiwe. Iseli yokuqala enegama lokugcina inezixhumanisi B4.
- Kunoma yisiphi isikhala samahhala salesi shidi noma kwenye ishidi bhala ifomula elandelayo:
= REPLACE (B4; 1; 1; PROPISN (LEFT (B4; 1))) - Ukucubungula idatha bese ubona umphumela, cindezela inkinobho yokungena kwikhibhodi. Njengoba ungabona, manje esitokisini igama lokuqala liqala ngenhlamvu enkulu.
- Siba isikhombisi ekhoneni lesansi elingakwesokunxele leseli ngefomula bese usebenzisa uphawu lokugcwalisa ikhophi ifomula kumaseli aphansi. Kumele siyikopishe ngokuya lapho kuhlelwe phansi, mangaki amangqamuzana anegama lokugcina eliqukethe kuthebula lawo langempela.
- Njengoba ungabona, kunikezwe ukuthi izixhumanisi kwifomula zihlobene, futhi azikho ngokuphelele, ukukopisha kwenzeke ngokushintsha. Ngakho-ke, amaseli aphansi abonisa okuqukethwe kwezikhundla ezilandelayo, kodwa futhi nencwadi enkulu. Manje sidinga ukufaka umphumela kutafula langempela. Khetha ibanga elinamafomula. Chofoza inkinobho yesokudla yegundane bese ukhetha into emenyu yemongo "Kopisha".
- Ngemuva kwalokho, khetha amakheli omthombo anegama lokugcina etafuleni. Shayela imenyu yesimo ngokuchofoza inkinobho yesokudla yegundane. Ku-block "Izinketho zokufaka" khetha into "Amanani"okuyinto evezwa ngesimo sesithonjana enezinombolo.
- Njengoba ungabona, emva kwalokhu sidinga idatha yafakwa ezikhundleni zangaphambili zetafula. Kulesi simo, izincwadi ezincane ezisekuqaleni kwamagama amangqamuzana athathelwa indawo nge-uppercase. Manje, ukuze ungaphazamise ukubukeka kweshidi, udinga ukususa amaseli anefomula. Kubaluleke kakhulu ukususa uma wenza ukuguqulwa kwelinye ishidi. Khetha ububanzi obucacisiwe, chofoza ngakwesokudla bese unqanda ukukhethwa kwimenyu yesimo. "Susa ...".
- Ebhokisini lezingxoxo elincane elibonakalayo, setha inkinobho endaweni "Umzila". Sicindezela inkinobho "Kulungile".
Ngemuva kwalokho, idatha eyengeziwe izosuswa, futhi siyothola umphumela owawufeziwe: esitokisini ngasinye setafula, igama lokuqala liqala ngenhlamvu enkulu.
Indlela 2: Yonke igama elinombhalo omkhulu
Kodwa kunezimo lapho kudingeka khona ukuba ungenzi nje kuphela igama lokuqala esitokisini, uqale ngencwadi enkulu, kodwa ngokujwayelekile, igama ngalinye. Kulokhu, kukhona umsebenzi ohlukile, futhi kulula kakhulu kunalowo owedlule. Lesi sici sabizwa I-PROPNACh. I-syntax yayo ilula kakhulu:
= PROPNACH (ikheli leseli)
Esikhathini sethu, isicelo salo sizoba kanje.
- Khetha indawo yamahhala yeshidi. Chofoza kusithonjana "Faka umsebenzi".
- Esikhathini somsebenzi wizard ovula, funa PROPNACH. Ukuthola leli gama, ukhethe bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano ivuleka. Faka i-cursor ensimini "Umbhalo". Khetha iseli lokuqala negama lokugcina etafuleni lomthombo. Ngemuva kokuthi ikheli layo lifike emkhakheni wewindi lempikiswano, sicindezela inkinobho "Kulungile".
Kukhona enye inketho ngaphandle kokuqala i-Function Wizard. Ukwenza lokhu, kufanele, njengendlela yangaphambilini, faka umsebenzi esitokisini ngesandla ngokurekhoda izixhumanisi zedatha yangempela. Kulesi simo, lokhu kungena kuzobukeka kanje:
= PROPNAC (B4)Khona-ke kuzodingeka ucindezele inkinobho Ngena.
Ukukhetha ukhetho oluthile kuxhomeke ngokuphelele kumsebenzisi. Kulabo abasebenzisi abangajwayele ukukhumbula amafomu amaningi ahlukene, kungokwemvelo kulula ukwenza ngokusiza kweMisebenzi Yemisebenzi. Ngesikhathi esifanayo, abanye bakholelwa ukuthi ukungena kokusebenza kwabasebenzi kuyashesha kakhulu.
- Noma ngabe iyiphi inketho ekhethiwe, esitokisini nomsebenzi sithole umphumela esiwudinga. Manje, igama ngalinye elisha esitokisini liqala ngenhlamvu enkulu. Njengesikhathi sokugcina, kopisha ifomula kumaseli angezansi.
- Ngemva kwalokho, kopisha umphumela usebenzisa imenyu yesimo.
- Sifaka idatha ngento "Amanani" faka izinketho etafuleni lomthombo.
- Susa amanani aphakathi ngokusebenzisa imenyu yesimo.
- Ewindini elisha, siqinisekisa ukususwa kwemigqa ngokubeka ushintsho endaweni efanele. Sicindezela inkinobho "Kulungile".
Ngemuva kwalokho, sizothola ithebula elisuka kumthombo ongashintshi, kodwa kuphela amagama onke kumaseli asetshenzisiwe manje azophelelwa ngenhlamvu enkulu.
Njengoba ungabona, naphezu kokuthi ukuguqulwa kwamagama ezincane okukhulisa kakhulu ku-Excel ngokusebenzisa ifomula ekhethekile akukwazi ukubizwa ngokuthi inqubo eyisisekelo, noma kunjalo, kulula kakhulu futhi elula kakhulu kunokushintsha izinhlamvu ngesandla, ikakhulukazi uma kuningi. Ama-algorithms angenhla awavikela kuphela amandla omsebenzisi, kodwa futhi isikhathi esiyigugu kakhulu. Ngakho-ke, kuyadingeka ukuthi umsebenzisi ovamile u-Excel angasebenzisa la mathuluzi emsebenzini wabo.
