CONCATENATE umsebenzi ku-Excel. Ungakuhlanganisa kanjani okuqukethwe kweseli ku-Excel usebenzisa i-CONCATENATE

Kunomsebenzi okhethekile othi CONCATENATE kuphrosesa yesipredishithi, esebenzisa inyunyana yokuqukethwe kwamaseli angu-2 noma ngaphezulu. Ikhono lokusebenzisa lo opharetha likuvumela ukuthi usebenze ngokuphumelelayo nangokushesha kumanani amaningi edatha efomini lethebula. Ake sibhekisise ukusebenza komsebenzisi we-CONCATENATE.

Incazelo kanye ne-syntax yomsebenzi we-CONCATENATE

Kusukela ngo-2016, lo msebenzi waqanjwa kabusha kusipredishithi futhi waziwa ngokuthi “SCEP”. Abasebenzisi abajwayele igama lokuqala bangaqhubeka nokusebenzisa okuthi “CONCATENATE” njengoba uhlelo lubabona ngendlela efanayo. Ukubuka okujwayelekile komsebenzisi: =SCEP(umbhalo1;umbhalo2;…) or =CONCATENATE(umbhalo1,umbhalo2,…).

Kubalulekile! 255 inani eliphezulu elingenzeka lama-agumenti omsebenzi. Amanani amakhulu awanakwenzeka. Ukuzama ukusebenzisa izimpikiswano eziningi kuzoholela ephutheni.

Ukufaka kanye Nokusetha Umsebenzi

Abasebenzisi besipredishithi abanolwazi bayazi ukuthi ngokuhlanganisa amaseli amaningana abe yinye, idatha yazo zonke izingxenye iyasulwa, ngaphandle kwephezulu kwesokunxele. Umsebenzi we-CONCATENATE uvimbela lokhu. I-Walkthrough ibonakala kanje:

1. Sikhetha umkhakha esifuna ukwenza kuwo inqubo yokuhlanganisa. Yikhethe bese uya engxenyeni ethi "Faka Umsebenzi".

2. Iwindi elincane elibizwa ngokuthi “Faka Umsebenzi” liboniswe esikrinini. Nweba uhlu eduze kokuthi “Izigaba:” bese uchofoza “Umbhalo”. Okulandelayo, khetha "SCEP" bese uchofoza inkinobho "OK".

3. Kuvele iwindi elisha, eliklanyelwe ukucacisa ama-agumenti omsebenzi. Lapha ungafaka kokubili izinkomba ezithile kanye nereferensi yeseli. Amakheli angafakwa ngokuzimela ngokuwafaka mathupha noma ngokuchofoza amaseli ekhasini lokusebenza.
4. Sithuthela kulayini "Umbhalo1" bese uchofoza umkhakha A2.

5. Sithuthela emgqeni othi “Text2”, faka u-“, ” (ukhefana nesikhala) lapho ukuze uhlukanise izimpikiswano.

6. Sithuthela kulayini "Umbhalo3" bese uchofoza umkhakha B2.

7. Ngendlela efanayo, sigcwalisa izimpikiswano ezisele, bese uchofoza "KULUNGILE". Endaweni engezansi yewindi ungabona umphumela wokuqala.

8. Ukuqaliswa kokuhlanganiswa kwayo yonke imikhakha ekhethiwe kube yimpumelelo.

9. Asikho isidingo sokuphinda ukukhohlisa okufanayo emikhakheni yekholomu esele ngezansi. Udinga nje ukuhambisa ikhesa yegundane ekhoneni elingezansi kwesokudla lomkhakha ngomphumela obonisiwe. Isikhombi sizothatha isimo sophawu oluncane lokuhlanganisa. Bamba i-LMB bese uhudulela uphawu lokuhlanganisa phansi emgqeni ophansi kakhulu wekholomu.

10. Ngenxa yalokho, sithole ikholomu egcwele idatha entsha.

Lena bekuyindlela ejwayelekile kakhulu yokusebenzisa umsebenzi we-CONCATENATE. Okulandelayo, sizocubungula ngokuningiliziwe izindlela ezahlukahlukene zokuxhumanisa imikhakha kanye nezinkomba zokuhlukanisa phakathi kwazo.

