MaSpiti eGoogle CONCATENATE Basa

Itai mazana masero akawanda e data mune imwe sero

Concatenate zvinoreva kubatanidza kana kubatanidza zvinhu zviviri kana kupfuura zvakasiyana zvakasiyana nzvimbo munzvimbo itsva uye mugumisiro uchirapwa sechinhu chimwe chete.

MuGoogle Sheets, concatenation inowanzoreva kubatanidza zviri mukati memasero maviri kana kupfuura mune pepa rekuita mune rimwe rechitatu sega rega uchishandisa:

• The CONCATENATE function; kana
• Mushandi wekambani - the ampersand ( & ).

01 of 03

Nezve CONCATENATE Function Syntax

Mienzaniso iri mukudzidzisa iyi inotaura nezvezvinhu zviri mumufananidzo unoenda munyaya ino.

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemazana, uye nharo

Mutsara weCONCATENATE basa ndewokuti:

= GETERANA (chine1, tambo2, tambo3, ...)

• String1 inodiwa. Ndiyo yekutanga yokupinda kwepa data kuti iongororwe nemabasa. Iyi nharo inogona kunge iri mazwi, imwe sero rinotarisa kune nzvimbo yedhesi iri mubasa rekushandura, ruzivo rwemaferensi ezvitinho, nzvimbo dzisina ruvara, kana nhamba.
• String2, String3, ... Hapana chikamu chinopiwa pamusoro pehuwandu hwemashoko anokwanisa kuwedzerwa kune basa. Nharo imwe neimwe inofanira kuparadzaniswa nekma.

Kuwedzera Nzvimbo Dzakasimbiswa Nhamba

Nzira yekubvumirana isingasviki nzvimbo isina chinhu pakati pemashoko, iyo yakanaka pakubatanidza zvikamu zviviri zvezwi rimwechete seBhola rimwechete kana kuti kubatanidza mbiri mbiri dzakadai sa 123456 .

Paunopinda mazita ekutanga uye ekupedzisira kana kero, zvisinei, chigumisiro chinoda nzvimbo kuitira kuti nzvimbo inofanira kuiswa mumutsetse wekubvumirana. Inowedzerwa nevana vaviri vaitevedza inoteverwa nenzvimbo uye imwe nhengo mbiri yechipiri ("").

Concatenating Number Data

Kunyange zvazvo nhamba dzichigona kugadziriswa, chigumisiro 123456 hachisati chafungidzirwa nhamba purogiramu asi zvino yava kuonekwa semashoko ekunyora.

Izvo zvinogadziriswa muchikamu cheC7 hazvigoni kushandiswa semafungiro emamwe magwaro mabasa akaita seSUM neAVERAGE . Kana iyo inopinda yakabatanidzwa nemafungiro emabasa, inobatwa semamwe mavara uye demo.

Chimwe chinoratidza ichi ndechokuti data yakatorwa muchitokisi C7 yakanamatirana necheboshwe, iyo ndiyo kusagadzikana kusagadzikana kwemashoko emashoko. Mhinduro imwechete inoitika kana CONCATENATE basa yakashandiswa pane nzvimbo yekambani ye concatenate.

02 of 03

Kupinda CONCATENATE Basa

MaSpredishiti eGoogle haashandisi dialog boxes kuti apinde nharo dzebasa sezvazvinogona kuwanikwa muExcel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.

Tevera matanho mumuenzaniso uyu kupinda muCONCATENATE basa kuGoogle Sheets. Usati watanga, tanga pepanheetti itsva uye ugoisa ruzivo mune mitsara minomwe yemakoronike A, B, uye C sezvakaratidzwa pamufananidzo unoenderana nenyaya ino.

1. Dzvanya pachitokisi C4 cheGoogle Sheets spreadsheet kuti iite sero rinoshanda .
2. Tora chikamu chakafanana ( = ) uye utange kuisa zita rebasa racho: concatenate . Sezvaunonyora, bhokisi-self-bhokisi rinowanikwa nemazita uye syntax yemabasa anotanga netsamba C.
3. Apo izwi CONCATENATE rinowanikwa mubhokisi, chinyorwa pairi ne mouse pointer kuti uise zita rebasa uye uzarure bhatikiti rose muchitokisi C4.
4. Dzvanya pane sero A4 mune pepa rekushanda kuti uise ino rekero sechikwata1 nharo.
5. Tora comma kuti uite separarator pakati pemakakatanwa.
6. Kuti uwedzere nzvimbo pakati pemazita ekutanga neokupedzisira, tora kaviri kota yotsanangudzo yakateverwa nenzvimbo inoteverwa nekechipiri kaviri kota yotsanangura ( "" ). Ichi ndicho chikwata2 nharo.
7. Tora wechipiri comma separator.
8. Dzvanyira pane sero B4 kuti uise ino rekero sero sendiri3 nharo.
9. Dhinda pikicha yekupinda kana kudzoka pane keyboard kuti uise mavheti ekuvhara mukati memashoko ekushanda uye kupedza basa.

Mhedzisiro inonzi Maria Jones inofanira kuonekwa muchitokisi C4.

Paunenge uchitsvaga pane cell C4, basa rakakwana
= CONCATENATE (A4, "", B4) inowanikwa mubhairi yepamusoro pane pepa pepaji.

03 of 03

Kuratidza maAmpersand muConcatenated Text Data

Pane dzimwe nguva apo ampersand chimiro (&) chinoshandiswa panzvimbo yezwi uye zvakadai semazita emakambani sezvakaratidzwa mumufananidzo wechifananidzo.

Kuti uratidze ampersand semutauro wemunhu panzvimbo pane kuita kuti ave seanopatenation operator, inofanira kunge yakakomberedzwa nekodhi yepamusoro mavara semamwe mavara.

Zvinofanira kuonekwa kuti mumuenzaniso uyu, nzvimbo dziripo kune rumwe rutivi rwema ampersand kuitira kuti iparadzanise hutano kubva pamashoko kune rumwe rutivi. Kuti uwane chigumisiro ichi, vanhu vemavara vakapinda kune rumwe rutivi rwema ampersand mukati memashoko maviri ezvinyorwa mumutambo uyu: "&".

Saizvozvowo, kana shanduro yakagadzirisa iyo inoshandisa ampersand sezvinoitwa shanduro yekushandisa, nzvimbo dzemavara uye ampersand dzakapoteredzwa nemashoko maviri akafanirwawo anofanira kuiswawo kuitira kuti iite seyinyorwa mumigumisiro yemigumisiro.

Semuenzaniso, shanduro iri muchitokisi D6 inogona kuchinjwa neyo fomu

= A6 & "&" & B6

kuti zvive nemigumisiro yakafanana.