IMacGyver yayisebenzisa. Izisebenzi ze-Apollo 13 nazo zayisebenzisa. Ngaso sonke isikhathi esimweni esinzima, lapho udinga ukuxhumanisa izinto ezimbili, abantu bathatha i-tape. Ungase umangale, kodwa i-Excel inomsebenzi owakhelwe ngaphakathi owenza okufanayo. Lona umsebenzi CONCATENATE (I-CUTCH).
Umsebenzi CONCATENATE (CONCATENATE) ikuvumela ukuthi uxhume izingcezu ezimbili noma ngaphezulu zombhalo kuseli eyodwa. Ngaphandle kwegama elide, kulula kakhulu ukulisebenzisa futhi lisebenza ngendlela efanayo kuzo zonke izinguqulo ze-Excel kanye namanye amaspredishithi afana ne-Google AmaSpredishithi.
Qaphela: Uma ungakaze usebenzise imisebenzi ye-Excel ngaphambilini, ungabheka isigaba Amafomula kanye Nemisebenzi Bona i-Excel Tutorial yethu yabaqalayo ukuthola uchungechunge lwezifundo ngalesi sihloko.
Ukuxhumanisa amagama
Ake sithi sinetafula elinolwazi lokuxhumana lapho isibongo nesibongo sikukholomu ehlukene. Sifuna ukuwaxhuma futhi sithole igama eliphelele lomuntu ngamunye. Esithombeni esingezansi ubona amagama kukholamu B, nezibongo kukholamu A. Ifomula yethu izoba kuseli E2.
Ngaphambi kokuba siqale ukufaka ifomula, qonda iphuzu elibalulekile: umsebenzi I-STsEPIT izobopha kuphela lokho okucacisayo hhayi okunye. Uma ufuna izimpawu zokubhala, izikhala, noma enye into ukuthi ivele kuseli, yengeze kuma-agumenti omsebenzi.
Kulesi sibonelo, sifuna isikhala phakathi kwamagama (ukugwema into efana - JosephineCarter), ngakho-ke sizodinga ukwengeza isikhala kuzimpikiswano. Ngakho, sizoba nezimpikiswano ezintathu:
- B2 (Igama Lokuqala) - igama
- "" – umlingiswa wesikhala kumamaki wokucaphuna
- A2 (Isibongo) - isibongo
Manje njengoba ama-agumenti esechaziwe, singabhalela iseli E2 nansi ifomula:
=CONCATENATE(B2," ",A2)
=СЦЕПИТЬ(B2;" ";A2)
Njenganoma yimuphi omunye umsebenzi we-Excel, i-syntax ibalulekile. Khumbula ukuqala ngophawu olulinganayo (=) futhi ubeke imingcele (ukhefana noma isemikholoni) phakathi kwezimpikiswano.
Qaphela: beka ukhefana noma isemikholoni phakathi kwezimpikiswano - kuncike ekutheni uhlala kuliphi izwe nokuthi usebenzisa luphi uhlobo lwe-Excel.
Yilokho kuphela! Uma ucindezela Faka, igama eligcwele lizovela: Josephine Carter.
Manje, ngokuhudula isibambo sokugcwalisa ngokuzenzakalelayo, kopisha ifomula kuwo wonke amaseli kuze kufike lapho E11. Ngenxa yalokho, igama eligcwele lizovela kumuntu ngamunye.
Uma ufuna ukwenza umsebenzi ube nzima, zama ukusebenzisa umsebenzi I-STsEPIT xhuma idolobha nesifunda kukholomu Fukubukeka njengesithombe esingezansi:
Ukuhlobanisa izinombolo nombhalo
Ukusebenzisa imisebenzi I-STsEPIT Ungakwazi ngisho nokuxhuma izinombolo nombhalo. Ake sicabange ukuthi sisebenzisa i-Excel ukuze sigcine amarekhodi e-inventory esitolo. Manje sesinayo Ama-apula we-25 (ama-apula), kodwa inombolo “25” kanye negama elithi “ama-apula” agcinwe kumaseli ahlukene. Ake sizame ukuwaxhuma kuseli eyodwa ukuze sithole into efana nale:
Sidinga ukuhlanganisa izici ezintathu:
- F17 (Inombolo isitokwe) — quantity
- "" – umlingiswa wesikhala kumamaki wokucaphuna
- F16 (Umkhiqizo) - igama
Faka ifomula elandelayo kuseli E19:
=CONCATENATE(F17," ",F16)
=СЦЕПИТЬ(F17;" ";F16)
Masikwenze kube nzima! Ake sithi sifuna ukuthola: Sinamahhabhula angama-25 (Sinama-apula angama-25). Ukuze wenze lokhu, udinga ukwengeza enye impikiswano - inkulumo ethi "Sine":
=CONCATENATE("We have ",F17," ",F16)
=СЦЕПИТЬ("We have ";F17;" ";F16)
Ungangeza izimpikiswano ezengeziwe uma ufisa ukwakha isisho esiyinkimbinkimbi. Into esemqoka okufanele uyikhumbule ukuthi i-syntax yefomula kufanele inembe kakhulu, ngaphandle kwalokho ingase ingasebenzi. Kulula ukwenza iphutha ngefomula enkulu!