Indlela ukuxazulula le nkinga Excel «Incwadi yokuqala isihloko"

Abaningi bafisa ukwazi ukuthi indlela Excel ukwenza uhlamvu lokuqala lifakwa? Le nkinga evame kakhulu ngempela. Ngokwesibonelo, abasebenzisi ibhuku ukungena idatha ngokungenaqiniso bephakamise igama ngohlamvu encane, ukuvumela isikhala esengeziwe, amaphutha kanobhala, ukungalungi, okuholela yokuthi ukufana kunzima ukufeza ekugcineni.

Lesi sihloko Sizokwenza yini kusho i-Excel-spreadsheet umhleli we- "Microsoft" anikezwa ngunjiniyela ukuphatha bofeleba netinhlavu letincane uwedwa.

Excel amakhono

Ku-Excel, kukhona lokhu okulandelayo imisebenzi echazwe zokusebenza ngogubhu:

• = NGENHLA (umbhalo noma nge ibhokisi lombhalo) - kuguqula wonke umbhalo ofakiwe (noma umbhalo iseli akhethiwe) kwesihloko kusho;
• = OKUNGEZANSI (umbhalo noma nge ibhokisi lombhalo) - kuguqula wonke umbhalo ofakiwe (noma umbhalo iseli akhethiwe) emgqeni uhlobo;
• = OKUFANELE (umbhalo noma nge ibhokisi lombhalo) - Le umsebenzi uzokwenza dolobha uhlamvu lokuqala egameni ngalinye (ahlukaniswe ngezikhala) umbhalo, kanye nezinye izincwadi ukwenza okuncane.

Yenza umsebenzi Excel «Incwadi yokuqala isihloko," njengoba sibona, akuyona noyedwa imisebenzi ehlongozwayo. Ngenxa yalesi sisebenzisa inhlanganisela imisebenzi ngomumo eyenziwe, kodwa sibheke ngezansi. Okokuqala, sizohlaziya indlela yokwenza i-Excel izincwadi usonhlamvukazi kanye ezincane ngesisekelo imisebenzi engenhla.

Ukusebenza imisebenzi NGENHLA, EZINCANE, futhi OKUFANELE

Ukuze uqinisekise ngokushesha umphumela yonke imisebenzi emithathu kuseli A2 ukwethula Excel lokusebenzela string elula "apula antonovka fresh" (ngokukhethekile ngokuvumela uhlamvu ngokweqile dolobha ukuhlola umphumela umsebenzi). Ohlwini eduze, faka le ndlela elandelayo uphinde uqhathanise imiphumela:

Njengoba ubona, zonke izici Umsebenzi njengoba kuchaziwe.

Vumelanani ngokuthi, kuyoba elula Excel e uhlamvu lokuqala isihloko kuba ngakho futhi, ngokumane ukukhetha engenawo umsebenzi ofanayo, kodwa, ngeshwa, lokhu akunakwenzeka. Kufanele udale thina ifomula kwesokudla ... abelwe kule ngxenye ezithile.

Excel: uhlamvu lokuqala isihloko

Ukuze kuxazululwe le nkinga, kumelwe ngokunengqondo niwayise ngaphandle ngezigaba ehlukile. Kulokhu, yilezi ezilandelayo:

1. Khetha incwadi yokuqala embhalweni. Kuyadingeka ukuba acabangele ukuthi abasebenzisi ngokuvamile ukwenza izikhala extra ngaphambi kombhalo. Susa izikhala extra kuyosisiza umsebenzi NQUMA (umbhalo), bese ukhetha incwadi yokuqala - umsebenzi KWESOKUNXELE (umbhalo [Inombolo yamadijithi]) kanye agumenti yesibili isethwe ku 1 (ke kukhethwa ngokuzenzakalela, ukuze ukwazi ukukhipha).
2. Gqamisa uhlamvu lokuqala besebenzisa kuchazwa ngawo kulesi sigaba odlule NGENHLA umsebenzi ukuze uthumele isihloko ukubuka.
3. Times sidinga ngayo ukufeza umsebenzi omkhulu Excel «Incwadi yokuqala isihloko," kusho ukuthi wonke umbhalo kuyokwenziwa lifakwa. Kungakhathaliseki ukuthi isimo sinjani, manje kudingeka babiza uhlamvu lokuqala umbhalo asele. Ingabe-ke kuyosisiza umsebenzi KWESOKUDLA (umbhalo [Inombolo yamadijithi]) behlukene ekupheleni umbhalo izinombolo ezifanele. Futhi lokho, empeleni, kunjalo? Kufanele kube kakhulu ngendlela ubude string lokususa uhlamvu lokuqala, okungukuthi -1. Ngemva kokuqeda lezi zinyathelo, kufanele kuholele ifomu ngezinhlamvu ezinkulu.
4. It uhlala ukuxhuma imiphumela isigaba sesibili nesesithathu nge ampersand (&).

Lokhu ukulandelana yonke fix ethebuleni, uzokwenza ukuzwakala ukuthi umbhalo "apula Antonovka fresh" izikhala ezimbalwa.

Njengoba singabona, ukuxazulula inkinga Excel «Incwadi yokuqala isihloko," kwaba akunzima kangako, okubaluleke kakhulu, ukwethula zonke ngokulandelana okunengqondo izinyathelo.