Excel KUGWIRITSANI NTCHITO Ntchito

01 ya 01

Gwirizanitsani Magulu a Malemba Data mu Excel

Concatenation Mwachidule

Concatenate amatanthawuza kusonkhanitsa kapena kujowina pamodzi zinthu ziwiri kapena zingapo zomwe zilipo padera pamalo atsopano ndi zotsatira kuti zikhale ngati chinthu chimodzi.

Mu Excel, concatenation kawirikawiri imatanthawuza kuphatikiza zomwe zili m'kati mwa maselo awiri kapena kuposerapo mu kapepala kamene kali mu selo losiyana pogwiritsa ntchito:

• Ntchito YOMWEYO - mizere, imodzi, ndi sikisi mu chithunzi pamwambapa;
• pogwiritsa ntchito ovomerezeka - ampersand ( & ) - mizere iwiri ndi isanu pamwambapa.

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, amafunikira danga kuti danga likhale lophatikizidwa muzowonjezeretsa - mizere inayi, isanu ndi sikisi pamwambapa.

Syntax ndi Zokambirana za COMPASS

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa.

Chidule cha CONCATENATE ntchito ndi:

= ZOKHUDZA (Malemba1, Text2, ... Text255)

Text1 - (yofunika) ikhoza kukhala mau enieni monga mawu kapena manambala, malo osabvundidwa ozunguliridwa ndi zizindikiro, kapena ma selo omwe amapezeka pa deta

Text2, Text3, ... Text255 - (zosankha) mpaka malemba 255 malemba angathe kuwonjezeredwa ku CONCATENATE ntchito kuposa 8,192 zida - kuphatikizapo malo. Chilowe chilichonse chiyenera kupatulidwa ndi chida.

Kulinganiza Nambala ya Nambala

Ngakhale chiwerengero chingawonetsedwe - monga momwe tawonera mu mzere wachisanu ndi chimodzi - 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.

Chizindikiro chimodzi ndi chakuti deta yosinthidwa mu selo C7 ikugwirizana ndi kumanzere - kusanthana kosasinthika kwa deta. Chotsatira chomwecho chikanachitika ngati CONCATENATE ntchito ikugwiritsidwa ntchito mmalo mwa wogwiritsira ntchito.

Excel's CONCATENATE Function Chitsanzo

Monga momwe tawonera pa chithunzi pamwambapa, chitsanzo ichi chiphatikizapo deta yomwe imapezeka mumaselo osiyana m'maselo A4 ndi B4 a pepala lokhala ndi selo limodzi m'mbali C.

Popeza ntchito ya concatenate siimachoka pamalo opanda kanthu pakati pa mawu kapena deta ina, danga lidzawonjezeredwa ku mzere Wolemba 2 wa bokosilo pogwiritsa ntchito bolodi lachinsinsi pa keyboard.

Kulowa CONCATENATE Ntchito

Ngakhale kuti n'zotheka kungolemba ntchito yonseyo monga: = CONCATENATE (A4, "", B4), anthu ambiri amavutika kuti agwiritse ntchito bokosi la polojekitiyi kuti alowe m'mawu a ntchito, chifukwa bokosi la polojekiti likuyang'anira kulowa mabakoketi, makasitomala, ndi chitsanzo ichi, zizindikiro za quotation zomwe zikuzungulira malo opanda kanthu.

Masitepe omwe ali pansipa alowetsa ntchitoyo pogwiritsa ntchito bokosilo mu selo C2.

1. Dinani pa selo C2 kuti mupange selo yogwira ntchito ;
2. Dinani pa tabu Zamkatimu ;
3. Sankhani Malemba Ntchito kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi;
4. Dinani pa CONCATENATE mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
5. Dinani pa Mzere 1 mubox;
6. Dinani pa selo A4 mu tsambalo kuti mulowetse selolo mu bokosi la dialog;
7. Dinani pa Mzere 2 mu bokosi la dialog;
8. Pewani kamatabwa ka pakiti pa khididiyi kuti muwonjezere malo oti muyambe kulembera Text 2 (Excel idzawonjezera zizindikiro ziwiri zomwe zili pambali);
9. Dinani pa Mzere 3 mu bokosi la dialog;
10. Dinani pa selo B4 papepala kuti mulowetse selolo mu bokosi la dialog;
11. Dinani OK kuti mutseke bokosi la bokosi ndikubweranso ku tsamba la ntchito;
12. Dzina lovomerezeka lakuti Mary Jones liyenera kuoneka mu selo C4;
13. Mukasindikiza pa selo C4 ntchito yonse = CONCATENATE (A4, "", B4) ikuwonekera pa bar barula pamwamba pa tsamba.

Kuwonetsa Ampersand mu Concatenated Text Data

Pali nthawi pamene chikhalidwe cha ampersand chimagwiritsidwa ntchito mmalo mwa mawu ndi -monga maina a kampani monga momwe akuwonetsedwa mzere wachisanu ndi chimodzi cha chitsanzo pamwambapa.

Kuti muwonetse ampersand ngati munthu wolemba malemba m'malo mochita ngati operekeza, ayenera kuzunguliridwa ndi zilembo zamagulu awiri monga malemba ena - monga momwe amachitira pa selo D6.

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.