AmaSpredishithi e-Google XHUMA Umsebenzi

Hlanganisa iiseli ezininzi zeedatha kwiseli entsha

I-Concatenate ithetha ukudibanisa okanye ukudibanisa izinto ezimbini okanye ngaphezulu ezahlukileyo kwindawo kwindawo entsha kunye nesiphumo sokuphathwa njengeziko elinye.

KwiiSpredishithi zeGoogle, ukuxubusha ngokuqhelekileyo kubhekisela ekudibaniseni iziqulatho ezimbini okanye ngaphezulu kwiseferensi kwiphepha lesithathu elihlukile usebenzisa:

• Umsebenzi OQHENZISAYO; okanye
• Umqhubi we-concatenation - i-ampersand ( & ).

01 ka 03

Ngokumalunga ne-CONCATENATE Function Syntax

Imizekelo kule tutorial ibhekisela kwizinto ezisemfanekisweni ohamba kunye nale nqaku.

I-syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, amabakaki, abahluli be-comma, kunye neengxabano

I-syntax yOMSEBENZI WOKUQINISWA ngu:

= UKUQHATHISWA (umtya1, umtya2, intambo3, ...)

• I-String1 iyadingeka. Yona yokuqala yokungena kwedatha ukuba iqinisekiswe ngumsebenzi. Le ngxabano ingaba ngamagama, isalathisi esisodwa kwendawo yendawo kwiphepha lokusebenzela, uluhlu lweentetho zeefestile, izithuba ezingenanto okanye iinombolo.
• I-String2, String3, ... Akukho mkhawulo unikezelwa kwinani leengxabano ezingenakongezwa kumsebenzi. Impikiswano nganye kufuneka ihlukaniswe yi-comma.

Ukongeza iZithuba zoMxholo oCwangcisiweyo

Ayikho indlela yokubambisana ngokuzenzekelayo ishiya indawo engenanto phakathi kwamagama, okulungileyo xa ujoyina iindawo ezimbini zegama elifana nebhola njengeBhola ibe enye okanye udibanisa uluhlu lwamanani anjengo- 123456 .

Xa ujoyina amagama okuqala kunye neyokugqibela okanye idilesi, nangona kunjalo, isiphumo sidinga isikhala kangangokuba isikhala kufuneka sifakwe kwifom ye-concatenation. Yongezwa nge-parenthesis ephindwe kabini ilandelwe yithuba kunye nelinye i-parenthesis ezimbini ("").

Ikhonkco yeNombolo yeDatha

Nangona amanani angaboniswa, umphumo we- 123456 awusayi kuqwalaselwa kwinani ngenkqubo kodwa ngoku ibonakala njengedatha yombhalo.

Idatha ekhokelela kwiseli C7 ayinakusetyenziswa njengeengxoxo malunga nemisebenzi ethile yemathematika njenge- SUM ne- ALLVERAGE . Ukuba loo ngeniso ifakiwe kunye neengxoxo zomsebenzi, iphathwa njengenye yedatha yombhalo kwaye inganakwa.

Esinye isibonakaliso salokhu kukuba idatha edityanisiweyo kwiselfowuni C7 ihambelaniswe ngakwesobunxele, oko kukulungelelaniswa okungafaniyo kwedatha yombhalo. Isiphumo esifanayo senzeke ukuba umsebenzi OQHENZISWAYO wasetyenziselwa indawo esikhundleni somqhubi we-concatenate.

02 ka 03

Ukufaka umsebenzi OQHENZISAYO

AmaSpredishithi eGoogle ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

Landela amanyathelo kulo mzekelo ukufaka umsebenzi OCWANGILEYO kwiiSpredishithi zeGoogle. Ngaphambi kokuba uqale, vula ispredishithi esitsha uze ufaka ulwazi kwimida emisixhenxe yamakholomu A, B, no-C njengoko kuboniswe kumfanekiso ohamba nale nqaku.

1. Cofa kwifowuni C4 yeSpredishithi zeSpredishithi zeGoogle ukuze wenze iseli esebenzayo .
2. Thayipha uphawu olulinganayo ( = ) kwaye uqale ukuthayipha igama lomsebenzi: cwangcisa . Njengoko uthayipha, ibhokisi ye-auto-suggestion ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta C.
3. Xa igama CONCATENATE livela ebhokisini, nqakraza kuyo kunye ne-pointer ye mouse ukuze ufake igama lomsebenzi kwaye uvule ibhondi ejikelezayo kwi-cell C4.
4. Cofa kwifowuni A4 kwiphepha lokusebenzela ukuze ufake le fom yefowuni njengomtya we- string1 .
5. Thayipha i- comma ukuba uhlule phakathi kweengxabano.
6. Ukongeza isithuba phakathi kwamagama okuqala kunye nookugqibela, thayipha uphawu lokucaphuna kabini olulandelwa yithuba elilandelwa yicatshulwa lesibini le quotation ( "" ). Lo ngumtya weqhosha2 .
7. Thayipha isahlulo sesibini se- comma .
8. Cofa kwifowuni B4 ukungena kule ferensi yeselfowuni njengomtya wecingo3 .
9. Cinezela ukungena okanye ukubuyela kwikhibhodi ukufaka abazali bokuvala malunga neengxoxo zomsebenzi kwaye uzalise umsebenzi.

Umbhalo ochanekileyo uMary Jones kufuneka avele kwiseli C4.

Xa ucofa kwiseli C4, umsebenzi opheleleyo
= UKUQHATHISWA (A4, "", B4) ibonakala kwifom yefomula ngaphezulu kwiphepha lokusebenzela.

03 ka 03

Ukubonisa ii-Ampersand kwi-Data Conquered Data Data

Kukho amaxesha apho uhlamvu lwe-ampersand (&) lusetyenziswa endaweni yegama kwaye njengamagama enkampani njengoko kuboniswe kumzekeliso womfanekiso.

Ukubonisa i-ampersand njengomlingisi wombhalo kunokuba ube ngumsebenzi we-concatenation, kufuneka ujikelezwe ngamanqaku okucaphuna kabini njengabanye abalinganiswa bombhalo.

Kufuneka kuqatshelwe ukuba kulo mzekelo, izikhala zikhona ngaphesheya kwe-ampersand ukwenzela ukwahlula lo mlingiswa ukusuka kumazwi ngaphesheya. Ukufezekisa le miphumo, abalinganiswa bendawo bayangena ngaphesheya kwe-ampersand ngaphakathi kwamanqaku okucaphulwa kabini kule ndlela: "&".

Ngokufanayo, ukuba ifomantenation formula esebenzisa i-ampersand njengomqhubi we-concatenation isetyenzisiweyo, abalinganiswa beendawo kunye ne-ampersand ezijikelezwe ngamagama acatshulwa ngokuphindaphindiweyo kufuneka kwakhona zifakwe ukwenzela ukuba zibonwe njengetekisi kwimiphumo yefomula.

Ngokomzekelo, ifomu kwifom ye-D6 ingatshintshwa yindlela

= A6 & "&" & B6

ukuphumeza iziphumo ezifanayo.