CONCATENATE basa muExcel. Maitiro ekubatanidza maseru zvirimo muExcel uchishandisa CONCATENATE

Pane basa rakakosha CONCATENATE muspredishiti processor, iyo inoshandisa mubatanidzwa wezviri mukati memasero maviri kana anopfuura. Iko kugona kushandisa iyi opareta inokubvumira kuti ushande uye nekukurumidza kushanda pane yakakura data mune tabular fomu. Ngatitarisei zvakanyanya kushanda kwemugadziri weCONCATENATE.

Tsanangudzo uye syntax yeCONCATENATE basa

Kutanga kubva ku2016, basa iri rakatumidzwa zita muspredishiti uye rakazozivikanwa se "SCEP". Vashandisi vakajaira zita rekutanga vanogona kuramba vachishandisa "CONCATENATE" sezvo chirongwa chinovaziva nenzira imwechete. Maonero ese emushandisi: =SCEP(chinyorwa1;chinyorwa2;…) or = CONCATENATE(chinyorwa1,chinyorwa2,…).

Zvinokosha! 255 ndiyo yakawanda inogoneka nhamba yemabatiro emabasa. Zvizhinji zvakakura hazvigoneki. Kuedza kushandisa dzimwe nharo kunoguma nekukanganisa.

Kupinza uye Kuisa Basa

Vane ruzivo vanoshandisa maspredishiti vanoziva kuti nekubatanidza maseru akati wandei kuita rimwe chete, data yezvikamu zvese inodzimwa, kunze kweiyo yepamusoro kuruboshwe. Iyo CONCATENATE basa rinodzivirira izvi. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza chikamu chatinoda kuita nzira yekubatanidza. Sarudza iyo uye enda ku "Insert Function" chinhu.

2. Hwindo diki rainzi "Insert Function" rairatidzwa pachiratidziri. Wedzera rondedzero padivi pe "Categories:" uye tinya "Text". Zvadaro, sarudza "SCEP" uye tinya bhatani "OK".

3. Hwindo idzva rakaonekwa, rakagadzirirwa kutsanangura nharo dzebasa racho. Pano iwe unogona kuisa zvose zviratidzo zvakananga uye maseru mareferensi. Kero dzinogona kuiswa dzakazvimiririra nekunyora nemaoko kana nekungodzvanya pane maseru papepa rebasa.
4. Isu tinoenda kumutsetse "Text1" uye tinya pane chikamu A2.

5. Tinoenda kumutsara we "Text2", pinda ", " (comma uye nzvimbo) ipapo kuti uparadzanise nharo.

6. Isu tinoenda kumutsara "Text3" uye tinya pane chikamu B2.

7. Nenzira imwecheteyo, tinozadza nharo dzakasara, uye tinya "OK". Munzvimbo yezasi yehwindo iwe unogona kuona yekutanga mhedzisiro.

8. Kuitwa kwekubatanidzwa kwezvikamu zvose zvakasarudzwa kuva imwe kwakabudirira.

9. Iko hakuna chikonzero chekudzokorora manipulations akafanana kune zvikamu zvekoramu yasara pazasi. Iwe unongoda kufambisa mbeva cursor pamusoro pekona yekurudyi yechikamu nemhedzisiro inoratidzwa. Chinongedzo chichatora chimiro chechidiki chekuwedzera chiratidzo. Bata LMB uye dhonza chiratidzo chekuwedzera pasi kusvika kuzasi chaiko kwekoramu.

10. Nekuda kweizvozvo, takawana koramu yakazadzwa ine data nyowani.

Iyi ndiyo yaive yakanyanya mwero nzira yekushandisa iyo CONCATENATE basa. Tevere, isu tichafunga zvakadzama nzira dzakasiyana dzekubatanidza zvikamu uye kupatsanura zviratidzo pakati pavo.

Maitiro ekushandisa iyo CONCATENATE basa muExcel

Ngationgororei zvakadzama sezvinobvira nzira shanu dzekushandisa CONCATENATE basa muspredishiti.

Nzira 1: Sanganisa data mumasero

Data Kubatanidza Nhanho neNhanho Gaidhi:

1. Isu tinoita sarudzo yesero yatinoda kuratidza maitiro akabatanidzwa. Isu tinodzvanya pane "Insert basa" chinhu, chiri padyo nemutsara wekupinda mafomula.

2. The Function Wizard hwindo rinoonekwa pachiratidziro. Sarudza chikamu che "Text", wobva wawana "CONCATENATE" basa. Mushure mekuita zvese manipulations, tinya "OK".

3. Hwindo renharo rinozivikanwa rakaratidzwa pachiratidziri. Isu tinoisa pointer mumutsara wekutanga wehwindo. Zvadaro, pane pepa rekushanda, sarudza chinongedzo chine data inodiwa pakubatanidza. Isu tinoita zviito zvakafanana nemutsara wechipiri, tichiratidzira imwe chikamu. Isu tinoita maneuver iyi kusvika kero dzezvikamu zvese dzapinzwa mubhokisi rekupokana. Mushure mekupedza matanho ese, tinya "OK".

