Ungayijoyina njani imitya yamagama kwi-Excel 2007 kunye noMqhubi

NguGreg Harvey

Ungasebenzisa ampersand (&) Umsebenzi ku concatenate (okanye ujoyine) imitya eyahlukeneyo yokubhaliweyo kunye kwi-Excel 2007. Umzekelo, kuludwe lwabathengi kwiphepha lokusebenzela elibandakanya amagama okugqibela kwikholamu A kunye namagama okuqala kwikholamu B, ungasebenzisa lo msebenzisi ukudibanisa amagama okugqibela nawokugqibela ungeno olunye (olunegama lokuqala nelokugqibela elahlulwe ngesithuba) kwikholamu C. Bhekisa kumzekelo okweli nani lilandelayo.



Olu luhlu lokusebenzela luluhlu lwamagama okuqala nawokugqibela abaxumi kwiikholamu ezahlukeneyo.Olu luhlu lokusebenzela luluhlu lwamagama okuqala nawokugqibela abaxumi kwiikholamu ezahlukeneyo.

Ukujoyina igama lokuqala kwiseli B3 kunye negama lokugqibela lokungena kwiseli A3, uza kufaka le fomyula ilandelayo kwiseli C3:



=B3&' '&A3

Qaphela ukusetyenziswa kweekowuti ezimbini kule fomyula. Bafaka indawo engenanto ebekwe phakathi kwamagama okugqibela kunye namagama okugqibela ahlanganiswe kubo kunye nabaqhubi be concatenation. Ukuba awubandakanyi esi sithuba kwifomula kwaye ujoyine amagama okugqibela kunye namagama okugqibela kunye nale fomyula:

=B3&A3

I-Excel iya kubuyaUChristopherAikenkwiseli C3, onke njengegama elinye.



Emva kokungena kwifomula yokuhlangana edibanisa amagama okugqibela kunye nokugqibela kwiseli C3 eyahlulwe ngesithuba esinye, ungarhuqa isiphatho sokugcwalisa kwikona esezantsi ekunene yeseli C3 ukuya kwi-C17 ukukopa ifomula kwaye ujoyine bonke abanye abathengi amagama kwikholamu C.

Iphepha lokusebenzela emva kokudibanisa amagama okugqibela kunye nokugqibela kwikholamu C.Iphepha lokusebenzela emva kokudibanisa amagama okugqibela kunye nokugqibela kwikholamu C.

Emva kokuba ifomula yentsingiselo yentsusa ikhutshelwe ezantsi kwimiqolo yekholamu C, unokukopa uluhlu lweeseli ezikhethiweyo C3: C17 kwibhodi eqhotyoshwayo ngokunqakraza ku Khuphela iqhosha kwiqela lebhodi eqhotyoshwayo lethebhu yasekhaya, emva koko ucofe ngokukhawuleza amaxabiso okuncamathisela kwi Cola iqhosha lokuyalela kwimenyu eyehlayo kwiKhaya thebhu. Ezi pastes zibaliwe amaxabiso okubhaliweyo ngaphezulu kweefomula zekhonkathi, ngaloo ndlela zithatha indawo yeefomula zentsusa. Isiphumo soluhlu lwamagama okugqibela nawokugqibela ngokudibeneyo kwiiseli ezifanayo kuluhlu C3: C17.