Indlela yokusombulula ingxaki e-Excel «Ileta yokuqala isihloko"

Abaninzi bayazibuza njani Excel ukwenza unobumba wokuqala yenziweyo? Le ngxaki ngenene eqhelekileyo kakhulu. Umzekelo, ukuba abasebenzisi incwadi ukuba ufake idatha ngempazamo, ephethe igama ileta encinane, avumele indawo, iimpazamo zoomabhalana, ezingachanekanga, nto leyo ekhokelela ekubeni efanayo kunzima ukuphumeza ekugqibeleni.

Eli nqaku enikelwe kuthetha ukuba Excel umhleli spreadsheet of "Microsoft" yintoni zibonelelwa umphuhlisi ukulawula oonobumba abancinci ngokwakho.

Excel kovela

Ngo-Excel, kukho ezi zilandelayo imisebenzi echazwe yokusebenza imitya:

• = UPPER (okubhaliweyo okanye bokisi yemiyalezo) - iguqula konke okubhaliweyo wangena (okanye okubhaliweyo le iseli ezikhethiweyo) ukuya isihloko ukuthini;
• = LOWER (okubhaliweyo okanye bokisi yemiyalezo) - iguqula konke okubhaliweyo wangena (okanye okubhaliweyo le iseli ezikhethiweyo) ngohlobo emgceni;
• = OFANELEKILEYO (okubhaliweyo okanye bokisi yemiyalezo) - Lo msebenzi uya kwenza eyinkunzi unobumba wokuqala igama ngalinye (ezahlulwe ngezithuba) okubhaliweyo, kunye nezinye iincwadi ukwenza kancinane.

Yenza umsebenzi e-Excel «Ileta yokuqala kwesihloko," njengoko sibona, akukho namnye imisebenzi ecetywayo. Kuba oku ukusebenzisa i indibaniselwano imisebenzi esele zenziwe, kodwa ujonge ngezantsi. Okokuqala, siya sihlolisise indlela onokwenza ngayo Excel oonobumba abakhulu kunye nasezantsi ngokusekelwe imisebenzi ngasentla.

Ukusebenza kunye nemisebenzi UPPER, LOWER, kwaye OFANELEKILEYO

Ukuze uqinisekise nangoko isiphumo zontathu imisebenzi kwisisele A2 angenise Excel yekhasi umtya elula "apile antonovka fresh" (sivumele ngokukhethekileyo unobumba omkhulu kwemfuneko ukujonga iziphumo zomsebenzi). Kwikholam osecaleni, faka le fomyula ilandelayo uze uthelekise iziphumo:

Njengoko ubona, zonke iimpawu umsebenzi njengoko kuchaziwe.

Vuma, bekuya kuba lula ukuya Excel kwi unobumba wokuqala isihloko iba njalo kakhulu, ngokukhetha nje engenamsebenzi mnye, kodwa, ngelishwa, oku akunakwenzeka. Kufuneka ukwenza ngokwethu indlela elungileyo ... eyabelwe eli candelo ethile.

Excel: unobumba wokuqala isihloko

Ukusombulula le ngxaki, simele ngokusengqiqweni uyithabathe silahlukanise ngezigaba ezahlukeneyo. Kulo mzekelo, zezi zilandelayo:

1. Khetha unobumba wokuqala wesicatshulwa. Kuyimfuneko ukuba luthathele ingqalelo ukuba abasebenzisi yenza izithuba ezongezelelweyo phambi kwisicatshulwa. Susa izithuba ezongezelelweyo kuya kusinceda umsebenzi ngombala (itekisi), uze ukhethe unobumba wokuqala - umsebenzi LEFT (umbhalo [inani amasuntswana]) kunye ingxabano yesibini imiselwe ku-1 (kokuba ikhethwe eyenziwe ngokungagqibekange, ukuze amkhulule).
2. Phawula unobumba wokuqala usebenzisa kuxoxwa ngazo kwicandelo odlulileyo UPPER umsebenzi ukutshintshela kwisihloko ukujonga.
3. Times kufuneka ukuba kuphothulwe umsebenzi Excel «Ileta yokuqala kwesihloko," oko kuthetha ukuba ezinye okubhaliweyo kunokubekwa khona leyo yenziweyo. Yiba ukuba kunjalo, ngoku kufuneka ukuba qhoboshela ileta yokuqala yesicatshulwa eseleyo. Ngaba oko kuya kusinceda umsebenzi RIGHT (umbhalo [inani amasuntswana]) uyazimela ekupheleni okubhaliweyo ilungelo inani lamasuntswana. Noko, enyanisweni, akunjalo? Kufuneka ube kangangoko ubude bomtya thabatha umlinganiswa yokuqala, oko kukuthi -1. Emva kokugqiba la manyathelo, kufuneka kunokubangela ifomu eziphezulu.
4. Kuhleli ukudibanisa iziphumo kumhlathi wesibini nowesithathu kunye ampersand (&).

Le ulandelelwano lonke fix itafile, uya kwenza ukuba ukucaca kumbhalo "Apple Antonovka fresh" izithuba ezongezelelweyo ezimbalwa.

Njengoko sibona, ukusombulula le ngxaki ngo-Excel «Ileta yokuqala kwesihloko," akuzange kube nzima kangaka, okona kubaluleke kakhulu, ukuba bammise phambi zonke ulandelelwano amanyathelo.