CONCATENATE ntchito mu Excel. Momwe mungalumikizire zomwe zili mu Excel pogwiritsa ntchito CONCATENATE

Pali ntchito yapadera ya CONCATENATE mu purosesa ya spreadsheet, yomwe imagwiritsa ntchito mgwirizano wa zomwe zili m'maselo awiri kapena kuposerapo. Kutha kugwiritsa ntchito opareshoniyi kumakupatsani mwayi wogwira ntchito moyenera komanso mwachangu pazambiri zambiri mu mawonekedwe a tabular. Tiyeni tiwone mwatsatanetsatane magwiridwe antchito a CONCATENATE.

Kufotokozera ndi mawu a ntchito ya CONCATENATE

Kuyambira 2016, ntchitoyi idasinthidwanso mu spreadsheet ndipo idadziwika kuti "SCEP". Ogwiritsa omwe azolowera dzina loyambirira atha kupitiliza kugwiritsa ntchito "CONCATENATE" popeza pulogalamuyo imawazindikira chimodzimodzi. Maonedwe onse a wogwiritsa ntchito: =SCEP(text1;text2;…) or =CONCATENATE(text1,text2,…).

Zofunika! 255 ndiye kuchuluka kotheka kwa mikangano yantchito. Zochuluka kwambiri sizingatheke. Kuyesa kukhazikitsa zotsutsana zambiri kumabweretsa cholakwika.

Kuyika ndi Kukhazikitsa Ntchito

Odziwa kugwiritsa ntchito spreadsheet amadziwa kuti pophatikiza maselo angapo kukhala amodzi, deta ya zigawo zonse imafufutidwa, kupatula pamwamba kumanzere kwambiri. Ntchito ya CONCATENATE imalepheretsa izi. Njirayi ikuwoneka motere:

1. Timasankha gawo lomwe tikufuna kuchita ntchito yophatikiza. Sankhani ndikupita ku "Insert Function" chinthu.

2. Zenera laling'ono lotchedwa "Insert Function" linawonetsedwa pazenera. Wonjezerani mndandanda pafupi ndi "Categories:" ndikudina "Text". Kenako, sankhani "SCEP" ndikudina batani "Chabwino".

3. Zenera latsopano linawonekera, lopangidwa kuti lifotokoze zifukwa za ntchitoyi. Pano mukhoza kulowa zizindikiro zonse ndi maumboni ma cell. Maadiresi atha kulembedwa pawokha polemba pamanja kapena kungodinanso ma cell omwe ali patsamba logwirira ntchito.
4. Timasunthira ku mzere "Text1" ndikudina gawo A2.

5. Timasunthira ku mzere "Text2", lowetsani ", " (koma ndi malo) kuti mulekanitse zotsutsana.

6. Timasunthira ku mzere "Text3" ndikudina gawo B2.

7. Momwemonso, timadzaza mikangano yotsalayo, ndikudina "Chabwino". Pansi pa zenera mutha kuwona zotsatira zoyambira.

8. Kukhazikitsa kwa kuphatikiza magawo onse osankhidwa kukhala amodzi kunapambana.

9. Palibe chifukwa chobwereza kusintha kofananako kwa magawo omwe atsala m'munsimu. Mukungoyenera kusuntha cholozera cha mbewa pakona yakumanja kwa gawolo ndi zotsatira zowonetsedwa. Cholozeracho chidzakhala ngati chizindikiro chaching'ono chophatikiza. Gwirani LMB ndi kukokera chizindikiro chowonjezera mpaka pansi pa mzere.

10. Zotsatira zake, tapeza gawo lodzaza ndi data yatsopano.

Iyi inali njira yabwino kwambiri yogwiritsira ntchito CONCATENATE. Kenako, tikambirana mwatsatanetsatane njira zosiyanasiyana zolumikizira magawo ndikugawa zizindikiro pakati pawo.

Momwe mungagwiritsire ntchito ntchito ya CONCATENATE mu Excel

