Ungawahlanganisa kanjani amaseli kuspredishithi se-excel. Ngemenyu yokuqukethwe futhi ngaphandle kokulahlekelwa idatha

Ngesikhathi sokukhohlisa kusihleli sespredishithi se-Excel, kuvame ukuba kudingekile ukuhlanganisa amaseli. Kulula kakhulu ukusebenzisa le nqubo, ikakhulukazi uma amaseli engagcwalisiwe ngolwazi. Ezimeni lapho amaseli aqukethe idatha, isimo sihluka kancane. Kulesi sifundo, sizojwayelana nazo zonke izindlela ezisivumela ukuthi sisebenzise ukuhlanganisa amaseli.

Ihlanganisa amaseli kusihleli sesipredishithi

Inqubo kulula kakhulu ukuyisebenzisa futhi isetshenziswa ezimweni ezifana nalezi:

• Hlanganisa amaseli angenalutho;
• ukuhlanganisa amaseli ezimeni lapho okungenani kunenkambu eyodwa egcwele ulwazi.

Imiyalelo enemininingwane ibukeka kanje:

1. Ekuqaleni, sidinga ukukhetha amaseli esizowaxhuma namanye. Ukukhetha kwenziwa ngenkinobho yegundane engakwesokunxele. Esigabeni esilandelayo, sithuthela engxenyeni ethi "Ekhaya". Kulesi sigaba, sithola i-elementi enegama elithi "Hlanganisa futhi ubeke phakathi nendawo."

2. Le nketho ikuvumela ukuthi uhlanganise amaseli akhethiwe abe elilodwa, futhi ulwazi olungaphakathi kwawo lubekwe phakathi nendawo.

3. Uma umsebenzisi efuna ukuthi idatha ibekwe hhayi phakathi nendawo, kodwa ngendlela ehlukile, udinga ukuchofoza umcibisholo omncane omnyama, otholakala eduze kwesithonjana sokuhlanganisa iseli. Ohlwini oluya phansi, udinga ukuchofoza into ebizwa ngokuthi "Hlanganisa Amaseli".

4. Le nketho ikuvumela ukuthi uhlanganise amaseli akhethiwe abe elilodwa, bese ubeka ulwazi ngaphakathi kwawo ngakwesokudla.

5. Ukwengeza, kusihleli sethebula, kukhona ithuba lokuxhumeka kwentambo yamaseli. Ukuze usebenzise le nqubo, kuyadingeka ukukhetha indawo oyifunayo, ezohlanganisa imigqa eminingana. Bese udinga ukuchofoza kumcibisholo omncane omnyama, otholakala eduze kwesithonjana sokuxhuma kweseli. Ohlwini oluvulayo, udinga ukuchofoza entweni ebizwa ngokuthi "Hlanganisa ngemigqa".

6. Le nketho ikuvumela ukuthi uhlanganise amaseli akhethiwe abe elilodwa, futhi ugcine ukuhlukaniswa ngemigqa.

Ukuhlanganisa Amaseli Ngokusebenzisa Imenyu Yokuqukethwe

Ukusebenzisa imenyu yokuqukethwe okukhethekile kungenye indlela ekuvumela ukuthi usebenzise ukuhlanganisa amaseli. Imiyalelo enemininingwane ibukeka kanje:

1. Sikhetha ngosizo lwenkinobho yegundane kwesokunxele indawo edingekayo, esihlela ukuyihlanganisa. Okulandelayo, chofoza kwesokudla noma yikuphi ebangeni elikhethiwe. Kuvele imenyu yokuqukethwe encane esikrinini, lapho udinga ukuthola khona into enegama elithi “Ifomethi Yeseli…” bese uchofoza kuyo ngenkinobho yegundane engakwesokunxele.

2. Iwindi elisha livele esibukweni elibizwa ngokuthi “Fometha Amaseli”. Sithuthela esigatshaneni esithi "Ukuqondanisa". Sibeka uphawu eduze nombhalo othi "Hlanganisa amaseli". Ukwengeza, ungamisa amanye amapharamitha wokuhlanganisa kuleli windi. Ungakwazi ukwenza kusebenze ukudluliswa kolwazi lombhalo ngamagama, khetha isibonisi sokuma esihlukile, nokunye.. Ngemva kokwenza zonke izilungiselelo ezidingekayo, chofoza i-LMB engxenyeni ethi "KULUNGILE".

