I-Excel QAPHELA ukusebenza

01 ka 01

Hlanganisa Amaseli Wombhalo Idatha ku-Excel

Ukubhekwa kokuqukethwe

I-Concatenate kusho ukuhlanganisa noma ukujoyina ndawonye izinto ezimbili noma ngaphezulu ezibekwe eceleni endaweni entsha nomphumela ukwelashwa njengenhlangano eyodwa.

Esikhathini se-Excel, ukubonisana ngokuvamile kubhekisela kokuhlanganiswa kokuqukethwe kwamaseli amabili noma ngaphezulu kushidi lokusebenzela ukuya kwesithathu, iseli elihlukile usebenzisa:

• umsebenzi oqanjwe ngomsebenzi - imigqa eyodwa, ezine, nesithupha esithombeni esingenhla;
• besebenzisa opharetha bokuncintisana - i-ampersand ( & ) - imigqa emibili namhlanu ngaphezulu.

Ukungeza Izikhala Emibhalweni Ekhonjisiwe

Ayikho indlela yokwazisa okushiya ngokuzenzakalelayo isikhala esingenalutho emkhatsini wamazwi, okuhle uma ujoyina izingxenye ezimbili zegama eliyinkimbinkimbi njengebhola leBhola libe lilodwa noma lihlanganisa izinombolo ezimbili zezinombolo ezinjenge- 123456 .

Uma ujoyina amagama okuqala noma okugcina noma ikheli, noma kunjalo, udinga isikhala ngakho isikhala kumele sifakwe kwifomula ye-concatenation - imigqa emine, emihlanu, nangaphezulu ayisithupha ngenhla.

I-syntax ye-Function and Arguments ye-CONCATENATE

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.

I-syntax yomsebenzi we-CONCATENATE yile:

= QAPHELA (Umbhalo1, Umbhalo2, ... Umbhalo255)

I-Text1 - (edingekayo) ingaba umbhalo wangempela njengamazwi noma izinombolo, izikhala ezingenalutho ezizungezwe ngamakhophi wokucaphuna, noma izinkomba zesitokisi endaweni yedatha kushidi

Umbhalo2, Umbhalo3, ... Umbhalo255 - (okukhethwa kukho) kuze kufinyelele ku-255 umbhalo ongenayo ungangeniswa emsebenzini we-CONCATENATE kuze kube nezinhlamvu ezingaphezu kuka-8 192 - kuhlanganise nezikhala. Ukungena ngakunye kumele kuhlukaniswe ngomahlaya.

Ukuqhathanisa idatha yezinombolo

Ngisho noma izinombolo zingahle zikhonjiswe - njengoba kuboniswe emgqeni ayisithupha ngenhla - umphumela 123456 awusabhekwa njengenombolo ngohlelo kodwa manje ubonakala njengedatha yombhalo.

Idatha eholelekile esitokisini C7 ayikwazi ukusetshenziswa njengeziphakamiso zemisebenzi ethile yezibalo njenge- SUM no- AVERAGE . Uma ukungena okunjalo kuhlanganiswe nemibono yomsebenzi, kuphathwa njengenye enye idatha yombhalo futhi inganakiwe.

Esinye isibonakaliso ukuthi idatha ekhonjiwe esitokisini C7 ihambelana ngakwesobunxele - ukulungiswa okuzenzakalelayo kwedatha yombhalo. Umphumela ofanayo uzokwenzeka uma umsebenzi we-CONCATENATE usetshenzisiwe esikhundleni somqhubi we-concatenate.

I-Excel's CONCATENATE Function Isibonelo

Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sizohlanganisa idatha etholakala kumaseli ahlukene kumaseli A4 no-B4 wephepha lokusebenzela esitokisini esisodwa kukholomu C.

Njengoba umsebenzi we-concatenate awushiyi ngokuzenzakalelayo isikhala esingenalutho phakathi kwamagama noma enye idatha, isikhala sizofakwa emgqeni Wombhalo 2 webhokisi lebhokisi usebenzisa ibha yesikhala kwikhibhodi.

Ukufaka umsebenzi owenziwe nge-CONCATENATE

Yize kungenzeka ukuthi uthayiphe umsebenzi ophelele ngokwezifiso njengokuthi, = UKUHLANGANISA (A4, "", B4), abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi, ngoba ibhokisi lengxoxo liyakhathalela ukungena amabakaki, amakhamera futhi, kulesi sibonelo, amanothi okucaphuna azungeze isikhala esingenalutho.

Izinyathelo ezingezansi kwekhava zingena emsebenzini usebenzisa ibhokisi lengxoxo ibe yiseli C2.

1. Chofoza kumakhalekhukhwini C2 ukuze wenze iseli esebenzayo ;
2. Chofoza kuthebhu yefomula ;
3. Khetha ImiSebenzi Yombhalo kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza;
4. Chofoza ku- CONCATENATE ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
5. Chofoza kulayini Umbhalo 1 ebhokisini lengxoxo;
6. Chofoza ku-cell A4 ekhasini lokusebenzela ukuze ufake leyo reference yocingo ebhokisini lengxoxo;
7. Chofoza kulayini Umbhalo 2 ebhokisini lengxoxo;
8. Cindezela ibha yesikhala kwikhibhodi ukwengeza isikhala kulayini Umbhalo 2 (I-Excel izofaka amamaki okucaphuna kabili emkhathini);
9. Chofoza kulayini Umbhalo 3 ebhokisini lengxoxo;
10. Chofoza kuseli B4 kusikripthi sokusebenza ukuze ufake leyo reference reference ebhokisini lengxoxo;
11. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela;
12. Igama eliphethwe ngokuthi uMary Jones kufanele livele esitokisini C4;
13. Uma uchofoza ku-cell C4 umsebenzi ophelele = CONCATENATE (A4, "", B4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

Ukubonisa ama-Ampersand ku-Data Concatenated Text

Kunezikhathi lapho uhlamvu lwe-ampersand lisetshenziselwa endaweni yegama futhi - njengamagama ezinkampani njengoba kuboniswe emgqeni wesithupha kusibonelo esingenhla.

Ukuze ubonise i-ampersand njengomlingisi wombhalo kunokuba ibe njengomqhubi we-concatenation, kumele ihlolwe ngamamaki okucaphuna kabili njengamanye abalingiswa bokubhala - njengoba kuboniswe kwifomula kwiseli D6.

Kumele kuqashelwe ukuthi kulesi sibonelo, izikhala zikhona nganoma iyiphi ingxenye ye-ampersand ukuze zihlukanise umlingiswa ovela emazweni angaphesheya. Ukuze uzuze lo mphumela, izinhlamvu zendawo zifakwe ngaphesheya kwe-ampersand ngaphakathi kwamamaki okucaphuna kabili ngale ndlela: "&".

Ngokufanayo, uma ifomethantationation esebenzisa i-ampersand njengendlela opharetha yokuncintisana isetshenziswa, izinhlamvu zesikhala kanye ne-ampersand ezungezwe izingcaphuno ezimbili kufanele nazo zifakwe ukuze zibonakale njengombhalo kumiphumela yefomula.

Isibonelo, ifomu ku-cell D6 ingashintshwa ngefomula

= A6 & "&" & B6

ukuze kufinyelele imiphumela efanayo.