I-string concatenation ku-Microsoft Excel

Lapho usebenza namatafula, kwesinye isikhathi kufanele ushintshe ukwakheka kwawo. Umehluko owodwa wale nqubo i-concatenation yentambo. Ngasikhathi sinye, izinto ezihlanganisiwe ziphenduka umugqa owodwa. Ngaphezu kwalokho, kunethuba lokuhlela izinto ezisezingeni eliphansi eliseduze. Ake sibheke ukuthi yiziphi izindlela ongaqhuba ngazo lezi zinhlobo zokuhlanganisa eMicrosoft Excel.

Funda futhi:
Ungawahlanganisa kanjani amakholomu e-Excel
Ungawahlanganisa kanjani amaseli ku-Excel

Izinhlobo Zenhlangano

Njengoba kushiwo ngenhla, kunezinhlobo ezimbili eziyinhloko zokujoyina izintambo - lapho imigqa eminingana iguqulwa ibe munye nalapho ihlanganiswa khona. Esimweni sokuqala, uma izinto ezisemugqeni zigcwaliswe ngemininingwane, konke-ke kuyalahleka, ngaphandle kwalezo ezazitholakala entweni ephezulu kakhulu. Esimweni sesibili, ngokomugqa imigqa ihlala inhlobo efanayo, imane ihlanganiswe ngamaqembu lapho izinto zingafihlwa ngokuchofoza isithonjana ngendlela yesibonakaliso Susa. Kukhona enye inketho yokuxhuma ngaphandle kokulahleka kwedatha usebenzisa ifomula, esizoxoxa ngayo ngokwahlukana. Okungukuthi, kusuka ezinhlotsheni ezikhonjisiwe zokuguqulwa, kwakhiwa izindlela ezahlukahlukene zokuhlanganisa izitaki. Masihlale phezu kwabo ngemininingwane eminingi.

Indlela yoku-1: hlanganisa ngewindows format

Okokuqala, ake sibheke ukuthi kungenzeka yini ukuthi kuhlanganiswe imigqa eshidini ngewindi lokufometha. Kodwa ngaphambi kokuqhubeka nenqubo eqondile yokuhlanganisa, udinga ukukhetha imigqa eseduze ohlela ukuyihlanganisa.

1. Ukuqokomisa imigqa edinga ukuhlanganiswa, ungasebenzisa izindlela ezimbili. Eyokuqala yalokhu ukuthi ubamba inkinobho yesinxele yesinxele bese uhudula imikhakha yalezo zakhi kuphaneli yokuqondisa mpo ofuna ukuyihlanganisa. Zizogqanyiswa.

   

   Futhi, konke okukuphaneli elilodwa lokudidizela okuqondile kungachofoza kwesobunxele ngenombolo yokuqala yemigqa ehlanganisiwe. Bese uchofoza emgqeni wokugcina, kepha ngasikhathi sinye ubambe ukhiye I-Shift kwikhibhodi. Lokhu kuzogqamisa lonke uhla oluphakathi kwemikhakha emibili.



2. Ngemuva kokuthi uhla oludingekayo lukhethiwe, ungaqhubekela ngqo kwinqubo yokuhlanganisa. Ukuze wenze lokhu, chofoza kwesokudla noma kuphi lapho ukhetha khona. Imenyu yokuqukethwe iyavula. Sidlula kukho ngephuzu Uhlobo Lweseli.



3. Iwindi lokufomatha liyasebenza. Hambisa kuthebhu Ukuqondanisa. Bese kwiqembu lezilungiselelo "Khombisa" hlola ibhokisi eliseduze kwepharamitha I-Cell Union. Ngemuva kwalokho, ungachofoza inkinobho. "Kulungile" phansi kwewindi.



4. Ukulandela lokhu, imigqa ekhethiwe izohlanganiswa. Ngaphezu kwalokho, ukuhlanganiswa kwamaseli kuzokwenzeka kuze kube sekupheleni kweshidi.

Kukhona futhi ezinye izinketho zokuhambisa kufasitela lokufomatha. Isibonelo, ngemuva kokukhetha imigqa, ekubeni kuthebhu "Ikhaya", ungachofoza isithonjana "Ifomathi"etholakala kubambo ebhulokhi yamathuluzi "Amaseli". Ukusuka ohlwini olwehlayo lwezinto, khetha "Ifomethi yeseli ...".