4. Somugumisiro, data yezvikamu zvakasarudzwa zvakaratidzwa mune imwe nzvimbo yakasarudzwa kare. Chinhu chinonyanya kukanganisa nzira iyi ndechokuti data yose inoratidzwa pamwe chete, pasina kupatsanura. Izvo hazvishande kuwedzera vapatsanuri wega, pasina kushandura fomula.

Nzira 2: Kushandisa basa rine nzvimbo

Kukanganisa uku kunogadziriswa zviri nyore nekuwedzera nzvimbo pakati penharo dzebasa. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoshandisa zviito zvinotsanangurwa mune algorithm inoratidzwa pamusoro.
2. Isu tinodzvanya-kaviri LMB pane chikamu neformula yekubvumidza shanduko yayo.

3. Isa nzvimbo pakati pezvinokosha mumakotesheni. Matauriro ega ega akadai anofanira kupera nesemicolon. Mhedzisiro yacho inofanira kuva yekutaura kunotevera: “”;

4. Dzvanya kiyi ye "Enter" pane keyboard.
5. Ready! Mapoka akaonekwa pakati pezvinokosha, uye ruzivo rwakaratidzwa rwakatanga kutaridzika zvakanyanya.

Method 3: Kuwedzera nzvimbo Via Arguments Window

Nzira iri pamusoro apa yakakodzera chete mumamiriro ezvinhu apo pasina data yakawanda. Kana iwe ukashandisa nzira yakadaro yekuparadzanisa nehuwandu hwemashoko, saka unogona kurasikirwa nenguva yakawanda. Iyi inotevera nzira inobvumidza iwe kuisa nzvimbo nekukurumidza sezvinobvira uchishandisa iyo nharo hwindo. Iyo yekufamba inotaridzika seiyi:

1. Isu tinowana chero chikamu chisina chinhu pane pepa rebasa uye tinya kaviri pairi neLMB, isa nzvimbo mukati maro. Zviri nani kuti chikamu chacho chiri mberi kubva kune ndiro huru. Sero rakasarudzwa harifanire kuzadzwa chero ruzivo.

2. Isu tinoshandisa algorithm yezviito kubva kune dzakapfuura nzira kuti tisvike kune iyo basa nharo hwindo. Sezvo mune nzira dzakapfuura, tinopinda kukosha kwechikamu chekutanga ne data mumunda wekutanga. Tevere, nongedzera kumutsara wechipiri uye ratidza kero yechikamu chatichangopinda munzvimbo. Kuti ikurumidze kuita maitiro, unogona kukopa kukosha kwechikamu uchishandisa "Ctrl + C" musanganiswa.

3. Zvadaro, isa kero yechikamu chinotevera. Mundima inotevera, wedzera kero yechikamu chisina chinhu zvakare. Tinodzokorora zviito zvakafanana kusvikira data iri mutafura yapera. Mushure mekuita zvese manipulations, tinya bhatani "OK".

Somugumisiro, takawana rekodhi yakabatanidzwa, iyo data iyo inoparadzaniswa nenzvimbo.

Nzira 4: Kubatanidza makoramu

Iyo CONCATENATE opareta inobvumidza iwe kusanganisa kukosha kwemakoramu akati wandei kuita imwe. Iyo yekufamba inotaridzika seiyi:

1. Nezvikamu zvemutsara wekutanga wemakoramu akasanganiswa, isu tinoshandisa maitiro akafanana anoratidzwa mu2nd uye 3rd mienzaniso. Zvakakodzera kutaura kuti kana iwe uchida kushandisa iyo nzira ine isina chinhu chikamu, saka iwe unofanirwa kuita mhedziso yemhando yereferensi yayo. Kuti uite izvi, tungamira zviratidzo zvese zvekubatanidza ne "$" chiratidzo. Mimwe minda inoramba iine hukama. Mushure mekuita zvese manipulations, tinya pane chinhu "OK".

2. Hover pamusoro pekona yekurudyi yechikamu neformula. Mushure mekunge chinongedzo chatora chimiro chechiratidzo chekuwedzera, nekubata bhatani rekuruboshwe tinotambanudza chiratidzo kusvika pazasi petafura.

3. Mushure mekushandiswa kwechirongwa ichi, ruzivo rwakaratidzwa mumakoramu ruchabatanidzwa muchikamu chimwe chete.

Nzira 5: Kuwedzera Mamwe Mavara

CONCATENATE mushandisi anoshandiswa kuisa mamwe mataurirwo nemabhii anga asiri munzvimbo yekutanga yekubatanidza. Zvakakosha kucherechedza kuti nekuda kwemushandisi uyu, unogona kupinza mamwe mabasa espredishiti processor. Nhanho-ne-nhanho tutori inoita seizvi:

1. Isu tinoshandisa manipulations kuti tiwedzere kukosha kune nharo hwindo kubva kune nzira dzakatsanangurwa pamusoro. Mune ipi neipi yendima tinoisa zvinyorwa zvinyorwa zvinyorwa. Zvinyorwa zvinofanirwa kuve zvakakomberedzwa nemakotesheni mamaki pamativi ese.
2. Mushure mekupedza matanho ese, tinya "OK".

