MacGyver adagwiritsa ntchito. Ogwira ntchito ku Apollo 13 adagwiritsanso ntchito. Nthawi zonse muzovuta, pamene mukufunikira kugwirizanitsa zinthu ziwiri, anthu amatenga tepi. Mutha kudabwa, koma Excel ili ndi ntchito yomangidwira yomwe imachita chimodzimodzi. Ichi ndi ntchito CONCATENATE (CUTCH).
ntchito CONCATENATE (CONCATENATE) imakulolani kuti mulumikize zigawo ziwiri kapena zingapo mu selo imodzi. Ngakhale dzina lalitali, ndilosavuta kugwiritsa ntchito ndipo limagwira ntchito mofanana m'matembenuzidwe onse a Excel komanso ma spreadsheets ena monga Google Sheets.
Zindikirani: Ngati simunagwiritsepo ntchito ntchito za Excel m'mbuyomu, mutha kuloza gawolo Mafomu ndi Ntchito Onani Maphunziro athu a Excel Oyamba pamitu yotsatsira pamutuwu.
Kulumikiza mayina
Tiyerekeze kuti tili ndi tebulo lokhala ndi zidziwitso pomwe mayina oyamba ndi omaliza ali m'magawo osiyanasiyana. Tikufuna kuwalumikiza ndikupeza dzina lathunthu la munthu aliyense. Pachithunzi chili m'munsimu mukuwona mayina mumzere B, ndi mayina omaliza m’gawolo A. Fomu yathu idzakhala mu cell E2.
Tisanayambe kuyika ndondomekoyi, mvetsetsani mfundo yofunika: ntchito Mtengo wa STsEPIT amangomanga zomwe mwafotokoza osati china. Ngati mukufuna zizindikiro zopumira, mipata, kapena china chake kuti chiwonekere mu selo, onjezerani ku mikangano yantchito.
Mu chitsanzo ichi, tikufuna danga pakati pa mayina (kupewa zina monga - JosephineCarter), kotero tidzafunika kuwonjezera danga pazokangana. Kotero, tidzakhala ndi zifukwa zitatu:
- B2 (Dzina Loyamba) - dzina
- "" - chikhalidwe cha malo muzolemba
- A2 (Dzina Lomaliza) - surname
Tsopano popeza kuti mikangano yafotokozedwa, tikhoza kulemba ku selo E2 nayi formula:
=CONCATENATE(B2," ",A2)
=СЦЕПИТЬ(B2;" ";A2)
Mofanana ndi ntchito ina iliyonse ya Excel, syntax ndiyofunikira. Kumbukirani kuyamba ndi chizindikiro chofanana (=) ndikuyika malire (koma kapena semicolon) pakati pa mikangano.
Zindikirani: ikani comma kapena semicolon pakati pa mikangano - zimatengera dziko lomwe mukukhala ndi mtundu wanji wa Excel womwe mumagwiritsa ntchito.
Ndizomwezo! Mukasindikiza Lowani, dzina lonse liwonekera: Josephine Carter.
Tsopano, pokoka chogwirizira chodzaza zokha, koperani fomula kumaselo onse mpaka E11. Zotsatira zake, dzina lonse lidzawonekera kwa munthu aliyense.
Ngati mukufuna kusokoneza ntchitoyi, yesani kugwiritsa ntchito ntchitoyi Mtengo wa STsEPIT gwirizanitsani mzinda ndi dziko mugawo Fkuti muwone ngati chithunzi chili pansipa:
Kuphatikiza manambala ndi zolemba
Kugwiritsa ntchito Mtengo wa STsEPIT Mutha kulumikizanso manambala ndi zolemba. Tiyerekeze kuti timagwiritsa ntchito Excel kuti tisunge zolemba za sitolo. Tsopano tatero Maapulo a 25 (maapulo), koma nambala “25” ndi mawu akuti “maapulo” amasungidwa m’maselo osiyanasiyana. Tiyeni tiyese kuwalumikiza mu selo imodzi kuti tipeze chonchi:
Tiyenera kugwirizanitsa zinthu zitatu:
- F17 (Nambala mu stock) - kuchuluka
- "" - chikhalidwe cha malo muzolemba
- F16 (Katundu) - dzina
Lowetsani fomula ili mu selo E19:
=CONCATENATE(F17," ",F16)
=СЦЕПИТЬ(F17;" ";F16)
Tiyeni tiwonjezere! Tiyerekeze kuti tikufuna kupeza: Tili ndi maapulo 25 (Tili ndi maapulo 25). Kuti muchite izi, muyenera kuwonjezera mkangano winanso - mawu akuti "Tili":
=CONCATENATE("We have ",F17," ",F16)
=СЦЕПИТЬ("We have ";F17;" ";F16)
Mutha kuwonjezera mikangano yochulukirapo ngati mukufuna kupanga mawu ovuta kwambiri. Chachikulu kukumbukira ndikuti mawu amtunduwu ayenera kukhala olondola kwambiri, apo ayi sangagwire ntchito. Ndikosavuta kulakwitsa munjira yayikulu!