Futhi kuthebhu efanayo "Ikhaya" ungachofoza umcibisholo we-oblique, otholakala ku-ribbon ekhoneni elingezansi kwesokudla sebhulokhi yamathuluzi Ukuqondanisa. Futhi kuleli cala, ukuguqulwa kuzokwenziwa ngqo kuthebhu Ukuqondanisa ukufometha amawindi, okungukuthi, umsebenzisi akudingeki enze uguquko olwengeziwe phakathi kwamathebhu.

Ungaya futhi efasiteleni lokufometha ngokucindezela inhlanganisela ye-hotkey I-Ctrl + 1, ngemuva kokuqokomisa izinto ezidingekayo. Kepha kulokhu, ukuguqulwa kuzokwenziwa kulelo windi lewindi Uhlobo Lweselieyagcina ukuvakashelwa.

Nganoma iyiphi inguqulo yokuguqukela kufasitela lokufometha, zonke izinyathelo ezengeziwe zokuhlanganisa imithungo kufanele zenziwe ngokuya nge-algorithm echazwe ngenhla.

Indlela 2: ukusebenzisa amathuluzi wetheyiphu

Ungahlanganisa futhi imicu usebenzisa inkinobho kubambo.

1. Okokuqala, sikhetha imigqa edingekayo nenye yalezo zinketho obekuxoxwa ngazo ngaphakathi Indlela 1. Ngemuva kwalokho siqhubekela kuthebhu "Ikhaya" bese uchofoza inkinobho kubambo "Hlanganisa nesikhungo". Itholakala kwibhulokhi yamathuluzi. Ukuqondanisa.



2. Ngemuva kwalokho, ibanga lomugqa olukhethiwe lizohlanganiswa kuze kube sekupheleni kweshidi. Kulokhu, konke okufakiwe okuzokwenziwa kulayini ohlanganisiwe kuzoba phakathi nendawo.

Kepha hhayi kuzo zonke izimo kuyadingeka ukuthi umbhalo ufakwe enkabeni. Yini okufanele uyenze uma idinga ukufakwa kwifomu elijwayelekile?

1. Sikhetha imigqa edinga ukuhlanganiswa. Hambisa kuthebhu "Ikhaya". Sichofoza iribhoni eceleni kukunxantathu, otholakala kwesokudla kwenkinobho "Hlanganisa nesikhungo". Uhlu lwezenzo ezahlukahlukene luyavula. Khetha igama Hlanganisa Amaseli.



2. Ngemuva kwalokho, imigqa izohlanganiswa ibe munye, futhi umbhalo noma amanani wokubala azobekwa njengoba kuhambisana nefomethi yenombolo yawo ezenzakalelayo.

Indlela 3: hlanganisa imigqa ngaphakathi kwetafula

Kepha kukude kakhulu njalo ukuhlanganisa imigqa kuze kube sekupheleni kweshidi. Imvamisa, ukujoyina kwenziwa ngaphakathi kwamalungu athile etafula. Ake sibheke ukuthi ungakwenza kanjani lokhu.

1. Khetha wonke amaseli emigqa yetafula esifuna ukuwahlanganisa. Lokhu kungenziwa nangezindlela ezimbili. Eyokuqala ukuthi ubambe inkinobho yegundane kwesobunxele bese unyakazisa isikhombisi endaweni yonke ukuthi ikhethwe.

   

   Indlela yesibili izoba lula ikakhulukazi lapho uhlanganisa uhlu olukhulu lwedatha emugqeni owodwa. Udinga uchofoze ngokushesha kuseli ephezulu kwesokunxele yobubanzi obuhlanganisiwe, bese ubamba inkinobho I-Shift - ngakwesokudla ngezansi. Ungenza okuphambene nalokhu: chofoza engaphezulu kwesokunxele nakwiseli ezingaphansi kwesokunxele. Umphumela uzofana ncamashi.



2. Ngemuva kokuthi ukukhetha sekuqediwe, qhubeka usebenzisa noma ikuphi ukukhetha okuchazwe ku Indlela 1ewindini lokufomatha iseli. Kuyo senza zonke izinto ezifanayo ezazingxoxo ngazo ngenhla. Ngemuva kwalokho, imigqa engaphakathi kwetafula izohlanganiswa. Kulesi simo, yidatha kuphela etholakala esitokisini esingenhla sobunxele sebanga elihlanganisiwe elizosindiswa.