Tiyeni tiunike mwatsatanetsatane njira zisanu zogwiritsira ntchito CONCATENATE mu spreadsheet.

Njira 1: Phatikizani deta m'maselo

Kuphatikizika kwa Data Ndondomeko ya Gawo ndi Gawo:

1. Timasankha ma cell omwe tikufuna kuwonetsa zikhalidwe zophatikizidwa. Timadina chinthu cha "Insert function", chomwe chili pafupi ndi mzere wolowera mafomu.

2. Zenera la Function Wizard likuwonekera pazenera. Sankhani gulu la "Text", ndiyeno pezani ntchito ya "CONCATENATE". Mukamaliza zosintha zonse, dinani "Chabwino".

3. Zenera lodziwika bwino la mkangano likuwonetsedwa pazenera. Timayika cholozera pamzere woyamba wazenera. Kenako, pa tsamba logwirira ntchito, sankhani ulalo womwe uli ndi deta yofunikira pakuphatikiza. Timachitanso chimodzimodzi ndi mzere wachiwiri, ndikuwunikira gawo lina. Timachita izi mpaka maadiresi a magawo onse alowetsedwa mubokosi lazotsutsa. Mukamaliza masitepe onse, dinani "Chabwino".

4. Zotsatira zake, deta yamagulu osankhidwa adawonetsedwa mu gawo limodzi losankhidwiratu. Choyipa chachikulu cha njirayi ndikuti deta yonse imawonetsedwa palimodzi, popanda olekanitsa. Sizigwira ntchito kuwonjezera olekanitsa nokha, popanda kusintha ndondomeko.

Njira 2: Kugwiritsa ntchito ndi danga

Kuperewera kumeneku kumakonzedwa mosavuta powonjezera mipata pakati pa mikangano yantchito. Njirayi ikuwoneka motere:

1. Timagwiritsa ntchito zomwe zafotokozedwa mu algorithm yomwe yaperekedwa pamwambapa.
2. Timadina kawiri LMB pagawo ndi formula kuti tilole kusintha kwake.

3. Ikani mipata pakati pa zikhalidwe mu ma quote marks. Mawu oterowo atha ndi semicolon. Zotsatira zake ziyenera kukhala mawu awa: "";

4. Dinani batani la "Enter" pa kiyibodi.
5. Okonzeka! Mipata idawonekera pakati pazikhalidwe, ndipo zomwe zidawonetsedwa zidayamba kuwoneka bwino kwambiri.

Njira 3: Kuwonjezera Malo Kudzera pazenera la Zotsutsana

Njira yomwe ili pamwambayi ndi yoyenera pokhapokha ngati palibe deta yambiri. Ngati mumagwiritsa ntchito njira yolekanitsa yotereyi ndi chidziwitso chochuluka, ndiye kuti mukhoza kutaya nthawi yambiri. Njira yotsatirayi imakupatsani mwayi woti muyike mipata mwachangu momwe mungathere pogwiritsa ntchito zenera la mikangano. Njirayi ikuwoneka motere:

1. Timapeza gawo lililonse lopanda kanthu patsamba lantchito ndikudina kawiri ndi LMB, lowetsani danga mkati mwake. Ndibwino kuti gawoli lili kutali ndi mbale yayikulu. Selo yosankhidwa isadzazidwe ndi chidziwitso chilichonse.

2. Timagwiritsa ntchito algorithm ya zochita kuchokera ku njira zam'mbuyomu kuti tifike pazenera lazotsutsa. Monga momwe zinalili kale, timalowetsa mtengo wa gawo loyamba ndi deta m'munda woyamba. Kenaka, tchulani mzere wachiwiri ndikuwonetsa adiresi ya gawo lomwe tangolowamo kumene. Kuti mufulumizitse njirayi, mutha kukopera mtengo wagawo pogwiritsa ntchito kuphatikiza "Ctrl + C".

