Ayyukan Wurin Lissafi na Google Sheets

Hada yawan kwayoyin bayanai a cikin sabon cell

Concatenate yana nufin haɗawa ko haɗa abubuwa biyu ko fiye da suka bambanta a sabon wuri tare da sakamakon da ake bi da shi azaman ɗayan mahaɗi.

A cikin Google Sheets, ƙaddara yawanci yana nufin hada haɗin ɓangaren biyu ko fiye a cikin takardun aiki a cikin ɓangare na uku da aka ware ta amfani da ko dai:

• Ayyukan GABATARWA; ko
• Kamfanin sadarwa na concatenation - ampersand ( & ).

01 na 03

Game da Sakamakon Sakamakon Sakamakon

Misalai a cikin wannan koyo na nufin abubuwa a cikin hoton da ke bin wannan labarin.

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, raɗaɗɗɗun ɓaɓɓuka, da muhawara

Hadawa don aikin CONCATENATE shine:

= SANTA (string1, string2, string3, ...)

• Ana buƙatar String1 . Wannan shi ne farkon shigarwar shigar da za a yi amfani da shi ta hanyar aiki. Wannan hujja na iya zama kalmomi, mahimmiyar ƙwayoyin salula zuwa wuri na bayanan a cikin takardun aiki, da kewayon labaran labaran, wurare marasa wuri, ko lambobi.
• String2, String3, ... Ba a ƙayyade iyaka ba akan yawan gardama da za a iya ƙarawa zuwa aikin. Kowace gardama dole ne a rabu da shi.

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, sakamakon yana buƙatar sararin samaniya don haka dole a haɗa sararin samaniya a cikin takaddama. An kara da shi tare da murya guda biyu biye da sararin samaniya da kuma wasu kalmomi biyu ("").

Ƙididdiga Bayanan Data

Kodayake lambobi za a iya ƙaddara, sakamakon sakamakon 123456 ba a sake la'akari da lambar ta hanyar shirin ba amma yanzu ana ganin shi azaman bayanan 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 alamun wannan shi ne cewa bayanan ƙaddamar da ƙwayoyin C7 na hagu zuwa hagu, wanda shine daidaiton tsoho don bayanan rubutu. Sakamakon wannan sakamako ya faru idan an yi amfani da aikin CONCATENATE maimakon mai aiki na concatenate.

02 na 03

Shigar da aikin GABATARWA

Google Sheets ba ya amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda za'a samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.

Bi matakai a cikin wannan misali don shigar da aikin CONCATENATE a cikin Google Sheets. Kafin ka fara, bude sabon lakaran da kuma shigar da bayanai a cikin layuka bakwai na ginshiƙai A, B, da C kamar yadda aka nuna akan hoton da ke bin wannan labarin.

1. Danna maɓallin C4 na layin rubutun Google ɗin don yin shi tantanin aiki .
2. Rubuta alamar daidai ( = ) kuma fara rubuta sunan aikin: concatenate . Yayin da kake bugawa, akwatin zane-zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da harafin C.
3. Lokacin da kalma CIKATARWA ya bayyana a cikin akwati, danna kan shi tare da maɓallin linzamin kwamfuta don shigar da sunan aikin kuma buɗe sashin zagaye a cikin C4.
4. Danna kan A4 a cikin takardun aiki don shigar da wannan tantanin halitta kamar yadda jimlar string1 yake .
5. Rubuta takaddama don aiki a matsayin mai raba tsakanin gardama.
6. Don ƙara sarari tsakanin sunayen farko da sunaye na karshe, rubuta alamar zabin biyun da ta biyo bayan sararin samaniya wanda ya biyo bayan alama ta biyu ( "" ). Wannan shi ne gardamar string2 .
7. Rubuta karo na biyu mai raɗaɗi.
8. Danna sel B4 don shigar da wannan tantanin halitta kamar yadda jayayyar string3 yake .
9. Danna maɓallin Shigarwa ko Komawa a kan keyboard don shigar da haɗin rufe kusa da muhawarar aikin kuma don kammala aikin.

Rubutun da aka ƙaddara Mary Jones ya kamata ya bayyana a cell C4.

Lokacin da ka danna kan tantanin C4, cikakkiyar aikin
= SANTAWA (A4, "", B4) yana bayyana a cikin maɓallin tsari a sama da takardun aiki.

03 na 03

Nuna Ampersand a cikin Bayanin Rubutun Bayanai

Akwai lokuta inda ake amfani da ampersand hali (&) a maimakon kalmar kuma kamar su a cikin sunayen kamfanonin kamar yadda aka nuna a cikin misali misali.

Don nuna alamar ampersand a matsayin nau'in rubutu maimakon a yi aiki a matsayin mai aiki na ƙwaƙwalwa, dole ne a kewaye shi da alamomi biyu kamar sauran rubutun rubutu.

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.