3. Somugumisiro, munharaunda yakasarudzwa, pamwe chete nemashoko akabatanidzwa, ruzivo rwemashoko rwakapinda rwakaonekwa.

Inverse CONCATENATE basa muExcel

Kune akati wandei maopareta anotendera iwe kupatsanura kukosha kwesero rimwe. Mienzaniso yebasa:

1. RUBOSHWE. Inoburitsa chikamu chakatsanangurwa chemavara kubva pakutanga kwemutsara. Maonero akaenzana: =LEVSIMV(A1;7), apo 7 ndiyo nhamba yemavara ekutora kubva mutambo.

2. RUDYI. Inoburitsa chikamu chakatsanangurwa chemavara kubva kumagumo etambo. Maonero akaenzana: =RIGHTSIMV(A1;7), apo 7 ndiyo nhamba yemavara ekutora kubva mutambo.

3. PSTR. Inoratidza chikamu chakatsanangurwa chemavara, kutanga panzvimbo yakatarwa. Maonero akaenzana: =PSTR(A1;2;3), apo 2 ndiyo nzvimbo inotangira kubviswa, uye 3 ndiyo nhamba yemavara achatorwa kubva patambo.

Basa rekugadzirisa

Zvinoitika kuti mushandisi atowedzerwa, asi dzimwe shanduko dzinoda kuitwa kwairi. Izvi zvinogona kuitwa nenzira mbiri. Chekutanga sarudzo:

1. Sarudza sero rine basa rakapera uye tinya pane "Insert Function" chinhu, chiri padivi pemutsara wekupinda mafomula.

2. Hwindo rinozivikanwa rekuisa nharo dzemushandisi rakabuda. Pano unogona kuita shanduko dzose dzinodiwa. Pakupedzisira, tinya "OK".

Sarudzo yechipiri:

1. Dzvanya kaviri pane chikamu neformula uye enda kushandura maitiro.

2. Isu tiri kugadzirisa hunhu muchikamu pachayo.

Pasinei nesarudzo inoshandiswa, paunenge uchigadzirisa nemaoko, unofanirwa kungwarira sezvinobvira kuitira kudzivirira kukanganisa.

Teerera! Sector coordinates inofanira kuiswa pasina makotesheni, uye nharo dzinofanira kunyorwa dzakapatsanurwa nesemicolons.

CONCATENATE basa renhamba huru yemasero

Paunenge uchishanda nenhamba huru yemasero, dhata re data rinotsanangurwa sereferensi. Iyo yekufamba inotaridzika seiyi:

1. Ngatimbofungidzira kuti data redu riri mumutsara mumwe (wechishanu mumutsara).
2. Pinda huwandu hwese kuti ubatanidze mune isina chinhu chikamu uye wedzera nzvimbo kuburikidza neampersand sign.

3. Dzvanya kiyi "F9". Iyo formula inoburitsa mhedzisiro yekuverenga.
4. Nzvimbo yakawedzerwa kumazwi ese, uye “;” yakaumbwa pakati pavo. Isu tinobvisa mabhureki asina kufanira uye tinoisa iyi array mufomula.

5. Mushure mekuita zvese manipulations, tinya "Enter" kiyi

Kubatanidza mavara uye zuva

Uchishandisa iyo CONCATENATE basa, unogona kusanganisa ruzivo rwemavara nezuva. Iyo yekufamba inotaridzika seiyi:

1. Kuti ubatanidze chaihwo, unofanira kutanga waisa zuva muTEXT opareta. Mushandi anokubvumira kuti ufomedze nhamba.
2. DD.MM.YY kukosha. inosarudza kuti zuva richataridzika sei. Semuenzaniso, kana ukatsiva YY neYYYY, gore rinozoratidzwa semanhamba mana pane maviri.

Zvakakosha kucherechedza kuti iwe unogona kuwedzera ruzivo rwemavara kune ruzivo rwenhamba kwete chete uchishandisa CONCATENATE opareta, asi zvakare uchishandisa iyo tsika nhamba fomati.

Basa rekushanda vhidhiyo

Kana iyo mirairo iri pamusoro isina kukwana kuti unzwisise mashandiro anoita CONCATENATE basa, saka tinokurudzira kuti utarise mavhidhiyo anotevera anokuudza nzira yekubatanidza maseru nemazvo pasina kurasikirwa neruzivo:

Mushure mekuona mirairo yevhidhiyo, iwe uchaona zvakajeka kuti basa iri rinoshanda sei uchishandisa mienzaniso, dzidza nezve akasiyana nuances ekushandisa mushandisi uye wowedzera ruzivo rwako pamusoro payo.

mhedziso

Iyo CONCATENATE basa chishandiso chinobatsira chespredishiti chinokutendera kuti ubatanidze zvikamu pasina kurasikirwa nedata. Iko kugona kushandisa mushandisi kuchabatsira vashandisi kuchengetedza zvakanyanya nguva kana vachishanda nehuwandu hwakawanda hweruzivo.