01 na 01
Haɗa Cells na Bayanan Rubutu a Excel
Concatenation Overview
Concatenate yana nufin haɗawa ko haɗa tare da abubuwa guda biyu ko fiye daban a sabon wuri tare da sakamakon da ake bi da shi azaman ɗayan mahaluži.
A cikin Excel, ƙaddara yawanci yana nufin hada haɗin ɓangaren biyu ko fiye a cikin takardun aiki a cikin ɓangare na uku, raba ta hanyar amfani da ko dai:
- Ayyukan CONCATENATE - layuka daya, hudu, da shida a cikin hoto a sama;
- ta yin amfani da afaretan mai aiki - da ampersand ( & ) - layuka biyu da biyar a sama.
Adding Spaces zuwa Concatenated Text
Babu hanyar yin amfani da takaddama ta atomatik yana barin sarari tsakanin kalmomi, wanda ke da kyau lokacin da ka shiga sassa biyu na kalmar magana kamar Baseball zuwa ɗaya ko hada jerin lambobi biyu kamar 123456 .
Lokacin da shiga farko da sunaye na karshe ko adireshin, duk da haka, yana buƙatar sararin samaniya don haka sarari dole ne a haɗa shi a cikin tsari na ƙaddamarwa - ya kafa hudu, biyar, da shida a sama.
Halin Sakamakon Sakamakon Kasuwanci da Magana
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara.
Hadawa don aikin CONCATENATE shine:
= SANTAWA (Text1, Text2, ... Text255)
Text1 - (da ake buƙata) na iya zama ainihin rubutu kamar kalmomi ko lambobi, wurare marar launi kewaye da alamomi, ko ƙididdigar sel zuwa wurin samo bayanai a cikin takardun aiki
Text2, Text3, ... Text255 - (zaɓi) har zuwa 255 shigarwar rubutu za a iya karawa zuwa aikin CONCATENATE zuwa iyakar nauyin haruffa 8,192 - ciki har da sarari. Kowace shigarwa dole ne a rabu da wata wakafi.
Ƙididdiga Bayanan Data
Kodayake lambobi za a iya yin amfani da su - kamar yadda aka gani a jere na sama a sama - sakamakon haka 123456 ba a sake la'akari da lambar ta hanyar shirin amma yanzu ana ganin shi azaman rubutu.
Ba'a iya amfani da bayanan da aka samu a cikin ƙwayoyin C7 ba a matsayin gardama don wasu ayyuka na lissafi kamar SUM da AVERAGE . Idan an shigar da irin wannan shigarwa tare da muhawarar aiki, ana bi da shi kamar sauran bayanan rubutu kuma an kula.
Ɗaya daga cikin nuni shine cewa bayanan ƙaddamarwa a cikin ƙwayoyin C7 yana hagu zuwa hagu - daidaitattun tsoho don bayanan rubutu. Sakamakon haka zai faru idan aka yi amfani da aikin CONCATENATE maimakon mai aiki na concatenate.
Aiki na Jirgin Ƙari na Excel
Kamar yadda aka gani a cikin hoton da ke sama, wannan misali zai haɗa bayanan da aka samo a cikin sel guda daya a cikin kwayoyin A4 da B4 na takardar aiki a cikin sel guda a shafi na C.
Tun da aikin na concatenate ba zai bar sarari tsakanin kalmomi ko wasu bayanai ba, za a kara sararin samaniya zuwa layin rubutu na 2 na akwatin maganganu ta amfani da filin sarari a kan keyboard.
Shigar da aikin GABATARWA
Ko da yake yana da yiwuwa a rubuta aikin da aka yi tare da hannu kamar, = SANTAWA (A4, "", B4), mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki, tun da akwatin kwance yana kula da shigarwa shafuka, ƙwaƙwalwa kuma, a cikin wannan misali, alamomi da ke kewaye da sararin sarari.
Matakan da ke ƙasa da rufe shigar da aikin ta amfani da maganganun maganganu a cikin cell C2.
- Danna kan tantanin halitta C2 don sa shi tantanin halitta ;
- Danna maɓallin Formulas ;
- Zaɓi Ayyukan Rubutun daga rubutun don buɗe jerin abubuwan da aka sauke aikin;
- Danna Kunnawa a cikin jerin don kawo akwatin maganganu na aikin;
- Danna kan layi Text 1 a cikin akwatin maganganu;
- Danna kan A4 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu;
- Danna kan layin Rubutun 2 a cikin akwatin maganganu;
- Latsa maɓallin sarari a kan keyboard don ƙara sararin samaniya zuwa layin rubutu na 2 (Excel zai ƙara alamomi biyu a cikin sarari);
- Danna kan layi Text 3 a cikin akwatin maganganu;
- Danna kan B4 na cikin aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu;
- Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki;
- Sunan mai suna Mary Jones ya kamata ya bayyana a cell C4;
- Lokacin da ka danna kan tantanin C4 da cikakken aikin = SANTAWA (A4, "", B4) yana bayyana a cikin maɓallin tsari a sama da takardun aiki.
Nuna Ampersand a cikin Bayanin Rubutun Bayanai
Akwai lokuta da ake amfani da ampersanda a matsayin kalmar da kuma - irin su a cikin sunayen kamfanonin kamar yadda aka nuna a jere na shida na misali a sama.
Don nuna alamar ampersand a matsayin nau'in haruffa maimakon maimakon yin aiki a matsayin mai haɗari, dole ne a kewaye da shi a alamomi guda biyu kamar sauran rubutun rubutu - kamar yadda aka nuna a cikin maƙallin a D6.
Ya kamata a lura cewa a cikin wannan misali, wurare suna a kowane gefen ampersand don raba wannan hali daga kalmomi a kowane gefe. Don cimma wannan sakamakon, an shigar da harufan sararin samaniya a kowane bangare na ampersand a cikin jerin kalmomin biyu: "&".
Hakazalika, idan tsarin da aka yi amfani da ampersand yayin da aka yi amfani da mai yin amfani da tambayoyin, dole ne a haɗa haruffan sararin samaniya da kuma ampersand kewaye da sharuɗɗa guda biyu domin a bayyana shi a matsayin rubutu a cikin ma'anar tsari.
Misali, ana iya maye gurbin dabarar a cikin dakin D6 tare da tsari
= A6 & "&" & B6
don cimma wannan sakamako.