01 ye 01
Gadzirai Cells of Text Data mu Excel
Concatenation Overview
Concatenate zvinoreva kubatanidza kana kubatanidza pamwe zvinhu zviviri kana kupfuura zvakaparadzana zvakawanikwa panzvimbo itsva uye mugumisiro uchirapwa sechinhu chimwe chete.
MuEccel, kubvumirana kunowanzoreva kubatanidza zviri mukati maviri kana kupfuura mamwe masero mumushandisi wekushanda mune chechitatu, sega rega rakasiyana achishandisa:
- iyo CONCATENATE function - mitsetse imwe, ina, uye matanhatu mumufananidzo kumusoro;
- vachishandisa shanduro yekubatisa - the ampersand ( & ) - mitsetse mbiri neyishanu kumusoro.
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 .
Kana uchinge uine mazita ekutanga uye ekupedzisira kana kero, zvisinei, inoda nzvimbo kuitira kuti nzvimbo inofanira kuiswa mumutambo we concatenation - marita mana, mashanu, uye matanhatu pamusoro apa.
ICHIKONZERA Sangano reShoko neArguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo.
Mutsara weCONCATENATE basa ndewokuti:
= GETEREKA (Magwaro1, Rugwaro2, ... Rugwaro255)
Nyaya1 - (inodikanwa) inogona kunge yakanyatsotorwa semashoko kana nhamba, nzvimbo dzisina kuvharwa dzakapoteredzwa nemashoko ekudzokorora, kana kuti zvinyorwa zvinoreva nzvimbo ye data mune pepa rekushanda
Text2, Text3, ... Text255 - (kusarudzo) kusvika ku 255 maintries angangowanikwa kuCONCATENATE basa kune vanhu vanosvika 8 192 - kusanganisira nzvimbo. Chimwe nechimwe chinopinda chinofanira kuparadzaniswa nekoma.
Concatenating Number Data
Kunyange zvazvo nhamba dzichigona kuongororwa - sezvinoratidzwa mumutsara matanhatu pamusoro - mhinduro 123456 haisati yambofungidzirwa 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 ndechokuti data yakagadziriswa muchitokisi C7 yakabatana necheboshwe - kusungirirwa kusagadzikana kwemashoko emashoko. Chiitiko ichocho chaizoitika kana CONCATENATE basa raishandiswa panzvimbo yekambani ye concatenate.
Excel's CONCATENATE Function Example
Sezvakaratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unobatanidza deta inowanikwa mumasero akapararira mumasero A4 neB4 epafashiti mune imwe sero mu column C.
Sezvo basa re concatenate harisi kubuda panzvimbo isina chinhu pakati pemamwe mashoko kana mamwe mashoko, nzvimbo ichawedzerwa kumutsara Rugwaro 2 rwebhokisi rebhokisi uchishandisa bhora yepakati pabhokisi.
Kupinda CONCATENATE Basa
Kunyange zvazvo zvichibvira kungonyora basa rakakwana mumunhu akadai se, = CONCATENATE (A4, "", B4), vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa, sezvo bhokisi rebhokisi rinotarisira kupinda mabheketi, makasita uye, mumuenzaniso uyu, zvinyorwa zvinyorwa zvakapoteredza nzvimbo isina chinhu.
Matanho ari pasi apa anopinda mubasa achishandisa bhokisi reku dialogo muchikamu C2.
- Dzvanya pachitokisi C2 kuti uite sero rinoshanda ;
- Dzvanya paMafomu eTom;
- Sarudza Rugwaro Runoshanda kubva kubhoni kuti uzarure basa rinoyerera pasi;
- Dzvanya pa CONCATENATE muzora kuti ubudise bhokisi rebasa rebasa;
- Dzvanya pamutsara Rugwaro 1 mubhokisi rebhokisi;
- Dzvanya pane sero A4 mune pepa rekushandisa kuti uise iyo seferensi rekuisa mubhokisi rebhokisi;
- Dzvanya pamutsara Rugwaro 2 mubhokisi rebhokisi;
- Dhinda bhora yepakati pakibhodi kuti uwedzere nzvimbo yekuendesa Mutsara 2 (Excel ichawedzera mabhii maviri emashoko ekupoteredza nzvimbo);
- Dzvanya pamurongo Wenyaya 3 mubhokisi rebhokisi;
- Dzvanya pane sero B4 mune pepa rekushandisa kuti uise iyo seferensi iri mubhokisi rebhokisi;
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda;
- Zita rakashandurwa Maria Jones rinofanira kuonekwa muchitokisi C4;
- Paunenge uchinyora pachitsime C4 yakakwana basa = CONCATENATE (A4, "", B4) inowanikwa mubhairi yepamusoro pane pepaji.
Kuratidza maAmpersand muConcatenated Text Data
Kune dzimwe nguva apo ampersand unhu hunoshandiswa panzvimbo yezwi uye -seyakadai mazita emakambani sezvakaratidzwa mumutsara wekutanga wemuenzaniso uri pamusoro.
Kuti uratidze ampersand semutauro wemunhu panzvimbo pane kuita kuti ave seanotarisira, inofanira kunge yakakomberedzwa nekodhi yepamusoro mavara semamwe mavara-mavara - sezvinoratidzwa mumutsetse muchitokisi D6.
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.