3. Ilungile! Indawo ekhethwe ngaphambilini iguqulelwe kuseli eyodwa.

Ukuhlanganisa amaseli ngaphandle kokulahlekelwa ulwazi

Uma amaseli evamise ukuxhunywa, yonke idatha engaphakathi kwawo iyasuswa. Ake sihlaziye ngokuningiliziwe indlela yokuqalisa inqubo yokuxhuma amaseli ngaphandle kokulahlekelwa ulwazi.

Ukuze senze lesi senzo, sidinga ukusebenzisa i-opharetha ethi CONCATENATE. Imiyalelo enemininingwane ibukeka kanje:

1. Ekuqaleni, sizosebenzisa ukungeza iseli elingenalutho phakathi kwamaseli esihlela ukuwaxhuma. Ukuze wenze le nqubo, kufanele uchofoze kwesokudla inombolo yekholomu noma umugqa. Imenyu yokuqukethwe ekhethekile ivele esikrinini. Chofoza i-LMB engxenyeni ethi "Faka".

2. Ukubuka okuvamile komsebenzisi: “=CONCATENATE(X;Y)". Izimpikiswano zomsebenzi zingamakheli amaseli azoxhunywa. Kudingeka senze umsebenzi wokuhlanganisa amaseli B2 no-D. Ngakho, sibhala ifomula elandelayo kuseli elingenalutho C2 elingeziwe: “=CONCATENATE(B2,D2). "

3. Njengomphumela, sithola inhlanganisela yolwazi kuseli esifake kulo ifomula engenhla. Siyaqaphela ukuthi ekugcineni sithole amaseli angu-3: 2 okuqala kanye nelilodwa elengeziwe, lapho ulwazi oluhlanganisiwe lutholakala khona.

4. Sidinga ukususa amaseli angafuneki. Le nqubo kufanele isetshenziswe ngokuchofoza kwesokudla kuseli C2, bese ukhetha into ethi “Kopisha” ohlwini lokudonsela phansi.

5. Manje siya endaweni engakwesokudla kwaleyo ekopishiwe. Kuleli seli elingakwesokudla, ulwazi lwangempela. Chofoza kwesokudla kuleli seli. Imenyu yokuqukethwe ekhethekile ivele esibukweni. Thola into ebizwa ngokuthi "Namathisela Okukhethekile" bese uchofoza kuyo ngenkinobho yegundane kwesokunxele.

6. Iwindi elibizwa ngokuthi "Namathisela Okukhethekile" livele esibukweni. Sibeka uphawu eduze kombhalo othi "Values". Ngemva kokwenza zonke izilungiselelo ezidingekayo, chofoza i-LMB engxenyeni ethi "KULUNGILE".

7. Ekugcineni, kuseli D2, sithole umphumela wensimu C2.

8. Manje usungakwazi ukusebenzisa ukukhishwa kwamaseli angadingekile B2 no-C2. Khetha lawa maseli, shayela imenyu yokuqukethwe ngenkinobho yegundane engakwesokudla, bese ukhetha into ethi "Susa".

9. Ngenxa yalokho, kwasala iseli kuphela endaweni yokusebenza, lapho kuboniswa khona ulwazi oluhlanganisiwe. Wonke amaseli avele ngesikhathi somsebenzi asusiwe, njengoba engasadingeki kudokhumenti.

Kuyaphawuleka ukuthi zonke izindlela ezingenhla zingasetshenziswa kokubili imigqa namakholomu.

Isiphetho

Sithole ukuthi inqubo yokuhlanganisa amaseli kulula ukuyisebenzisa. Ukuze uxhume amaseli, ugcine idatha yoqobo, kufanele usebenzise u-opharetha "CONCATENATE". Kuhle kakhulu ngaphambi kokuqala ukukhohlisa ukwenza ikhophi eyisipele yedokhumenti yokuqala ukuze uma kwenzeka iphutha ungakwazi ukubuyisela yonke into endaweni yayo futhi ungalahlekelwa ulwazi olubalulekile.