Khipha Izinhlamvu Ezivela Kudatha ku-Excel

Indlela yokusebenzisa umsebenzi we-Excel RIGHT

Umsebenzi we-Excel RIGHT uvumela ukuthi ususe izinhlamvu ezingadingeki kusuka kudatha engenisiwe. Uma umbhalo ukopishwa noma ungeniswe ku-Excel, izinhlamvu zedaka engafuneki ngezinye izikhathi zifakwe nedatha enhle.

Noma, kunezikhathi lapho kuphela ingxenye yedatha yombhalo esitokisini edingekayo, njengegama lomuntu lokuqala kodwa hhayi igama lokugcina.

Ezimweni ezinjengalezi, i-Excel inemisebenzi eminingi engasetshenziselwa ukususa idatha engadingeki kusuka kwabanye. Yimuphi umsebenzi oyisebenzisayo kuncike lapho idatha efunayo ikhona khona ngokuhambisana nezinhlamvu ezingadingeki esitokisini.

• Uma idatha efunayo ingakwesokudla kwedatha, sebenzisa umsebenzi we-RIGHT ukuyikhipha. Lokhu kufundisa kuzokubonisa ukuthi lolu msebenzi lusetshenziswa kanjani.
• Uma idatha efunayo ingakwesokunxele kwedatha, sebenzisa umsebenzi we-LEFT ukuze uyisuse.
• Uma idatha efunayo inezinhlamvu ezingafuneki ezinhlangothini zalo zombili, sebenzisa umsebenzi we-MID ukukhipha.

01 ka-03

I-RIGHT Function Syntax ne-Arguments

Ku-Excel, i-syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, abazali, nezimpikiswano .

I-syntax yomsebenzi we-RIGHT yile:

= KUPHELA (Umbhalo, Num_chars)

Izimpendulo zomsebenzi zitshela i-Excel ukuthi iyiphi idatha okufanele isetshenziswe kulo msebenzi nobude bezintambo ezizokhishwa.

Umbhalo- (Okudingekayo) ukungena okuqukethe idatha oyifunayo. Le mpikiswano ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela , noma kungaba umbhalo oqobo ohlanganiswe kumamaki okucaphuna.

I-Num_chars- (Okokuzithandela) icacisa inani labalingiswa ngakwesokudla kwezingxabano zezintambo okufanele zigcinwe; zonke ezinye izinhlamvu zisusiwe. Le mpikiswano kufanele ibe mkhulu kunokulingana no-zero. Uma le mpikiswano ingavaliwe, inani elizenzakalelayo lezinhlamvu ezingu-1 lisetshenziswe umsebenzi. Uma lokhu kunkulu kunombhalo wombhalo, umsebenzi ubuyisela wonke umbhalo.

02 ka-03

Isibonelo: Ukususa Abalingiswa Abangadingeki Ngomsebenzi OPHAMBILI

Isibonelo esithombeni ngenhla sisebenzisa umsebenzi WOKULUNGA

• khipha i- widget yegama kusukela kokungena kombhalo owedlule * & ^% iwijethi esesitokisini B1 kushidi lokusebenzela
• khipha 789876 kusuka enombolweni ende 123456789876 esesitokisini B2 kushidi lokusebenzela

Ngezansi izinyathelo ezichaza indlela umphumela wokuqala owatholwa ngayo.

Izinketho zokufaka umsebenzi WOKULUNGA kanye neziphakamiso zawo zibe esitokisini B1 zihlanganisa:

1. Ukuthayipha umsebenzi ophelele = LOKUPHILA (B1,6) kuseli C1.
2. Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi

Ukusebenzisa ibhokisi lokungena ukufaka umsebenzi ngokuvamile kunciphisa umsebenzi, njengoba ibhokisi lebhokisi lengxoxo liyakhathalela i-syntax yomsebenzi ngokufaka igama lomsebenzi, ama-separators ama-commas, namabakaki ezindaweni ezifanele nobuningi.

Ukubhekisela ekubhekisweni kwezingcingo

Kungakhathaliseki ukuthi iyiphi inketho oyikhethayo yokufaka umsebenzi kufinyelela kumakhalekhukhwini, kungcono kakhulu ukusebenzisa ukukhomba ukufaka noma yikuphi ukuboniswa kwamaseli asetshenziswa njengezingxabano.

Ukuphawula kuhilela ukusebenzisa i-pointer yegundane ukuchofoza kwisithenjwa sefoni ukuze ungene emsebenzini. Ukwenza kanjalo kusiza ukuqeda amaphutha abangelwa ukuthayipha ekubhekisweni kweselula okungalungile.

Ukusebenzisa ibhokisi lokusebenza le-RIGHT Function

Faka umsebenzi we-RIGHT kanye neziphakamiso zawo zibe esitokisini C1 usebenzisa ibhokisi lengxoxo lomsebenzi:

1. Chofoza kuseli C1 ukuze wenze iseli elisebenzayo- yilapho imiphumela yomsebenzi izoboniswa khona.
2. Chofoza ithebhu yefomula yemenyu ye- ribbon .
3. Khetha Umbhalo kusuka ku-Ribbon ukuvula uhlu lokudonsa phansi.
4. Chofoza KULUNGILE ohlwini ukuze ukhiphe ibhokisi lengxoxo lomsebenzi.
5. Ebhokisini lebhokisi, chofoza i- Text line.
6. Chofoza kuseli B1 kushidi lokusebenzela.
7. Chofoza kwi- Num_chars line.
8. Thayipha inomboro yesithupha (6) kulo mkhakha ngoba sifuna ukugcina izinhlamvu eziyisithupha ezifanele.
9. Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela.

Umbhalo okhishwe "Iwijethi" kufanele uvele kuseli C1.

Uma uchofoza ku-cell C1, umsebenzi ophelele = UBULUNGILE (B1,6) uvela ebhawulweni yefomula ngaphezulu kwephepha lokusebenzela.

03 ka 03

Ukukhipha Izinombolo Ngomsebenzi OPHAMBILI

Njengoba kuboniswe emgqeni wesibili wesibonelo esingenhla, umsebenzi we-RIGHT ungasetshenziswa ukukhipha i-subset yedatha yenombolo kusukela enombeni ende usebenzisa izinyathelo ezibalulwe.

Inkinga kuphela ukuthi idatha ekhishiwe ishintshiwe ibe yombhalo futhi ayikwazi ukusetshenziswa ekubalweni okubandakanya imisebenzi ethile, njengemisebenzi ye- SUM kanye ne- AVERAGE .

Enye indlela ezungeze le nkinga ukusebenzisa umsebenzi we-VALUE ukuguqula umbhalo ube yinombolo.

Ngokwesibonelo:

= VALUE (RIGHT (B2, 6))

Okwesibili ukhethe ukunamathisela okhethekile ukuguqula umbhalo kumanani .