Ungawusebenzisa kanjani umsebenzi we-CONCATENATE ku-Excel

Ake sihlaziye ngemininingwane eminingi ngangokunokwenzeka izindlela ezinhlanu zokusebenzisa umsebenzi we-CONCATENATE kusipredishithi.

Indlela 1: Hlanganisa idatha kumaseli

Umhlahlandlela Wokuhlanganisa Idatha Isinyathelo Ngesinyathelo:

1. Senza ukukhetha kweseli lapho sifuna ukubonisa khona amanani ahlanganisiwe. Sichofoza into ethi "Faka umsebenzi", etholakala eduze komugqa wokufaka amafomula.

2. Iwindi le-Function Wizard liyavela esibukweni. Khetha isigaba "Sombhalo", bese uthola umsebenzi othi "CONCATENATE". Ngemva kokuqeda zonke izikhohlisi, chofoza "OK".

3. Iwindi lokuphikisana elijwayelekile liboniswe esikrinini. Sifaka i-pointer emgqeni wokuqala wefasitela. Okulandelayo, ekhasini lokusebenza, khetha isixhumanisi esiqukethe idatha edingekayo ukuze kuhlanganiswe. Senza izenzo ezifanayo ngomugqa wesi-2, sigqamisa omunye umkhakha. Senza lokhu kuqondisa kuze kube yilapho amakheli ayo yonke imikhakha efakwa ebhokisini lezimpikiswano. Ngemva kokuqeda zonke izinyathelo, chofoza "OK".

4. Ngenxa yalokho, idatha yemikhakha ekhethiwe yaboniswa emkhakheni owodwa okhethwe kusengaphambili. Ububi obukhulu bale ndlela ukuthi yonke idatha iboniswa ndawonye, ​​ngaphandle kwanoma yiziphi izihlukanisi. Ngeke kusebenze ukungeza izihlukanisi ngokwakho, ngaphandle kokushintsha ifomula.

Indlela yesi-2: Ukusebenzisa umsebenzi onesikhala

Lokhu kushiyeka kulungiswa kalula ngokungeza izikhala phakathi kwama-agumenti omsebenzi. I-Walkthrough ibonakala kanje:

1. Senza izenzo ezichazwe ku-algorithm ethulwe ngenhla.
2. Sichofoza kabili i-LMB emkhakheni ngefomula ukuvumela ushintsho lwayo.

3. Faka izikhala phakathi kwamanani kuzimpawu zokucaphuna. Isisho ngasinye esinjalo kufanele sigcine ngesemikholoni. Umphumela kufanele kube inkulumo elandelayo: “”;

4. Cindezela inkinobho ethi "Enter" kukhibhodi.
5. Ilungile! Kwavela izikhala phakathi kwamanani, futhi ulwazi olubonisiwe lwaqala ukubukeka luhle kakhulu.

Indlela yesi-3: Ukwengeza Isikhala Ngefasitela Lezingxabano

Indlela engenhla ifaneleka kuphela ezimweni lapho kungekho idatha eningi. Uma usebenzisa indlela enjalo yokuhlukanisa ngenani elikhulu lolwazi, khona-ke ungalahlekelwa isikhathi esiningi. Indlela elandelayo ikuvumela ukuthi ubeke izikhala ngokushesha okukhulu usebenzisa iwindi lezimpikiswano. I-Walkthrough ibonakala kanje:

1. Sithola noma yimuphi umkhakha ongenalutho ekhasini lokusebenza bese uchofoza kabili kuwo nge-LMB, ufake isikhala ngaphakathi kulo. Kungcono ukuthi umkhakha utholakala kude nepuleti elikhulu. Iseli elikhethiwe akufanele nanini ligcwaliswe nganoma yiluphi ulwazi.

2. Sisebenzisa i-algorithm yezenzo kusukela ezindleleni zangaphambilini ukuze sifike ewindini lezimpikiswano zomsebenzi. Njengasezindleleni ezedlule, sifaka inani lomkhakha wokuqala ngedatha emkhakheni wokuqala. Okulandelayo, khomba umugqa wesibili futhi ubonise ikheli lomkhakha esisanda kungena kuwo isikhala. Ukusheshisa kakhulu inqubo, ungakopisha inani lomkhakha usebenzisa inhlanganisela "Ctrl + C".