3. Kenako, lowetsani adilesi ya gawo lotsatira. M'munda wotsatira, onjezerani adiresi ya gawo lopanda kanthu kachiwiri. Timabwereza zomwezo mpaka deta yomwe ili patebulo itatha. Pambuyo pochita zosintha zonse, dinani batani "Chabwino".

Chotsatira chake, tinapeza mbiri yophatikizana, deta yomwe imasiyanitsidwa ndi danga.

Njira 4: Kuphatikiza mizati

Wothandizira wa CONCATENATE amakulolani kuti muphatikize zikhalidwe zamagawo angapo kukhala amodzi. Njirayi ikuwoneka motere:

1. Ndi magawo a mzere woyamba wa mizati yophatikizika, timagwiritsira ntchito njira zomwezo zomwe zikuwonetsedwa mu zitsanzo za 2 ndi 3. Ndikoyenera kutchula kuti ngati mukufuna kugwiritsa ntchito njirayi ndi gawo lopanda kanthu, ndiye kuti muyenera kupanga mtundu wamtundu uliwonse. Kuti muchite izi, yambitsani zizindikiro zonse zogwirizanitsa ndi chizindikiro cha "$". Minda ina imakhalabe yogwirizana. Pambuyo pochita zosintha zonse, dinani chinthucho "Chabwino".

2. Yendani pamwamba pakona yakumanja kwa gawo ndi fomula. Pambuyo pa pointer itenga mawonekedwe a chizindikiro chowonjezera, pogwira batani lakumanzere la mbewa timatambasula cholembera pansi pa tebulo.

3. Pambuyo pa kukhazikitsidwa kwa ndondomekoyi, zomwe zasonyezedwa m'mizatizo zidzaphatikizidwa kukhala gawo limodzi.

Njira 5: Kuwonjezera Makhalidwe Ochuluka

Wogwiritsa ntchito CONCATENATE amagwiritsidwa ntchito kuyika mawu owonjezera ndi zilembo zomwe sizinali m'gawo loyambira lolumikizana. Ndizofunikira kudziwa kuti chifukwa cha woyendetsa uyu, mutha kuyika ntchito zina za purosesa ya spreadsheet. Maphunziro a tsatane-tsatane akuwoneka motere:

1. Timagwiritsa ntchito njira zosinthira kuti tiwonjezere zofunikira pazenera lazotsutsana ndi njira zomwe tafotokozazi. M'magawo aliwonse timayika zambiri zamawu osagwirizana. Zolemba ziyenera kuzunguliridwa ndi ma quotation marks mbali zonse ziwiri.
2. Mukamaliza masitepe onse, dinani "Chabwino".

3. Chotsatira chake, mu gawo losankhidwa, pamodzi ndi deta yophatikizidwa, chidziwitso cha malemba cholowa chinawonekera.

Inverse CONCATENATE ntchito mu Excel

Pali ma opareshoni angapo omwe amakulolani kuti mugawane mfundo za cell imodzi. Zitsanzo za ntchito:

1. KUmanzere. Zimatulutsa gawo lotchulidwa la zilembo kuyambira pachiyambi cha mzere. Mawonedwe pafupifupi: =LEVSIMV(A1;7), pamene 7 ndi chiwerengero cha zilembo zomwe zimachokera ku chingwe.

2. KUDALIRA. Zimatulutsa gawo lotchulidwa la zilembo kuchokera kumapeto kwa chingwe. Mawonedwe pafupifupi: =RIGHTSIMV(A1;7), pamene 7 ndi chiwerengero cha zilembo zomwe zimachokera ku chingwe.

3. Zithunzi za PSTR. Imawonetsa gawo lomwe latchulidwa la zilembo, kuyambira pamalo omwe atchulidwa. Mawonedwe pafupifupi: =PSTR(A1;2;3), kumene 2 ndi malo omwe kuchotsako kumayambira, ndipo 3 ndi chiwerengero cha zilembo zomwe ziyenera kuchotsedwa mu chingwe.

