AmaSpredishithi e-Google CONCATENATE Umsebenzi

Hlanganisa amaseli amaningi yedatha esitokisini esisha

Ukucubungula kusho ukuhlanganisa noma ukujoyina izinto ezimbili noma ngaphezulu ezitholakala ngokuhlukile endaweni entsha nomphumela ukwelashwa njengenhlangano eyodwa.

Ku-Google AmaSpredishithi, ukukhonjiswa ngokuvamile kubhekisela ekuhlanganiseni okuqukethwe kwamaseli amabili noma ngaphezulu kwiphepha lokusebenzela esitokisini sesithathu ehlukile usebenzisa:

• Umsebenzi OQINISEKILE; noma
• Umqhubi we-concatenation - i-ampersand ( & ).

01 ka-03

Mayelana ne-CONCATENATE Umsebenzi we-Syntax

Izibonelo kulesi sifundo zibhekisela ezithombeni esithombeni esihambisana nalesi sihloko.

I-syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, abahlukanisi be-comma, nezimpikiswano

I-syntax yomsebenzi we-CONCATENATE yile:

= QAPHELA (string1, string2, string3, ...)

• I-String1 iyadingeka. Kuyinto yokuqala yokungena kwedatha okumele ikhonjiswe ngumsebenzi. Le mpikiswano ingaba ngamagama, ireferensi eyodwa yeseli yendawo yedatha kushidi lokusebenza, ububanzi bezinkomba, izingqikithi ezingenalutho, noma izinombolo.
• I-String2, String3, ... Akukho mkhawulo unikezwa ngenani lezingxabano ezingangezwa kulo msebenzi. Ingxabano ngayinye kufanele ihlukaniswe ngomahlaya.

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, umphumela udinga isikhala ngakho isikhala kufanele sifakwe kwifomula ye-concatenation. Yengezwe nge-parenthesis kabili elandelwe isikhala nenye i-parenthesis kabili ("").

Ukuqhathanisa idatha yezinombolo

Ngisho noma izinombolo zinganqunywa, umphumela we- 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 salokhu ukuthi idatha ekhonjiwe esitokisini C7 ihambelana ngakwesobunxele, okuyinto ukulungiswa okuzenzakalelayo kwedatha yombhalo. Umphumela ofanayo uyenzeka uma umsebenzi WOKUSEBENZISWA kusetshenzisiwe esikhundleni se-opharetha we-concatenate.

02 ka-03

Ukufaka umsebenzi owenziwe nge-CONCATENATE

I-Google AmaSpredishithi ayisebenzisi amabhokisi okuxoxa ukuze afake iziphakamiso zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

Landela izinyathelo kulesi sibonelo ukungena umsebenzi we-CONCATENATE kuma-Google AmaSpredishithi. Ngaphambi kokuba uqale, vula ispredishithi esisha bese ufaka ulwazi kumigqa eyisikhombisa yamakholomu A, B, no-C njengoba kuboniswe esithombeni esihambisana nalesi sihloko.

1. Chofoza kuseli C4 yeSpredishithi se-Google AmaSpredishithi ukuze wenze iseli esebenzayo .
2. Thayipha uphawu olulinganayo ( = ) bese uqala ukuthayipha igama lomsebenzi: cindezela . Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngencwadi C.
3. Uma igama elithi CONCATENATE livela ebhokisini, chofoza kuso nge-pointer yegundane ukufaka igama lomsebenzi bese uvula ibakaki nxazonke esitokisini C4.
4. Chofoza ku-cell A4 kushidi lokusebenzela ukuze ufake le nkomba yeselula njengengxabano yocingo1 .
5. Thayipha i- comma ukuze uhlukanise phakathi kwezimpikiswano.
6. Ukwengeza isikhala phakathi kwamagama okuqala nowagcina, thayipha uphawu lokucaphuna kabili olulandelwe isikhala olulandelwe uphawu lwesibili lokucaphuna kabili ( "" ). Lona ingxabano yochungechunge2 .
7. Thayipha i-separator comma yesibili.
8. Chofoza kuseli B4 ukungena kulolu chungechunge lwamaseli njengengxabano yocingo3 .
9. Cindezela ukhiye wokungena noma wokubuya kwikhibhodi ukuze ufake ama-parenthesis wokuvala ezungeze izingqinamba zomsebenzi futhi uqedele umsebenzi.

Umbhalo olinganiselwe uMary Jones kufanele avele esitokisini C4.

Uma uchofoza ku-cell C4, umsebenzi ophelele
= CONCATENATE (A4, "", B4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

03 ka 03

Ukubonisa ama-Ampersand ku-Data Concatenated Text

Kunezikhathi lapho inhlamvu ye-ampersand (&) isetshenziselwa endaweni yegama futhi njengamagama ezinkampani njengoba kuboniswe esithombeni somfanekiso.

Ukuze ubonise i-ampersand njengomlingisi wombhalo kunokuba ibe njengomqhubi we-concatenation, kufanele ihlolwe ngamamaki okucaphuna kabili njengamanye abalingiswa bombhalo.

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.