Masamba a Google Gwiritsani ntchito Ntchito

Gwirizanitsani maselo ambiri a deta mu selo yatsopano

Concatenate amatanthawuza kusonkhanitsa kapena kujowina zinthu ziwiri kapena zosiyana zomwe zilipo pamalo atsopano ndipo zotsatira zake zimakhala ngati chinthu chimodzi.

Mu Google Sheets, concatenation kawirikawiri amatanthauza kuphatikiza zomwe zili m'kati mwa maselo awiri kapena kuposerapo mu kapepala kachitatu pogwiritsa ntchito:

• Ntchito YOTCHITIKA; kapena
• Wothandizana nawo - ampersand ( & ).

01 a 03

Ponena za CONCATENATE Function Syntax

Zitsanzo zomwe zili mu phunziroli zimatanthawuza zinthu zomwe zili mu chithunzi chomwe chimaphatikizapo nkhaniyi.

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo ikuphatikizapo dzina la ntchito, mabaki, opatukana, ndi zifukwa

Chidule cha CONCATENATE ntchito ndi:

= CHIKHALA (chingwe1, chingwe2, chingwe3, ...)

• Mphindi1 imayenera. Ndilo choyamba cholowetsa deta kuti chiwonetsedwe ndi ntchito. Mtsutso uwu ukhoza kukhala mawu, selo limodzi lofotokozera malo a deta muzenera, zolemba zamaselo, malo osalongosoka, kapena manambala.
• String2, String3, ... Palibe malire omwe amaperekedwa pa chiwerengero cha zifukwa zomwe zingathe kuwonjezeredwa kuntchitoyi. Kutsutsana kulikonse kumayenera kupatulidwa ndi chida.

Kuwonjezera Mipata Yogwirizana ndi Malemba

Palibe njira yotsatizana yomwe imachoka pamalo opanda kanthu pakati pa mawu, zomwe ziri bwino pamene mukulowa mbali ziwiri za mawu amodzi monga Baseball kukhala imodzi kapena kuphatikiza manambala awiri ofanana monga 123456 .

Pogwirizanitsa mayina oyambirira ndi otsiriza kapena adiresi, zotsatira zake zimafunikira danga kuti danga likhale lophatikizidwa muzondomekozo. Ikuwonjezeredwa ndi maulendo awiri omwe akutsatiridwa ndi danga ndi zina zowonjezeredwa ("").

Kulinganiza Nambala ya Nambala

Ngakhale kuti chiwerengero chingawonetsedwe, zotsatira zake 123456 sizikutengedwa kuti ndi nambala ndi pulogalamu koma tsopano zikuwoneka ngati deta.

Zotsatira zomwe zili mu selo C7 sizingagwiritsidwe ntchito ngati zifukwa za masamu ena monga SUM ndi AVERAGE . Ngati kulowa kotereku kumaphatikizidwa ndi mfundo zokhudzana ndi ntchito, imatengedwa ngati deta ina yosasamala ndipo imanyalanyaza.

Chisonyezero chimodzi cha izi ndi chakuti deta yolumikizidwa mu selo C7 imayenderana ndi kumanzere, komwe ndiko kusinthika kosasintha kwa deta. Chotsatira chomwecho chikuchitika ngati CONCATENATE ntchito ikugwiritsidwa ntchito mmalo mwa wogulitsa konti.

02 a 03

Kulowa CONCATENATE Ntchito

Maofesi a Google samagwiritsa ntchito bokosi la dialogs kuti alowe m'mawu a ntchito monga momwe angapezere mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.

Tsatirani ndondomeko mu chitsanzo ichi kuti mulowetse CONCATENATE ntchito mu Google Mapepala. Musanayambe, tsegula pepala latsopano ndipo lowetsani mfundozo mu mizere isanu ndi iwiri ya zigawo A, B, ndi C momwe zikuwonetsedwera pa chithunzi chotsatira nkhaniyi.

1. Dinani pa selo C4 la spreadsheet la Google Maps kuti mupange selo yogwira ntchito .
2. Lembani chizindikiro chofanana ( = ) ndipo yambani kulemba dzina la ntchitoyo: konzani . Pamene mukuyimira, bokosi lopangira mothandizilo likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata C.
3. Pamene mawu OKHALITSIDWA akuwonekera m'bokosi, dinani pa icho ndi pointer ya mouse kuti mulowetse dzina la ntchito ndi kutsegula mzere wozungulira mu selo C4.
4. Dinani pa selo A4 mu tsamba lothandizira kuti mulowetse selo ili ngati ndondomeko yachingwe1 .
5. Lembani comma kuti mukhale olekanitsa pakati pa zifukwa.
6. Kuti muwonjezere malo pakati pa mayina oyambirira ndi otsiriza, yesani chizindikiro chobwereza katatu chotsatiridwa ndi danga lotsatiridwa ndi chizindikiro chachiwiri chobwereza mawu ( "" ). Imeneyi ndi ndondomeko yachidule .
7. Lembani wagawanika wachiwiri wotsatsa.
8. Dinani pa selo B4 kuti mulowetse selo ili ngati ndondomeko3.
9. Lembani fungulo lolowera kapena lobwezera pa khididiyi kuti mulowetse zolemba za kutsekemera pambali zokhudzana ndi ntchitoyo ndi kumaliza ntchitoyo.

Mawu omaliza a Mary Jones ayenera kuonekera mu selo C4.

Mukasindikiza pa selo C4, ntchito yonse
= CONCATENATE (A4, "", B4) ikuwoneka muzenera zamatabwa pamwamba pa tsamba.

03 a 03

Kuwonetsa Ampersand mu Concatenated Text Data

Pali nthawi pamene khalidwe la ampersand (&) limagwiritsidwa ntchito mmalo mwa mawu komanso monga maina a kampani monga momwe amachitira pa fano lachitsanzo.

Kuti muwonetse ampersand ngati munthu wolemba malemba m'malo mochita ngati operekeza, iyenera kuzunguliridwa ndi zilembo zamagulu awiri monga malemba ena.

Tiyenera kukumbukira kuti muchitsanzo ichi, malo amakhala mbali zonse za ampersand kuti apatule chikhalidwecho kuchokera m'mawu kumbali zonse. Kuti mukwaniritse zotsatirazi, anthu olemba malo amalowa mbali zonse za ampersand mkati mwa zizindikiro ziwiri zomwe zikugwiritsidwa ntchito motere: "&".

Mofananamo, ngati ndondomeko yogwiritsirana ntchito yomwe amagwiritsa ntchito ampersand monga yogwiritsira ntchito, amagwiritsa ntchito malo omwe ali pampando ndi ampersand atazungulidwa ndi malemba awiri omwe ayenera kuti awoneke kuti awoneke ngati malembawo.

Mwachitsanzo, njirayi mu selo D6 ingasinthidwe ndi ndondomekoyi

= A6 & "&" & B6

kuti mukwaniritse zotsatira zomwezo.