MacGyver yayi amfani da shi. Ma'aikatan jirgin Apollo 13 ma sun yi amfani da shi. Koyaushe a cikin yanayi mai wahala, lokacin da kuke buƙatar haɗa abubuwa biyu, mutane suna ɗaukar tef. Kuna iya mamaki, amma Excel yana da ginanniyar aikin da ke yin haka. Wannan aiki ne CONCATENATE (CLUTCH).
aiki CONCATENATE (CONCATENATE) yana ba ku damar haɗa guda biyu ko fiye na rubutu a cikin tantanin halitta ɗaya. Duk da dogon suna, yana da sauƙin amfani kuma yana aiki iri ɗaya a duk nau'ikan Excel da sauran maƙunsar bayanai kamar Google Sheets.
lura: Idan baku taɓa amfani da ayyukan Excel ba a baya, zaku iya komawa zuwa sashin Formula da Ayyuka Dubi koyarwarmu ta Excel don masu farawa don jerin darasi akan wannan batu.
Sunaye masu alaƙa
A ce muna da tebur mai bayanin tuntuɓar inda sunayen farko da na ƙarshe ke cikin ginshiƙai daban-daban. Muna son haɗa su kuma mu sami cikakken suna ga kowane mutum. A cikin hoton da ke ƙasa kuna ganin sunaye a cikin ginshiƙi B, da sunayen ƙarshe a cikin ginshiƙi A. Tsarin mu zai kasance a cikin tantanin halitta E2.
Kafin mu fara shigar da dabara, fahimci wani muhimmin batu: aikin STsEPIT kawai zai ɗaure abin da kuka ayyana ba wani abu ba. Idan kana son alamomin rubutu, sarari, ko wani abu dabam su bayyana a cikin tantanin halitta, ƙara su zuwa gardamar aiki.
A cikin wannan misalin, muna son sarari tsakanin sunayen (don guje wa wani abu kamar - JosephineCarter), don haka za mu buƙaci ƙara sarari zuwa gardama. Don haka, za mu sami dalilai guda uku:
- B2 (Sunan Farko) - suna
- "" – Halin sarari a cikin alamun zance
- A2 (Sunan Ƙarshe) - sunan mahaifi
Yanzu da aka bayyana muhawarar, za mu iya rubuta zuwa tantanin halitta E2 ga dabara:
=CONCATENATE(B2," ",A2)
=СЦЕПИТЬ(B2;" ";A2)
Kamar yadda yake tare da kowane aikin Excel, syntax yana da mahimmanci. Ka tuna farawa da alamar daidai (=) kuma sanya masu iyaka (waƙafi ko ƙaramin yanki) tsakanin gardama.
lura: sanya waƙafi ko ƙaramin yanki tsakanin gardama - ya dogara da ƙasar da kuke zaune da kuma wace sigar Excel kuke amfani da ita.
Shi ke nan! Lokacin da ka danna Shigar, cikakken suna zai bayyana: Josephine Carter.
Yanzu, ta hanyar jawo hannun autofill, kwafi dabarar zuwa duk sel har zuwa E11. A sakamakon haka, cikakken suna zai bayyana ga kowane mutum.
Idan kuna son rikitarwa aikin, to gwada amfani da aikin STsEPIT haɗa birni da jiha a cikin ginshiƙi Fdon yin kama da hoton da ke ƙasa:
Haɗin lambobi da rubutu
Amfani da ayyuka STsEPIT Kuna iya haɗa lambobi da rubutu. Bari mu yi tunanin cewa muna amfani da Excel don adana bayanan kaya don shago. Yanzu muna da 25 apples (apples), amma lambar "25" da kalmar "apple" ana adana su a cikin sel daban-daban. Bari mu yi ƙoƙarin haɗa su a cikin tantanin halitta ɗaya don samun wani abu kamar haka:
Muna buƙatar haɗa abubuwa guda uku:
- F17 (Lambar a hannun jari) - yawa
- "" – Halin sarari a cikin alamun zance
- F16 (samfurin) - suna
Shigar da dabara mai zuwa a cikin tantanin halitta E19:
=CONCATENATE(F17," ",F16)
=СЦЕПИТЬ(F17;" ";F16)
Bari mu sa shi da wuya! Bari mu ce muna son samun: Muna da apples 25 (Muna da apples 25). Don yin wannan, kuna buƙatar ƙara ƙarin hujja guda ɗaya - kalmar "Muna da":
=CONCATENATE("We have ",F17," ",F16)
=СЦЕПИТЬ("We have ";F17;" ";F16)
Kuna iya ƙara ƙarin gardama idan kuna son ƙirƙirar magana mai rikitarwa. Babban abin da za a tuna shi ne cewa tsarin tsarin tsarin dole ne ya kasance daidai sosai, in ba haka ba yana iya aiki ba. Yana da sauƙin yin kuskure a cikin babban tsari!