Excel QHATHISWA Umsebenzi

01 ngo 01

Hlanganisa iiSele zeTekisi zeDatha kwi-Excel

Umxholo ngokubanzi

I-Concatenate ithetha ukudibanisa okanye ukudibanisa ndawonye izinto ezimbini okanye ngaphezulu ezithe zahlula kwindawo entsha kunye nesiphumo sokuphathwa njengento enye.

Kwi-Excel, ngokugqithiseleyo kubhekisela ekuhlanganiseni iziqulatho ezimbini okanye ngaphezulu kwiphepha lokusebenzela kwisithathu, iseli ehlukileyo usebenzisa:

• UMSEBENZISWANO WOMSEBENZI - imigqa enye, emine, neyesithandathu kumfanekiso ongentla;
• usebenzisa umqhubi we-concatenation - i-ampersand ( & ) - imigangatho emibini neyesihlanu ngaphezulu.

Ukongeza iZithuba zoMxholo oCwangcisiweyo

Ayikho indlela yokubambisana ngokuzenzekelayo ishiya indawo engenanto phakathi kwamagama, okulungileyo xa ujoyina iindawo ezimbini zegama elifana nebhola njengeBhola ibe enye okanye udibanisa uluhlu lwamanani anjengo- 123456 .

Xa ujoyina amagama okuqala neyokugqibela okanye idilesi, nangona kunjalo, ufuna i-space ukuze isikhala kufuneka sifakwe kwifom ye-concatenation - imigangatho emine, ezintlanu, neyesithandathu.

I-Syntax yeMisebenzi kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.

I-syntax yOMSEBENZI WOKUQINISWA ngu:

= QHUBANISELWE (Umbhalo1, Umbhalo2, ... Umbhalo255)

Umbhalo1 - (ofunekayo) unokuba ngumxholo okhethekileyo njengamagama okanye iinombolo, izithuba ezingenanto ezizungezwe ngamanqaku okucaphuna, okanye iinkcukacha zeseli kwindawo yokusebenza kwiphepha lokusebenzela

Umbhalo2, Umbhalo3, ... Umbhalo255 - (ukhetho) ukuya kwi-255 umbhalo ongenayo unokungeniswa kwi-CONCATENATE umsebenzi ukuya kumaqela angama-8 192 - kuquka iindawo. Ngangomnye umnyango kufuneka uhlukaniswe yi-comma.

Ikhonkco yeNombolo yeDatha

Nangona amanani angabonakaliswa - njengoko kubonwe kumqolo wesithandathu ngentla - umphumo 123456 awusayi kuqwalaselwa kwinani ngenkqubo kodwa ngoku ibonakala njengedatha yombhalo.

Idatha ekhokelela kwiseli C7 ayinakusetyenziswa njengeengxoxo malunga nemisebenzi ethile yemathematika njenge- SUM ne- ALLVERAGE . Ukuba loo ngeniso ifakiwe kunye neengxoxo zomsebenzi, iphathwa njengenye yedatha yombhalo kwaye inganakwa.

Esinye isibonakaliso kukuba idatha edityanisiweyo kwiseli C7 ilungelelaniswe ngakwesobunxele-ukulungelelaniswa okungafaniyo kwedata yombhalo. Isiphumo esifanayo siya kwenzeka xa umsebenzi OQINISEKILEYO usetyenziswe endaweni yomqhubi we-concatenate.

I-Excel's CONCATENATE Function Example

Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo uya kudibanisa idatha efunyenwe kwiiseli ezahlukileyo kwiiseli ze-A4 kunye ne-B4 kwiphepha lokusebenzela kwiselinye enye kwikholomu C.

Ekubeni umsebenzi we-concatenate awushiyi ngokuzenzekelayo indawo engekho phakathi kwamagama okanye enye idatha, isikhala siya kudibaniswa kumgca wesiqendu 2 kwibhokisi yencoko usebenzisa ibha yendawo kwikhibhodi.

Ukufaka umsebenzi OQHENZISAYO

Nangona kunokwenzeka ukuba uthayiphe nje umsebenzi opheleleyo ngokwezifiso ezifana: = UKUQHATHISWA (A4, "", B4), abaninzi abantu bakuthola kulula ukusebenzisa ibhokisi yencoko yababini ukuba bafake iingxoxo zomsebenzi, kuba ibhokisi yencoko ibakhathalela ukungena amabakaki, ii-commas kwaye, kulo mzekelo, amanqaku okucaphuna azungeze indawo engenanto.

Amanyathelo angezantsi angena kulo msebenzi usebenzisa ibhokisi yencoko kwibhokisi yeC2.

1. Cofa kwiseli C2 ukuze wenze iseli esebenzayo ;
2. Cofa kwiThebhu yefomula;
3. Khetha Imisebenzi Yombhalo kwi- Ribbon ukuvula uluhlu lwehla lokuhla;
4. Cofa kwi- CONCATENATE kwoluhlu ukuzisa ibhokisi yencoko yencoko yomsebenzi;
5. Cofa kumgca we- 1 kwibhokisi yencoko;
6. Cofa kwifowuni A4 kwiphepha lokusebenzela ukuze ufake ifowuni yeefayile kwibhokisi yencoko;
7. Cofa kumgca we- 2 kwibhokisi yencoko;
8. Cinezela ibha yendawo kwibhodibhodi ukongeza isikhala ukuya kumgca weTekisi 2 (i-Excel iya kwongeza amanqaku angama-quotation angaphantsi kwithuba);
9. Cofa kumgca we- 3 kwibhokisi yencoko;
10. Cofa kwifowuni B4 kwiphepha lokusebenzela ukuze ufake loo ntetho yeselenki kwibhokisi yencoko;
11. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela;
12. Igama eliqingqiweyo elithi Mary Jones kufuneka livele kwiseli C4;
13. Xa ucofa kwiseli C4 umsebenzi opheleleyo = UCCATENATE (A4, "", B4) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

Ukubonisa ii-Ampersand kwi-Data Conquered Data Data

Kukho amaxesha apho uhlamvu lwe-ampersand lisetyenziswe endaweni yegama kwaye- njengamagama enkampani njengoko kuboniswe kumqolo wesithandathu ngomzekelo ongentla.

Ukubonisa i-ampersand njengomgca wombhalo kunokuba wenze njengomqhubi we-concatenation, kufuneka ijikelezwe ngamanqaku okucaphuna aphindwe kabini njengabanye abalinganiswa bombhalo - njengoko kuboniswe kwifom kwifayile ye-D6.

Kufuneka kuqatshelwe ukuba kulo mzekelo, izikhala zikhona ngaphesheya kwe-ampersand ukwenzela ukwahlula lo mlingiswa ukusuka kumazwi ngaphesheya. Ukufezekisa le miphumo, abalinganiswa bendawo bayangena ngaphesheya kwe-ampersand ngaphakathi kwamanqaku okucaphulwa kabini kule ndlela: "&".

Ngokufanayo, ukuba ifomantenation formula esebenzisa i-ampersand njengomqhubi we-concatenation isetyenzisiweyo, abalinganiswa beendawo kunye ne-ampersand ezijikelezwe ngamagama acatshulwa ngokuphindaphindiweyo kufuneka kwakhona zifakwe ukwenzela ukuba zibonwe njengetekisi kwimiphumo yefomula.

Ngokomzekelo, ifomu kwifom ye-D6 ingatshintshwa yindlela

= A6 & "&" & B6

ukuphumeza iziphumo ezifanayo.