3. Okulandelayo, faka ikheli lomkhakha olandelayo. Emkhakheni olandelayo, engeza ikheli lomkhakha ongenalutho futhi. Siphinda izenzo ezifanayo kuze kuphele idatha esethebulani. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK".

Ngenxa yalokho, sithole irekhodi elihlanganisiwe, idatha ehlukaniswa yisikhala.

Indlela yesi-4: Ukuhlanganisa amakholomu

I-CONCATENATE opharetha ikuvumela ukuthi uhlanganise amanani amakholomu amaningana abe yinye. I-Walkthrough ibonakala kanje:

1. Ngemikhakha yomugqa wokuqala wamakholomu ahlanganisiwe, sisebenzisa ukukhohlisa okufanayo okuboniswa kusibonelo sesi-2 nesi-3. Kuhle ukusho ukuthi uma ufuna ukusebenzisa indlela enomkhakha ongenalutho, udinga ukwenza inkomba yohlobo oluphelele kuyo. Ukuze wenze lokhu, yandulela zonke izimpawu zokuxhumanisa ngophawu “$”. Ezinye izinkambu zihlala zihlobene. Ngemuva kokwenza konke ukukhohlisa, chofoza into ethi "OK".

2. Hambisa phezulu ekhoneni elingezansi kwesokudla lomkhakha ngefomula. Ngemva kokuba i-pointer ithatha uhlobo lophawu lokuhlanganisa, ngokubamba inkinobho yegundane kwesokunxele selula umaka phansi kakhulu kwetafula.

3. Ngemva kokuqaliswa kwale nqubo, ulwazi olukhonjiswe kumakholomu luzohlanganiswa lube ikholomu eyodwa.

Indlela yesi-5: Ukwengeza Izinhlamvu Eziningi

Umsebenzisi we-CONCATENATE usetshenziselwa ukufaka izinkulumo nezinhlamvu ezengeziwe ebezingekho endaweni yokuhlanganisa yasekuqaleni. Kubalulekile ukuqaphela ukuthi ngenxa yalesi sisebenzisi, ungakwazi ukushumeka eminye imisebenzi ye-spreadsheet processor. Isifundo sesinyathelo ngesinyathelo sibukeka kanje:

1. Sisebenzisa ukukhohlisa ukuze singeze amanani efasiteleni lezimpikiswano kusukela ezindleleni ezichazwe ngenhla. Kunoma iyiphi yezinkambu sifaka ulwazi lombhalo olungenasizathu. Okubalulekile kombhalo kumele kuzungezwe izimpawu zokucaphuna nhlangothi zombili.
2. Ngemva kokuqeda zonke izinyathelo, chofoza "OK".

3. Ngenxa yalokho, emkhakheni okhethiwe, kanye nedatha ehlanganisiwe, ulwazi lombhalo olufakiwe luvele.

Umsebenzi ophambene we-CONCATENATE ku-Excel

Kunama-opharetha amaningana akuvumela ukuthi uhlukanise amanani weseli eyodwa. Izibonelo zomsebenzi:

1. KWESOKUNXELE. Ikhipha ingxenye eshiwo yezinhlamvu kusukela ekuqaleni komugqa. Ukubuka okulinganiselwe: =LEVSIMV(A1;7), lapho u-7 eyinombolo yezinhlamvu okufanele zikhishwe kuyunithi yezinhlamvu.

2. KWESOKUDLA. Ikhipha ingxenye eshiwo yezinhlamvu kusukela ekugcineni kweyunithi yezinhlamvu. Ukubuka okulinganiselwe: =RIGHTSIMV(A1;7), lapho u-7 eyinombolo yezinhlamvu okufanele zikhishwe kuyunithi yezinhlamvu.

3. PSTR. Ibonisa ingxenye eshiwo yezinhlamvu, iqala endaweni eshiwo. Ukubuka okulinganiselwe: =I-PSTR(A1;2;3), lapho u-2 eyindawo lapho isizinda siqala khona, futhi u-3 uyinombolo yezinhlamvu ezizokhishwa ochungechungeni.

