Ungalubhala kanjani ngosonhlamvukazi uhlamvu lokuqala ku-Excel

Abasebenzisi be-Active Excel bavame ukuhlangana nezimo lapho kudingeka khona ukubhala ngosonhlamvukazi uhlamvu lokuqala. Uma kunenombolo encane yamaseli, ungenza le nqubo mathupha. Kodwa-ke, uma sikhuluma ngokuhlela itafula elikhulu, amashidi amaningana agcwele ulwazi, kungcono ukusebenzisa izici ezakhelwe ngaphakathi ze-Excel ngokwayo, okuzokwenza ngokuzenzakalelayo yonke inqubo.

Ungashintsha kanjani uhlamvu lokuqala oluncane ngosonhlamvukazi

Enye yezinkinga ezinkulu zohlelo lwe-Excel ukuntuleka komsebenzi ohlukile wokushintsha izinhlamvu ezikhethiwe kumaseli nabanye. Inketho elula ukukwenza mathupha, kodwa ukuphinda inqubo efanayo kuzothatha isikhathi eside uma kunamaseli amaningi agcwele. Ukuze uqedele umsebenzi ngokushesha ngangokunokwenzeka, udinga ukuhlanganisa amathuluzi akhelwe ngaphakathi Excel phakathi kwabo.

Indlela yokubhala ngosonhlamvukazi uhlamvu lokuqala lwegama elilodwa

Ukushintsha izinhlamvu zokuqala egameni elilodwa kuphela lomkhakha noma ububanzi ngosonhlamvukazi, udinga ukusebenzisa imisebenzi emithathu:

1. I-"REPLACE" umsebenzi oyinhloko. Kudingeka ukuze kushintshwe ingxenye yonke isuke kuseli noma uhlamvu olulodwa iye kulokho okuzoboniswa ku-agumenti yomsebenzi.
2. “PHEZULU” wumsebenzi ohlobene nohlelo lokuqala. Kudingeka esikhundleni sosonhlamvukazi abancane esikhundleni sosonhlamvukazi.
3. “LEFT” umsebenzi ohlobene nohlelo lwesibili. Ngosizo lwayo, ungakwazi ukubala izinhlamvu eziningana kusuka kuseli eliqokiwe.

Ukuqonda indlela yokuqedela lo msebenzi kuzoba lula kakhulu uma uchaza yonke inqubo isinyathelo ngesinyathelo. Inqubo:

1. Gcwalisa ithebula ngedatha edingekayo kusengaphambili.
2. Ngokuchofoza i-LMB, maka iseli yamahhala eshidini elidingekayo lethebula.
3. Kuseli elikhethiwe, kufanele ubhale isisho sendawo lapho ofuna ukushintsha uhlamvu olulodwa esikhundleni solunye. Isisho sibukeka kanje: REPLACE(A(cell number),1,UPPER(LEFT(A(cell number),1))).
4. Lapho ifomula isilungisiwe, udinga ukucindezela inkinobho ethi "Enter" ukuze inqubo yenziwe. Uma isisho sibhalwe ngendlela efanele, inguqulo elungisiwe yombhalo izovela kuseli elikhethiwe ngokuhlukana.
5. Okulandelayo, udinga ukuhambisa phezulu kombhalo oshintshiwe ngekhesa yegundane, uyihambise ekhoneni elingezansi kwesokudla. Kufanele kuvele isiphambano esimnyama.
6. Kudingeka ubambe isiphambano se-LMB, usidonsele phansi imigqa eminingi njengoba sisekholomu yokusebenza.
7. Ngemva kokuqeda lesi senzo, kuzovela ikholomu entsha, lapho yonke imigqa yekholomu yokusebenza izokhonjiswa ngezinhlamvu zokuqala ezishintshelwe kosonhlamvukazi.

