Ungakubhala Kanjani umbhalo ku-Excel

Indlela 1: Usebenzisa ithuluzi elizenzakalelayo

I-Excel inethuluzi elizenzakalelayo elenzelwe ukuhlukanisa umbhalo kumakholomu. Akusebenzi ngokuzenzakalelayo, ngakho-ke zonke izenzo kuzofanele zenziwe ngesandla, zikhetha uhla lwedatha esetshenzisiwe. Kodwa-ke, ukulungiselelwa kulula kakhulu futhi kuyashesha ekuqalisweni.

1. Nge inkinobho yegundane kwesobunxele, khetha wonke amaseli umbhalo wawo ofuna ukuhlukanisa kukholamu.



2. Ngemuva kwalokho, iya kuthebhu "Idatha" bese uqhafaza inkinobho ethi "Umbhalo kwikholamu".



3. Iwindows "Columm Text Wizard" ivela, lapho ufuna ukukhetha khona ngefomethi yedatha "nabahlukanisi". Isihlukanisi sivame ukwenza isikhala, kepha uma lesi esinye isibonakaliso sezimpawu zokubhala, uzodinga ukuyichaza esinyathelweni esilandelayo.



4. Thikha isheke lokuhlola elilandelanayo noma liyifake ngesandla, bese ufunda umphumela wokuqala wokuhlukanisa efasiteleni elingezansi.



5. Esinyathelweni sokugcina, ungacacisa ngefomethi entsha yekholomu nendawo lapho kufanele ibekwe khona. Lapho ukusetha sekuqediwe, chofoza u- "Qeda" ukufaka zonke izinguquko.



6. Buyela etafuleni futhi uqiniseke ukuthi ukwahlukana sekudlulile ngempumelelo.

Kulomyalo, singaphetha ngokuthi ukusetshenziswa kwethuluzi elinjalo kulungile kulezo zimo lapho ukwahlukana kufanele kwenziwe kanye kuphela, okubonisa igama ngalinye ikholomu entsha. Kodwa-ke, uma idatha entsha ihlala ingeniswa etafuleni, ngaso sonke isikhathi ukuwahlukanisa izokwenziwa lula, ngakho-ke ezimweni ezinjalo siphakamisa ukuthi uzijwayeze ngendlela elandelayo.

Indlela 2: Ukudala Ifomula Ye-Split Ehlukile

Ku-Excel, ungakha ngokuzimela ifomula eyinkimbinkimbi ezokuvumela ukubala izikhundla zamagama esitokisini, uthole izikhala bese uhlukanisa ngamunye amakholomu ahlukile. Njengesibonelo, sizothatha iseli elinamagama amathathu ahlukaniswe izikhala. Ngamunye wabo, kuzothatha ifomula yabo, ngakho-ke sihlukanisa indlela ngezigaba ezintathu.

Isinyathelo 1: Ukuhlukaniswa kwegama lokuqala

Ifomula yokuthi igama lokuqala lilula kakhulu, ngoba kuzofanela lixoshwe kuphela kusuka kwigebe elilodwa ukunquma isikhundla esifanele. Cabanga ngesinyathelo ngasinye sendalo yaso, ukuze isithombe esiphelele sakhiwe yingakho ukubala okuthile kudingeka.

1. Ukuze kube lula, dala amakholomu amasha amathathu anamasiginali lapho sizofaka khona umbhalo ohlukanisiwe. Ungenza okufanayo noma weqe lo mzuzu.



2. Khetha iseli lapho ufuna ukubeka khona igama lokuqala, bese ubhala phansi ifomula =.



3. Ngemuva kwalokho, cindezela inkinobho ethi "Okokukhetha", ngaleyo ndlela udlulele ewindini lokuhlela eliqhakaza lefomula.



4. Njengombhalo wengxabano, chaza iseli nombhalo ngokuchofoza kulo ngenkinobho yegundane kwesobunxele etafuleni.



5. Inani lezimpawu esikhaleni noma kwesinye isihlukanisi kuzofanele ukubala, kepha ngesandla ngeke sikwenze lokhu, kepha sizosebenzisa enye indlela - ukusesha ().



6. Lapho nje uqopha ngefomethi enjalo, kuzovela embhalweni weseli ngaphezulu futhi kuzoqokonyiswa ngokugqamile. Chofoza kuyo ukuze ushintshe ngokushesha ezingxabanweni zalo msebenzi.



7. Ensimini ethi "Skeleton" kumane kubeka isikhala noma ukwahlukanisa okusetshenzisiwe ngoba kuzokusiza uqonde ukuthi igama liphela kuphi. In the "Umbhalo_-Search" Cacisa iseli efanayo ecutshungulwa.



8. Chofoza kumsebenzi wokuqala ukubuyela kuyo, bese ufaka ekugcineni kwengxabano yesibili -1. Lokhu kuyadingeka ukuze ifomu lokusesha lingabheki hhayi isikhala esifiselekayo, kepha uphawu kulo. Njengoba kungabonakala esikrinini esilandelayo, umphumela uboniswa ngaphandle kwezikhala, okusho ukuthi ukuhlanganiswa kwefomula kwenziwa kahle.



9. Vala isihleli somsebenzi futhi uqiniseke ukuthi igama liboniswa kahle esitokisini esisha.



10. Bamba iseli ekhoneni elingezansi kwesokudla bese uhudula phansi inani elidingekayo lemigqa ukwelula. Ngakho-ke amanani ezinye izinkulumo afakwa esikhundleni, okumele ahlukaniswe, futhi ukugcwaliseka kwefomula ngokuzenzakalelayo.

Ifomula edalwe ngokuphelele inefomu = levsimv (A1; search (""; A1) -1), ungayakha lokhu uma izimo kanye nokwehlukana kufanelekile. Ungakhohlwa ukufaka esikhundleni seseli elicutshunguliwe.