Kusintha ntchito

Zimachitika kuti wogwiritsa ntchitoyo wawonjezedwa kale, koma zosintha zina ziyenera kupangidwa kwa izo. Izi zikhoza kuchitika m’njira ziwiri. Njira yoyamba:

1. Sankhani selo lomwe lili ndi ntchito yomalizidwa ndikudina chinthu cha "Insert Function", chomwe chili pafupi ndi mzere wolowetsa mafomu.

2. Zenera lodziwika bwino lolowetsa mikangano ya opareshoni idawonekera. Apa mutha kusintha zonse zofunika. Pomaliza, dinani "Chabwino".

Njira yachiwiri:

1. Dinani kawiri pa gawo ndi chilinganizo ndikupita kusintha mode.

2. Tikusintha makonda mu gawo lomwelo.

Mosasamala kanthu za njira yomwe imagwiritsidwa ntchito, pokonza pamanja, muyenera kusamala momwe mungathere kuti mupewe zolakwika.

Tcherani khutu! Magawo a magawo ayenera kulowetsedwa popanda mawu, ndipo mikangano iyenera kulembedwa mosiyanitsidwa ndi semicolons.

CONCATENATE ntchito yama cell ambiri

Pamene mukugwira ntchito ndi maselo ambiri, mndandanda wa deta umatchulidwa ngati chidziwitso. Njirayi ikuwoneka motere:

1. Tiyerekeze kuti deta yathu ili pamzere umodzi (wachisanu pamzere).
2. Lowetsani mndandanda wonse kuti muphatikizidwe mugawo lopanda kanthu ndikuwonjezera danga kudzera pa chizindikiro cha ampersand.

3. Dinani batani "F9". Fomula imatulutsa zotsatira za kuwerengetsa.
4. Danga linawonjezedwa ku mawu onse, ndi ";" zidapangidwa pakati pawo. Timachotsa mabatani osafunikira ndikuyika mndandandawu mu fomula.

5. Pambuyo pochita zosintha zonse, dinani batani la "Enter".

Kulumikiza mawu ndi tsiku

Pogwiritsa ntchito ntchito ya CONCATENATE, mutha kuphatikiza zolemba ndi tsiku. Njirayi ikuwoneka motere:

1. Kuti muphatikize bwino, muyenera choyamba kuyika deti mu TEXT operekera. Wothandizira amakulolani kupanga nambala.
2. Mtengo wa DD.MM.YY. imatsimikizira momwe detilo lidzawonekere. Mwachitsanzo, ngati mutasintha YY ndi YYYY, chaka chidzawonetsedwa ngati manambala anayi m'malo mwa awiri.

Ndizofunikira kudziwa kuti mutha kuwonjezera zidziwitso pamanambala osangogwiritsa ntchito CONCATENATE, komanso kugwiritsa ntchito mtundu wa manambala.

Video ntchito ntchito

Ngati malangizo omwe ali pamwambawa sakukwanira kuti mumvetsetse momwe ntchito ya CONCATENATE imagwirira ntchito, ndiye kuti tikukulimbikitsani kuti muwone makanema otsatirawa omwe amakuuzani momwe mungaphatikizire maselo molondola popanda kutaya zambiri:

Pambuyo powonera malangizo a kanema, muwona bwino momwe ntchitoyi imagwirira ntchito pogwiritsa ntchito zitsanzo, phunzirani zamitundu yosiyanasiyana ya ogwiritsa ntchito ndikuwonjezera zomwe mukudziwa.

Kutsiliza

Ntchito ya CONCATENATE ndi chida chothandiza cha spreadsheet chomwe chimakulolani kuphatikiza magawo popanda kutaya deta. Kutha kugwiritsa ntchito wogwiritsa ntchitoyo kudzathandiza ogwiritsa ntchito kusunga nthawi kwambiri akamagwira ntchito ndi zidziwitso zambiri.