Ezimweni eziningi, incwadi yokuqala esitokisini sethebula kudingeka ukuba ibe ngaphezulu. Uma umsebenzisi ekuqaleni ngephutha afaka izinhlamvu ezisezingeni eliphansi yonke indawo noma akopishe idatha ye-Excel evela komunye umthombo lapho wonke amagama aqala khona ngohlamvu oluncane, khona-ke isikhathi esiningi nomzamo singasetshenziswa ukuletha ukubonakala kwetafula esimweni esifunayo. Kepha mhlawumbe i-Excel inamathuluzi akhethekile wokusebenzisa le nqubo? Impela, uhlelo lunomsebenzi wokushintsha iincanyana zibe yibhokisi eliphezulu. Ake sibheke ukuthi isebenza kanjani.
Inqubo yokuguqula incwadi yokuqala ibe yibhokisi eliphezulu
Akufanele ulindele ukuthi i-Excel inenkinobho ehlukile, ngokuchofoza lapho ungaguqula khona ngokuzenzekelayo incwadi encane ibe incwadi eyinhlokodolobha. Ukuze wenze lokhu, kuzodingeka usebenzise imisebenzi, futhi eziningana ngasikhathi sinye. Kodwa-ke, kunoma yikuphi, le ndlela izodlula ukukhokhela izindleko zesikhathi ezodingeka ukushintsha idatha.
Indlela yoku-1: buyisela uhlamvu lokuqala esitokisini ngenhlamvu enkulu
Ukuxazulula inkinga, umsebenzi oyinhloko uyasetshenziswa. REPLACE, kanye nemisebenzi ehlanganisiwe ye-oda lokuqala nelesibili OKUFANELEKILE futhi I-LEVSIMV.
- Umsebenzi REPLACE ubeka esikhundleni uhlamvu olulodwa noma ingxenye yentambo nabanye, ngokuya ngeziphikiso ezibekiwe;
- OKUFANELEKILE - Kwakha tinhlavu eluhlwini, lokusho, tinhlamvuto letikhulu, lokuyikho esikudzingako;
- I-LEVSIMV - Ibuyisa inombolo ebekiwe yezinhlamvu zombhalo othile esitokisini.
Lokho wukuthi, kususelwa kule sethi yemisebenzi, usebenzisa I-LEVSIMV sizobuyisela incwadi yokuqala kuseli elishiwo sisebenzisa opharetha OKUFANELEKILE yenze ibe yinhlokodolobha bese isebenza REPLACE buyisela ubuhlalu obusezingeni eliphezulu.
Isifanekiso esijwayelekile salokhu kusebenza sizobukeka kanjena:
= REPLACE (umdala_ umongo; isiqalo_pos; inombolo yezinhlamvu; I-CAPITAL (LEVSIMV (umbhalo; inombolo yezinhlamvu))
Kepha kungcono ukubheke konke lokhu ngesibonelo sikakhonkolo. Ngakho-ke, sinethebula eligcwalisiwe lapho wonke amagama ebhalwe khona ngencwadi encane. Kufanele senze umlingisi wokuqala esitokisini ngasinye esinamagama aphakanyisiwe. Iseli yokuqala enegama lokugcina inezizixhumanisi B4.
- Kunoma iyiphi indawo yamahhala yaleli shidi noma kwelinye iphepha, bhala ifomula elandelayo:
= REPLACE (B4; 1; 1; IPHAKATHI (LEVISIM (B4; 1))) - Ukuze ucubungule idatha futhi ubone umphumela, cindezela inkinobho ethi Enter kwikhibhodi. Njengoba ubona, manje esitokisini igama lokuqala liqala ngohlamvu olukhulu.
- Siba isikhombisi ekhoneni elingezansi kwesobunxele ngefomula bese sisebenzisa umaki wokugcwalisa ukukopisha ifomula kumaseli aphansi. Kufanele sikukopishe izikhundla eziningi nje kuphela njengoba inani lamaseli anamagama okugcina enawo ekuqulweni kwetafula lasekuqaleni.
- Njengoba ukwazi ukubona, uma nje izixhumanisi kwifomula zihlobene, futhi zingenaphutha, ukukopisha kwenzeka ngenguquko. Ngakho-ke, kumaseli aphansi okuqukethwe kwezikhundla ezilandelayo kwaboniswa, kodwa futhi nangonobumba omkhulu. Manje sidinga ukufaka umphumela etafuleni lomthombo. Khetha ibanga elinamafomula. Sichofoza kwesokudla bese ukhetha into kumenyu yokuqukethwe Kopisha.
- Ngemuva kwalokho, khetha amaseli womthombo anamagama okugcina etafuleni. Sibiza imenyu yokuqukethwe ngokuchofoza inkinobho yegundane elifanele. Ebhlokini Faka Izinketho khetha into "Amanani", eyethulwa njengesithonjana esinenombolo.
- Njengoba ukwazi ukubona, emva kwalokho imininingwane esiyidingayo yafakwa kwizikhundla zokuqala zethebula. Ngasikhathi sinye, izinhlamvu ezincane ezisetshenziselwa amagama okuqala amaseli zathathelwa indawo nge-topsel. Manje, ukuze ungabhubhisi ukubukeka kweshidi, udinga ukususa amaseli amafomula. Kubaluleke kakhulu ukufeza ukususwa uma wenza ukuguqulwa kweshidi elilodwa. Khetha ibanga elibekiwe, chofoza kwesokudla nakwimenyu yokuqukethwe, umise ukukhetha entweni "Susa ...".
- Ebhokisini lengxoxo encane evelayo, setha ukushintshela ku "Umugqa". Chofoza inkinobho "Kulungile".
Ngemuva kwalokho, imininingwane eyengeziwe izocishwa, futhi sizothola umphumela esiwutholile: esitokisini ngasinye setafula, igama lokuqala liqala ngohlamvu olukhulu.
Indlela yesi-2: fundisa igama ngalinye
Kepha kunezikhathi lapho udinga ukwenza hhayi kuphela igama lokuqala esitokisini, uqala ngoonobumba abakhulu, kodwa ngokuvamile, igama ngalinye. Kukhona futhi umsebenzi ohlukile walokhu, ngaphezu kwalokho, ulula kakhulu kunangaphambili. Lo msebenzi ubizwa ISITOLO. I-syntax yayo ilula kakhulu:
= EXTRACT (cell_address)
Ngokwesibonelo sethu, ukusetshenziswa kwayo kuzobukeka kanjena.
- Khetha indawo yamahhala eshidi. Chofoza isithonjana "Faka umsebenzi".
- KuWizard Yomsebenzi evulekile, funa ISITOLO. Ngemuva kokuthola leli gama, likhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyavula. Faka ikhesa endle "Umbhalo". Khetha iseli lokuqala elinegama lokugcina etafuleni lomthombo. Ngemuva kokuthi ikheli lakhe lisenkambu yewindows yezimpikiswano, chofoza inkinobho "Kulungile".
Kukhona enye inketho ngaphandle kokuqala Umsebenzi Wizard. Ukuze wenze lokhu, kumele, njengangendlela edlule, faka umsebenzi esitokisini ngesandla ngokuqopha izixhumanisi zedatha yomthombo. Kulokhu, lokhu kufakwa kuzobukeka kanjena:
= ISIGNAL (B4)Ngemuva kwalokho uzodinga ukucindezela inkinobho Ngena.
Ukukhethwa kwenketho ethile kuxhomekeke kumsebenzisi ngokuphelele. Kulabo abasebenzisi abangasetshenziswanga ukuphatha amafomula amaningi ahlukene emakhanda abo, kulula ngokwemvelo ukwenza lokho ngosizo lweWizadi Yomsebenzi. Ngasikhathi sinye, abanye bakholelwa ukuthi ukufaka i-opharetha ngesandla kushesha kakhulu.
- Noma ngabe ikuphi ukukhetha okwakhethwa, esitokisini ngokusebenza sathola umphumela esiwudingayo. Manje igama ngalinye elisha esitokisini liqala ngohlamvu olukhulu. Njengokugcina, kopisha ifomula kumaseli angezansi.
- Ngemuva kwalokho, kopisha umphumela usebenzisa imenyu yokuqukethwe.
- Faka idatha entweni "Amanani" faka izinketho etafuleni lomthombo.
- Susa amanani aphakathi nendawo ngemenyu yokuqukethwe.
- Ewindini elisha, qinisekisa ukususwa kwemigqa ngokusetha ukushintshela endaweni efanele. Cindezela inkinobho "Kulungile".
Ngemuva kwalokho, sizothola itafula lomthombo elingaguquki, kodwa wonke amagama asezitokisini ezisetshenzisiwe manje azopelekwa ngohlamvu olukhulu.
Njengoba ubona, ngaphandle kweqiniso lokuthi ushintsho oluningi lwezinhlamvu ezincane luye ezinhlamvwini eziphezulu ku-Excel ngokusebenzisa ifomula ekhethekile alunakubizwa ngokuthi inqubo esetshenziswayo, noma kunjalo, alula kakhulu futhi alula kakhulu kunokushintsha izinhlamvu ngesandla, ikakhulukazi uma kunenqwaba yazo. Ama-algorithms angenhla awonga amandla womsebenzisi kuphela, kodwa futhi abaluleke kakhulu - isikhathi. Ngakho-ke, kuyinto efiselekayo ukuthi umsebenzisi ojwayelekile we-Excel angawasebenzisa la mathuluzi emsebenzini wabo.