Isinyathelo 2: Ukuhlukaniswa kwegama lesibili

Into enzima kunazo zonke ukuhlukanisa igama lesibili, elithi egameni lethu igama. Lokhu kungenxa yokuthi izungezwe yizikhala ezivela ezinhlangothini zombili, ngakho-ke kuzofanela unake bobabili, udala ifomula enkulu yokubalwa okuyikho kwesikhundla esifanele.

1. Kulokhu, ifomula eliyinhloko lizoba = PST (- Bhala kuleli fomu, bese uya ewindini lezilungiselelo zokuphikisana.



2. Le formula izosesha intambo oyifunayo embhalweni, okhethwe yi-cell enombhalo wokuhlukaniswa.



3. Isikhundla sokuqala somugqa kuzodingeka sinqunywe kusetshenziswa iFomula yeFomula Ejwayelekile Yesikhashana ye-Auxiliary ().



4. Ukudala nokuhambisa kuyo, ugcwalise ngendlela efanayo nakho okuboniswe esigabeni esedlule. Njengombhalo owuthandayo, sebenzisa i-Upteritor, bese ucacisa iseli njengombhalo ukuze useshe.



5. Buyela kwifomula yangaphambilini, lapho ungezela khona ekusebenzeni kwe- "Sesha" +1 ekugcineni ukuqala i-akhawunti kusuka kumlingiswa olandelayo ngemuva kwesikhala esilandelayo ngemuva kwesikhala esilandelayo ngemuva kwesikhala esitholakele.



6. Manje ifomula selivele liqale ukusesha umugqa kusuka kwigama lomlingiswa wokuqala, kepha namanje alazi ukuthi lingakuqeda kuphi, ngakho-ke, ensimini "amagama" futhi, bhala ifomula yokusesha ().



7. Iya ezimpikiswaneni zayo bese uwagcwalisa ngesimo esijwayelekile.



8. Phambilini, asicabangi isikhundla sokuqala salo msebenzi, kepha manje kuyadingeka ukufaka usesho (), ngoba leli dlela leli fomu akufanele lithole igebe lokuqala, kodwa owesibili.



9. Iya emsebenzini owenziwe bese uyigcwalisa ngendlela efanayo.



10. Buyela "ukusesha" kokuqala bese wengeza ku- "Nach_Poposition" + + ekugcineni, ngoba ayidingi isikhala sokusesha umugqa, kepha umlingiswa olandelayo.



11. Chofoza ku-ROOT = PST bese ubeka isikhombisi ekugcineni komugqa "Numbers_Names".



12. Khipha isisho senkulumo (""; A1) -1 ukuqeda ukubalwa kwezikhala.



13. Buyela etafuleni, welula ifomula futhi uqiniseke ukuthi amagama aboniswa kahle.

Ifomula yaphenduka inkulu, futhi akubona bonke abasebenzisi abaqonda kahle ukuthi isebenza kanjani. Iqiniso ngukuthi ukusesha ulayini bekufanele ngisebenzise imisebenzi eminingana enquma izikhala zokuqala nezokugcina zezikhala, bese kuthi uphawu olulodwa lususwe kubo ukuze kuboniswe. Ngenxa yalokhu, ifomula yile: = I-PSTR (A1; search (""; a1) + "; a1; a1) -" "; a1) - 1). Yisebenzise njengesibonelo, ungene esikhundleni senombolo yeseli ngombhalo.

Isinyathelo 3: Ukuhlukaniswa kwegama lesithathu

Isinyathelo sokugcina somyalo wethu sisho ukuhlukaniswa kwegama lesithathu, elibukeka ngendlela efanayo njengoba kwenzeka ngento yokuqala, kepha ifomula elijwayelekile lishintsha kancane.

1. Esitokisini esingenalutho, endaweni yombhalo wesikhathi esizayo, bhala = Rashesimv (bese uya ezimpikiswaneni zalo msebenzi.



2. Njengombhalo, chaza iseli enombhalo wokuhlukaniswa.



3. Lo msebenzi osizayo wokuthola igama libizwa nge-DLSTR (A1), lapho i-A1 ilingisa elifanayo nombhalo. Lesi sici sinquma inani lezinhlamvu embhalweni, futhi sizokwazi ukwaba kufaneleka kuphela.



4. Ukuze wenze lokhu, engeza -poisk () bese uya ukuhlela le formula.



5. Faka isakhiwo esivele sesijwayelekile ukusesha ohlukanisayo wokuqala entanjeni.



6. Faka okunye ukusesha isikhundla sokuqala ().



7. Cacisa isakhiwo esifanayo.



8. Buyela kwifomula yokusesha eyangaphambilini.



9. Faka u-+1 kwisikhundla sayo sokuqala.



10. Zulazulela empandeni yeFomula RascescesV futhi uqiniseke ukuthi umphumela uboniswa kahle, bese uqinisekisa izinguquko. Ifomula ephelele kuleli cala ibukeka njenge = Pracemir (A1; DLSTR (A1) -Poisk (""; A1; A1).



11. Ngenxa yalokhu, esikrinini esilandelayo uyabona ukuthi wonke amagama amathathu ahlukaniswe kahle futhi asekholeni yawo. Kulokhu, kwakudingeka ukuthi usebenzise amafomula ahlukahlukene nemisebenzi yokusiza, kepha ikuvumela ukuthi wandise amandla etafula futhi ungakhathazeki ukuthi ngaso sonke isikhathi lapho kufanele uphinde uhlanganyele umbhalo. Uma kunesidingo, mane wandise ifomula ngokuyihambisa phansi ukuze amaseli alandelayo athinteke ngokuzenzakalela.