Ukujoyina ngaphakathi kwemingcele yetafula nakho kungenziwa ngamathuluzi kubambo.

1. Senza ukukhethwa kwemigqa efiselekayo etafuleni nganoma iyiphi yalezi zinketho ezimbili ezichazwe ngenhla. Ngemuva kwalokho kuthebhu "Ikhaya" chofoza inkinobho "Hlanganisa nesikhungo".

   

   Noma chofoza unxantathu ongakwesobunxele wale nkinobho, ulandele ngokuchofoza entweni Hlanganisa Amaseli imenyu ye-pop-up.



2. Ukuhlanganiswa kuzokwenziwa ngokuya ngohlobo olukhethwe ngumsebenzisi.

Indlela 4: hlanganisa imininingwane ngemigqa ngaphandle kokulahlekelwa yidatha

Zonke izindlela ezingenhla zokuhlanganisa zisho ukuthi ngemuva kwenqubo eseqediwe, yonke imininingwane esezakhiweni ezihlanganisiwe izobhujiswa, ngaphandle kwaleyo etholakala esitokisini esingaphezulu kwesokunxele sendawo. Kepha kwesinye isikhathi kuyadingeka ngaphandle kokulahlekelwa ukuhlanganisa amanani athile akhiwe emigqeni ehlukene yetafula. Lokhu kungenziwa kusetshenziswa umsebenzi owenzelwe ngokukhethekile izinhloso ezinjalo. QHAFA.

Umsebenzi QHAFA kungokwesigaba sabasebenzisi bemibhalo. Umsebenzi wakhe ukuhlanganisa imigqa embalwa yombhalo entweni eyodwa. I-syntax yalomsebenzi imi kanje:

= I-CONNECT (umbhalo1; umbhalo2; ...)

Izimpikiswano zeqembu "Umbhalo" kungaba ngumbhalo ohlukile noma izixhumanisi zezakhi zeshidi elikuyo. Yimpahla yokugcina ezosetshenziswa yithi ukuqeda umsebenzi. Sekukonke, kuze kufinyelele ku-255 izingxabano ezinjalo zingasetshenziswa.

Ngakho-ke, sinethebula lapho kuboniswa khona uhlu lwemishini yamakhompyutha enentengo yalo. Sibhekene nomsebenzi wokuhlanganisa yonke imininingwane etholakala kwikholamu "Idivayisi", kulayini owodwa ngaphandle kokulahleka.

1. Sibeka ikhesa kuhlu lweshidi lapho kuzovela khona umphumela wokucutshungulwa, bese uchofoza inkinobho "Faka umsebenzi".



2. Ukuqala Umsebenzi Wizards. Kufanele sithuthele esivimbweni sabasebenzisi "Umbhalo". Okulandelayo sithola bese ukhetha igama Xhuma. Bese uchofoza inkinobho "Kulungile".



3. Kuvela iwindi lezingxabano zomsebenzi QHAFA. Ngenombolo yokuphikisana, ungasebenzisa izinkambu ezifika kwangama-255 ezinegama "Umbhalo", kepha ukwenza umsebenzi esiwudingayo njengoba netafula linemigqa. Kulokhu, kukhona abangu-6. Setha isikhombisi esigangeni "Umbhalo1" futhi, ubambe inkinobho yegundane kwesobunxele, chofoza kulokho kokuqala okuqukethe igama lemishini ekholamu "Idivayisi". Ngemuva kwalokho, ikheli lezinto ezikhethiwe lizokhonjiswa enkombeni yewindi. Ngendlela efanayo, sifaka amakheli wezinto ezilandelayo zomugqa "Idivayisi", ngokulandelana, emasimini "Umbhalo2", "Umbhalo3", "Umbhalo4", "Umbhalo5" futhi "Umbhalo6". Ngemuva kwalokho, lapho amakheli wazo zonke izinto aboniswa emasimini wewindi, chofoza inkinobho "Kulungile".



4. Ngemuva kwalokho, umsebenzi uzokhombisa yonke imininingwane emgqeni owodwa. Kepha, njengoba sibona, akukho mahluko phakathi kwamagama ezimpahla ezahlukahlukene, futhi lokhu akusifaneli. Ukuze uxazulule le nkinga, khetha umugqa oqukethe ifomula, bese uphinde uqhafaze inkinobho "Faka umsebenzi".