8. Okulandelayo, udinga ukukopisha idatha etholiwe endaweni yolwazi lwangempela. Ukuze wenze lokhu, udinga ukukhetha ikholomu entsha, uyikopishe ngemenyu yokuqukethwe noma umugqa onamathuluzi kuthebhu "Ekhaya".
9. Khetha yonke imigqa kukholamu yokuqala ofuna ukuyishintsha. Chofoza kwesokudla, kumenyu yokuqukethwe evelayo, khetha umsebenzi wesibili eqenjini elithi "Namathisela Izinketho", igama lalo lithi "Values".
10. Uma zonke izenzo zenziwe ngendlela efanele, amanani kumaseli amakiwe azoshintsha kulawo atholwe yifomula.
11. Kusele ukususa ikholomu yenkampani yangaphandle. Ukuze wenze lokhu, khetha wonke amaseli ashintshiwe, chofoza kwesokudla ukuze uvule imenyu yokuqukethwe, khetha umsebenzi othi "Susa".
12. Iwindi kufanele livele elinenketho yokususa amaseli etafuleni. Lapha udinga ukukhetha ukuthi izakhi ezikhethiwe zizosuswa kanjani - ikholomu yonke, imigqa ngayinye, amaseli anokushintsha phezulu, amaseli anoshintsho kwesokunxele.
13. Ukuze uqedele ukususa, chofoza inkinobho ethi "KULUNGILE".

Inqubo yokushintsha izinhlamvu zokuqala zawo wonke amagama ngosonhlamvukazi

Ukusebenza ngamatafula Excel, kwesinye isikhathi kuba nesidingo sokuthi uguqule izinhlamvu zokuqala zawo wonke amagama kumaseli athile zibe ngofeleba. Ukuze wenze lokhu, kunconywa ukuthi usebenzise umsebenzi othi "PROPER". Inqubo:

1. Khetha iseli elingenalutho kuthebula ngokuchofoza kwesokudla, engeza isisho sokuqala kulo usebenzisa inkinobho ethi “Faka Umsebenzi” (etholakala kwesokunxele sebha yefomula, echazwa ngokuthi “fx”).

2. Iwindi lokwengeza izilungiselelo zemisebenzi lizovela phambi komsebenzisi, lapho udinga ukukhetha "PROPER", chofoza inkinobho ethi "KULUNGILE".
3. Ngemva kwalokho, udinga ukugcwalisa impikiswano yomsebenzi. Esigabeni samahhala, udinga ukubhala igama leseli ofuna ukushintsha idatha yalo. Cindezela inkinobho ethi "KULUNGILE".

Kubalulekile! Kulabo basebenzisi abazi amafomula amaningi e-Excel ngekhanda, akudingekile ukusebenzisa "Isilekeleli Somsebenzi". Ungakwazi ukufaka umsebenzi kuseli ekhethiwe yethebula ngesandla bese wengeza kuyo izixhumanisi zeseli ofuna ukuyishintsha idatha yayo. Isibonelo =PROPLANCH(I-A2).

4. Umphumela oqediwe uzovezwa kuseli yetafula, elamakwa ngokwehlukana namakholomu okusebenza.
5. Phinda izinyathelo 5, 6, 7 kusukela endleleni yangaphambilini. Uma konke kwenziwa ngendlela efanele, ikholomu entsha enedatha eshintshile kufanele ivele.
6. Ikholomu ehlukile kufanele ikhethwe kusetshenziswa i-RMB, iphaneli yedokhumenti noma inhlanganisela yokhiye kukhibhodi “CTRL + C”.
7. Khetha wonke amaseli ekhasini lomsebenzi ofuna ukuwashintshanisa nedatha yawo. Namathisela inguqulo eshintshiwe ngomsebenzi othi “Values”.
8. Isenzo sokugcina ngaphambi kokulondoloza umphumela ukususa ikholomu eyengeziwe lapho idatha ikopishwe khona, njengoba kuchazwe endleleni yokuqala.

Isiphetho

Uma uhlanganisa kahle amathuluzi atholakala kunguqulo evamile ye-Excel, ungashintsha uhlamvu lokuqala lwegama elilodwa noma amaningi avela kumaseli akhethiwe, okuyinto ezikhathini eziningi elula futhi esheshayo kunokungena ngesandla.