Ukuhlela umsebenzi

Kwenzeka ukuthi opharetha usevele engeziwe, kodwa ezinye izinguquko zidinga ukwenziwa kuyo. Lokhu kungenziwa ngezindlela ezimbili. Inketho yokuqala:

1. Khetha iseli elinomsebenzi oqediwe bese uchofoza into ethi "Faka Umsebenzi", etholakala eduze komugqa wokufaka amafomula.

2. Kuvele iwindi elijwayelekile lokufaka ama-agumenti ka-opharetha. Lapha ungenza zonke izinguquko ezidingekayo. Ekugcineni, chofoza "OK".

Inketho yesibili:

1. Chofoza kabili emkhakheni ngefomula bese uya ekushintsheni imodi.

2. Silungisa amanani emkhakheni ngokwawo.

Kungakhathalekile ukuthi iyiphi inketho esetshenzisiwe, lapho uhlela ngesandla, kufanele uqaphele ngangokunokwenzeka ukuze ugweme amaphutha.

Nakani! Izixhumanisi zomkhakha kufanele zifakwe ngaphandle kwamakhwothi, futhi izimpikiswano kufanele zifakwe ohlwini zihlukaniswe ama-semicolon.

CONCATENATE umsebenzi wenombolo enkulu yamaseli

Uma usebenza nenani elikhulu lamaseli, uhlu lwedatha lucaciswa njengereferensi. I-Walkthrough ibonakala kanje:

1. Ake sicabange ukuthi idatha yethu itholakala kulayini owodwa (owesihlanu emugqeni).
2. Faka lonke ububanzi ukuze uhlangane emkhakheni ongenalutho bese wengeza isikhala ngophawu lwe-ampersand.

3. Cindezela inkinobho ethi "F9". Ifomula ikhipha umphumela wokubala.
4. Kwengezwe isikhala kuwo wonke amagama, kanye no “;” kwakheka phakathi kwabo. Sikhipha abakaki abangadingekile futhi sifaka lolu hlu kufomula.

5. Ngemuva kokwenza konke ukukhohlisa, cindezela inkinobho ethi "Enter".

Ixhuma umbhalo nosuku

Ngokusebenzisa umsebenzi we-CONCATENATE, ungahlanganisa ulwazi lombhalo nedethi. I-Walkthrough ibonakala kanje:

1. Ukuze uhlanganise okulungile, udinga kuqala ukufaka idethi ku-opharetha we-TEXT. Umsebenzisi ikuvumela ukuthi ufomethe inombolo.
2. DD.MM.YY inani. inquma ukuthi idethi izobukeka kanjani. Isibonelo, uma ufaka u-YY esikhundleni sika-YYYY, unyaka uzoboniswa njengamadijithi amane esikhundleni samabili.

Kuyaphawuleka ukuthi ungakwazi ukwengeza ulwazi lombhalo olwazini lwezinombolo hhayi kuphela usebenzisa i-CONCATENATE opharetha, kodwa futhi usebenzisa ifomethi yenombolo yangokwezifiso.

Ividiyo yokusebenza komsebenzi

Uma imiyalelo engenhla inganele ukuqonda ukuthi umsebenzi we-CONCATENATE usebenza kanjani, ngakho-ke sincoma ukuthi uhlole amavidiyo alandelayo akutshela ukuthi uwahlanganisa kanjani amaseli ngendlela efanele ngaphandle kokulahlekelwa ulwazi:

Ngemuva kokubuka imiyalo yevidiyo, uzobona ngokucacile ukuthi lo msebenzi usebenza kanjani usebenzisa izibonelo, funda ngama-nuances ahlukahlukene okusebenzisa opharetha futhi wengeze ulwazi lwakho ngakho.

Isiphetho

Umsebenzi we-CONCATENATE iyithuluzi lesipredishithi eliwusizo elikuvumela ukuthi uhlanganise imikhakha ngaphandle kokulahlekelwa idatha. Ikhono lokusebenzisa opharetha lizosiza abasebenzisi ukuthi bonge kakhulu isikhathi lapho besebenza ngenani elikhulu lolwazi.