5. Iwindi lokuphikisana liqala futhi kulokhu ngaphandle kokushintshela kokuqala Isici Wizard. Ensimini ngayinye yewindows evulayo, ngaphandle kwelokugcina, ngemuva kwekheli leseli, engeza le nkulumo elandelayo:

   &" "

   Le nkulumo uhlobo lohlamvu lwesikhala somsebenzi. QHAFA. Kungakho kungadingeki ukuyengeza enkampanini yesithupha yokugcina. Ngemuva kokuthi inqubo ebekiwe isiqediwe, chofoza inkinobho "Kulungile".



6. Ngemuva kwalokho, njengoba sibona, yonke imininingwane ayibeki kuphela kulayini owodwa, kepha futhi ihlukaniswe yisikhala.

Kukhona enye inketho yokufeza inqubo ekhonjisiwe yokuhlanganisa idatha kusuka emigqeni eminingana iye kwenye ngaphandle kokulahleka. Kulokhu, ngeke udinge nokusebenzisa umsebenzi, kepha ungenza ngefomula ejwayelekile.

1. Setha uphawu "=" kulayini lapho umphumela uzokhonjiswa khona. Chofoza entweni yokuqala yekholamu. Ngemuva kokuthi ikheli lakhe liboniswe kubha yefomula neseli lokukhishwayo lemiphumelo, sithayipha le nkulumo elandelayo kwikhibhodi:

   &" "&

   Ngemuva kwalokho chofoza engxenyeni yesibili yekholomu bese uphinde ufake isisho esingenhla. Ngakho-ke, sicubungula wonke amaseli lapho idatha kufanele ibekwe khona kulayini owodwa. Kithina, le nkulumo yavela:

   = A4 & "" A5 & "" & A6 & "" & A7 & "" A8 & "" A9



2. Ukubonisa umphumela esikrinini, chofoza inkinobho Ngena. Njengoba ukwazi ukubona, ngaphandle kokuthi kusetshenziswe ifomula ehlukile kuleli cala, inani lokugcina liboniswa ngendlela efanayo nalapho usebenzisa umsebenzi QHAFA.

Isifundo: Umsebenzi we-EXCEL

Indlela yesi-5: Ukuhlanganisa amaqembu

Ngaphezu kwalokho, ungahlanganisa izintambo ngaphandle kokulahlekelwa ubuqotho babo bokuhleleka. Ake sibheke ukukwenza.

1. Okokuqala, sikhetha lezo zinto ezisezingeni eliphansi ezisondelene ezidinga ukuhlukaniswa. Ungakhetha amaseli ngamanye ngemigqa, futhi hhayi imigqa ephelele. Ngemuva kwalokho, iya kuthebhu "Idatha". Chofoza inkinobho "Iqembu"elibekwe endaweni yethuluzi "Isakhiwo". Kuluhlu oluncane olwethuliwe lwezinto ezimbili, khetha isikhundla "Iqembu ...".



2. Ngemuva kwalokho, kuvuleka iwindi elincane lapho kufanele ukhethe khona ukuthi yini ngempela esizoba yiqembu: imigqa noma amakholomu. Njengoba sidinga ukuhlela imigqa, sihlela kabusha ukushintshela endaweni efanele bese uchofoza inkinobho "Kulungile".



3. Ngemuva kwesenzo sokugcina, imigqa eseceleni ekhethiwe izohlanganiswa neqembu. Ukuyifihla, chofoza nje isithonjana ngesimo sophawu Susaetholakala kwesobunxele sepaneli yokuqondisa mpo.



4. Ukuze ubonise izinto eziqoqiwe futhi, kuzodingeka uchofoze uphawu "+" kwakheka endaweni efanayo lapho uphawu lwalukade likhona ngaphambili "-".

Isifundo: Ungenza kanjani iqembu e-Excel

Njengoba ukwazi ukubona, indlela yokuhlanganisa izintambo ibe yinye kuya ngokuthi hlobo luni lokuhlangana umsebenzisi aludingayo nokuthi yini afuna ukuyithola. Ungahlanganisa imigqa kuze kube sekupheleni kweshidi, ngaphakathi kwetafula, wenze inqubo ngaphandle kokulahlekelwa idatha usebenzisa umsebenzi noma ifomula, bese uhlela imigqa. Ngaphezu kwalokho, kunezinketho ezihlukile zokwenza le misebenzi, kepha kuphela okuthandwa ngumsebenzisi ngokuya ngokuvumela osekuvele kunomthelela ekukhetheni kwabo.