Ungawahlanganisa kanjani amakholomu amabili ku-Excel ngaphandle kokulahlekelwa idatha

Kulesi sihloko esifushane, uzofunda indlela ephumelelayo yokuhlanganisa amakholomu amaningi ku-Excel ukuze yonke idatha edingekayo igcinwe.

Ake sithi une-spreadsheet esiqukethe amakholomu amabili abekwe phezu kwelinye. Isibonelo, udinga ukuhlanganisa amakholomu negama lokuqala nesibongo libe elilodwa noma uhlanganise amakholomu amaningana namagama-ncazo athi “street”, “city”, “zip code” libe elilodwa – “ikheli lokuhlala”, ukuze uhlukanise amanani anekhefana. Kungenziwa kanjani lokhu?

Ngeshwa, i-Excel ayinawo umsebenzi owakhelwe ngaphakathi okuvumela ukuthi wenze lokhu esikushilo ngenhla. Vele, kukhona inkinobho ethi "Hlanganisa Amaseli" nabanye abayithandayo, kepha amanani angu-uXNUMXbuXNUMXbare alahlekile.

Isexwayiso esilandelayo sizoboniswa:

1. I-Excel 2013 izothi kuphela inani elikuseli eliphezulu kwesokunxele lobubanzi elizogcinwa kuseli elihlanganisiwe. Yonke enye idatha izosuswa. 
2. I-Excel 2010 nangaphansi izobonisa isixwayiso esinencazelo efanayo kodwa amagama ahluke kancane.

Lokhu kubeka imingcele engathi sína ekusetshenzisweni kohlelo futhi kwenza kungenzeki ukwenza imisebenzi ngempumelelo.

Okulandelayo, uzofunda izindlela ezi-3 zokuhlanganisa idatha esuka kumakholomu amaningi ibe eyodwa ukuze ungalahlekelwa idatha (ngaphandle kokusebenzisa amamakhro). Uma ufuna indlela elula, ungeqa izindlela ezimbili zokuqala futhi ufunde eyesithathu kuphela.

Ukuhlanganisa amakholomu amaningi usebenzisa ifomula

Ake sithi unetafula elinolwazi ngamakhasimende, futhi umphathi usethe umsebenzi wokuhlanganisa amakholomu «Igama» и «Isibongo» munye "Igama eligcwele". Ukuze wenze lokhu, kufanele wenze ukulandelana kwezenzo ezilandelayo:

1. Faka ikholomu eyengeziwe kuthebula. Ukuze wenze lokhu, beka ikhesa esihlokweni sekholomu (kithi, iyikholomu D) bese uchofoza kuyo kwesokudla. Imenyu yokuqukethwe izovela lapho udinga ukukhetha khona into "Faka". Masibize ikholomu ewumphumela "Igama eligcwele", elihumusha ngokuthi "Igama eligcwele".
2. Okulandelayo, kuseli D2, udinga ukubhala ifomula elandelayo: =CONNATENATE(B2;” “;C2) . Esimweni sethu, i-B2 yikheli leseli elinegama lokuqala, futhi i-C2 yikheli leseli elinesibongo. Ungakwazi futhi ukubona isithonjana sesikhala phakathi kwezingcaphuno lapho. Kuleli qophelo, kubhalwa isihlukanisi, sibekwe phakathi kokuqukethwe kweseli lokuqala nelesibili. Uma udinga ukuhlukanisa izakhi ngokhefana (isibonelo, ukuze ucacise ikheli eligcwele), ungayibhala njengempikiswano yesibili yomsebenzi. Ungakwazi ukuhlanganisa amakholomu amaningana wenze eyodwa usebenzisa noma yisiphi esinye isihlukanisi.
3. Leli fomula libe selikopishelwa kuwo wonke amanye amaseli kuleyo kholomu. Ukuze uqonde ukuthi ungakwenza kanjani lokhu, ungasebenzisa umyalo othi “Indlela yokufaka ifomula efanayo kuwo wonke amaseli akhethiwe” (bheka isihloko esikuwebhusayithi yethu).
4. Ngakho-ke amakholomu amabili ahlanganiswe abe yinye, kodwa kuseyifomula. Ngakho-ke, uma ususa ikholomu yesibongo sokuqala, ulwazi olukukholomu yegama eligcwele nalo luzolahleka.
5. Manje sidinga ukushintsha ifomula kuseli ibe inani elenziwe ngomumo ukuze sikwazi ukususa amakholomu engeziwe kudokhumenti. Ukuze wenze lokhu, khetha wonke amaseli anolwazi lwekholomu ehlanganisiwe (khetha iseli lokuqala kukholamu D kithi bese ucindezela inhlanganisela yokhiye. U-Ctrl + Shift + Umcibisholo Waphansi; bese udinga ukukopisha idatha kumakholomu bese uchofoza kwesokudla kunoma iyiphi iseli kule kholomu bese uchofoza okuthi "Namathisela Okukhethekile". Khetha into kwesokunxele sewindi “Amanani” bese ucindezela inkinobho "KULUNGILE".
6. Manje usungakwazi ukususa amakholomu okuqala. Ukuze wenze lokhu, udinga ukuchofoza egameni lekholomu B, bese ucindezela inkinobho ethi Ctrl bese wenza okufanayo ngekholomu C. Lokhu kuyadingeka ukuze ukhethe wonke lawa makholomu. Ungasebenzisa futhi inhlanganisela yokhiye u-Ctrl + Space ukuze ukhethe yonke ikholomu, bese ucindezela u-Ctrl + Shift + Umcibisholo Wesokudla, kopisha okukhethiwe kukholamu eseduze C. Okulandelayo, imenyu yokuqukethwe ivula ngokuchofoza kwesokudla kwenye yezikhethiwe. amakholomu, bese udinga ukuchofoza entweni "Susa".

Manje amagama avela kumakholomu amaningana ahlanganisiwe aba linye. Nakuba kuthatha isikhathi, khona kanye ukulandelana kwezenzo kucace ngisho nakumuntu osaqalayo.

Ixhuma amakholomu kusetshenziswa i-Notepad

Le ndlela izothatha isikhathi esincane ukuqeda kunenketho yangaphambilini, futhi awekho amafomula okudingeka asetshenziswe. Kodwa ilungele kuphela ukuxhuma amakholomu aseduze, futhi futhi uma kusetshenziswa isihlukanisi esisodwa (isibonelo, ikhoma kuphela).

Ake sithi sidinga ukuhlanganisa amakholomu afanayo nesibonelo sangaphambilini. Ukuze wenze lokhu, landela le miyalo:

1. Khetha wonke amakholomu azoxhunywa. Ukufeza lo msebenzi, khetha iseli B1 bese ucindezela inhlanganisela yokhiye u-Shift + Umcibisholo Wesokudla. Khona-ke ukukhethwa kuzophinde kufake iseli elingumakhelwane C1. Ngemva kwalokho, udinga ukucindezela inhlanganisela Ctrl + Shift + Umcibisholo Waphansi ukuze uhambise okukhethiwe ekupheleni kwamakholomu.
2. Dlulisa idatha ebhodini lokunamathisela (ngamanye amazwi, likopishe). Ukuze wenze lokhu, cindezela inhlanganisela yokhiye Ctrl + C noma usebenzise noma iyiphi enye indlela.
3. Yethula uhlelo lwe-Notepad, oluza olujwayelekile neWindows. Ikwimenyu yokuqala. Umzila oqondile ungahluka kancane kuye ngenguqulo yesistimu yokusebenza. Kodwa ukuthola uhlelo akunzima kunoma yikuphi. 
4. Dlulisela idatha ekopishiwe ku-Notepad usebenzisa inhlanganisela yokhiye u-Ctrl + V.
5. Cindezela inkinobho ethi Tab bese ukopisha lolu hlamvu.
6. Okulandelayo, buyisela lolu hlamvu nganoma yiluphi olunye usebenzisa ibhokisi lengxoxo "Faka esikhundleni".
7. Khetha wonke umbhalo, uwukopishe.
8. Buyela ku-Excel, khetha iseli eyodwa (B1 kithi) bese unamathisela umbhalo etafuleni.

Kusele kuphela ukuqamba kabusha ikholomu.

Ungawahlanganisa kanjani amakholomu amabili ngezinyathelo ezi-4 ezilula?

Ukwenza lokhu:

1. Thwebula i-addon ekhethekile. 
2. Khetha amakholomu amabili bese uya kuthebhu ethi “Ablebits.com Data”. Chofoza inkinobho ethi "Hlanganisa Amaseli".
3. Khetha izinketho eziboniswe esithombeni.
4. Izinyathelo ezimbalwa ezilula, futhi sithola umphumela omuhle kakhulu ngaphandle kokukhohlisa okwengeziwe.

Ukuze uqedele, vele uqambe kabusha ikholomu B ukuze ithi “Igama Eligcwele” bese ukhipha ikholomu C, engasadingeki.