01 ngo-02
I-Excel I-CHAR / UNICHAR Umsebenzi
Umlingiswa ngamunye okhonjiswe ku-Excel ungempela inombolo.
Amakhompiyutha asebenza kuphela ngezinombolo. Izincwadi zezinhlamvu kanye nezinye izinhlamvu ezikhethekile - njenge-ampersand "&" noma i-hashtag "#" - zigcinwa futhi ziboniswa ngokunikeza inombolo ehlukile ngayinye.
Ekuqaleni, akuzona zonke amakhompiyutha asebenzisa uhlelo olufanayo lokubala noma ikhasi lekhodi uma bebala izinhlamvu ezahlukene.
Isibonelo, iMicrosoft ithuthukiswe amakhasi ekhodi ngokusekelwe ohlelweni lwekhodi ye-ANSI - i-ANSI ifushane ku- American National Standards Institute - ngenkathi amakhompyutha e-Macintosh esetshenziselwa ukusetha uhlamvu lwe-Macintosh .
Izinkinga zingavela uma uzama ukuguqula amakhodi womlingiswa kusuka ohlelweni oluya kolunye okuholela ekutheni idatha idalwe.
Ukusethwa kwe-Universal Character
Ukulungisa le nkinga isethi yomuntu wonke eyaziwa ngokuthi uhlelo lwe- Unicode lakhiwa ngasekupheleni kwawo-1980 ukuthi unikeza zonke izinhlamvu ezisetshenziswa kuzo zonke izinhlelo zekhompyutha ikhodi yezinhlamvu ezihlukile.
Kunamakhodi ayizinhlamvu ezingu-255 noma amakhodi wekhodi kukhasi lekhodi le-Windows ANSI ngenkathi uhlelo lwe-Unicode lwaklanyelwe ukubamba amaphuzu amakhodi ayisigidi.
Ngenxa yokuhambisana, amaphuzu angu-255 okuqala we-system ye-Unicode afana nalawo ohlelweni lwe-ANSI lwabalingisi bezinombolo zasentshonalanga nezinombolo.
Kulezi zinhlamvu ezijwayelekile, amakhodi ahlelwe kukhompyutha ukuze ukuthayipha incwadi ekhibhodi kufakwe ikhodi yombhalo ohlelweni olusetshenziswayo.
Izinhlamvu ezingekho-standard kanye nezimpawu - njengezithombe ze-copyright - © - noma izinhlamvu ezinembile ezisetshenziswe ngezilimi ezihlukahlukene zingangena ohlelweni ngokuthayipha ikhodi ye-ANSI noma inombolo ye-Unicode yomlingisi endaweni oyifunayo.
Imisebenzi ye-CHAR ne-CODE
I-Excel inemisebenzi eminingi esebenza nalezi zinombolo ngokuqondile: CHAR ne-CODE kuzo zonke izinguqulo ze-Excel, kanye ne-UNICHAR ne-UNICODE ethunyelwe ku-Excel 2013.
Imisebenzi ye-CHAR ne-UNICHAR ibuyisa umlingisi wekhodi eyinikeziwe ngenkathi imisebenzi ye-CODE ne-UNICODE yenza okuphambene - unike ikhodi ngomlingiswa onikeziwe. Isibonelo, njengoba kuboniswe esithombeni ngenhla,
- umphumela we = CHAR (169) uphawu lwe-copyright ©;
- ngenkathi umphumela we = CODE (©) ungama-169.
Ngokufanayo, uma imisebenzi emibili yayihlanganiswe ndawonye ngesimo
= I-CODE (CHAR (169))
umkhiqizo wefomula uzoba ngu-169, ngoba imisebenzi emibili yenza umsebenzi ohlukile womunye.
Imisebenzi ye-CHAR / UNICHAR I-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-CHAR yilezi:
= CHAR (Inombolo)
ngenkathi i-syntax yomsebenzi we-UNICHAR yile:
= UNICHAR (Inombolo)
Inombolo - (edingekayo) inombolo ephakathi kuka-1 no-255 ecacisa ukuthi iyiphi umlingiswa oyifunayo.
Amanothi :
Inomboro yombhalo ingaba nenombolo efakwe ngqo emsebenzini noma esitokisini sefoni endaweni yendawo encwadini yokusebenzela.
-Uma ukuphikisana kwenombolo akuyona inamba phakathi kuka-1 no-255, umsebenzi we-CHAR uzobuyisela i- #VALUE! inani lephutha njengoba kuboniswe kulayini 4 esithombeni ngenhla
Ngezinombolo zekhodi ezingaphezulu kuka-255, sebenzisa umsebenzi we-UNICHAR.
-kube ingxabano yeNombolo ye-zero (0) ingenisiwe, imisebenzi ye-CHAR ne-UNICHAR izobuyisela i- #VALUE! inani lephutha njengoba kuboniswe kulayini 2 esithombeni ngenhla
Ukufaka umsebenzi we-CHAR / UNICHAR
Izinketho zokufaka noma yikuphi ukufaka ukuthayipha umsebenzi ngokuzenzekelayo, njenge:
= CHAR (65) noma = UNICHAR (A7)
noma usebenzisa ibhokisi lebhokisi lezinhlelo zokusebenza ukufaka umsebenzi nendikimba yeNombolo .
Izinyathelo ezilandelayo zisetshenziselwa ukungena emsebenzini we-CHAR esitokisini B3 esithombeni ngenhla:
- Chofoza kuseli B3 ukuze wenze iseli elisebenzayo - indawo lapho imiphumela yomsebenzi iboniswa khona
- Chofoza kuthebhu yefomula yemenyu ye- ribbon
- Khetha Umbhalo kusuka kubhebhoni ukuze uvule uhlu oluhlehlisiwe lomsebenzi
- Chofoza ku- CHAR kuhlu ukuze ulethe ibhokisi lengxoxo lomsebenzi
- Ebhokisini lengxoxo, chofoza kulayini lombhalo
- Chofoza kuseli le-A3 kusikripthi sokufaka isicelo sokufaka lelo referensi yeseli ebhokisini lengxoxo
- Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
- Umlingiswa wokumaketha - ! - kufanele ibonakale esitokisini B3 kusukela ikhodi yezinhlamvu zayo ze-ANSI ingu-33
- Uma uchofoza kumakhalekhukhwini E2 umsebenzi ophelele = CHAR (A3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela
I-CHAR / UNICHAR Izisebenzi zokusebenza
Ukusetshenziswa kwemisebenzi ye-CHAR / UNICHAR kungaba ukuhumusha izinombolo zekhasi lekhasi zibe yizinhlamvu zamafayela adalwe kwezinye izinhlobo zekhompyutha.
Isibonelo, umsebenzi we-CHAR uvame ukusetshenziselwa ukususa izinhlamvu ezingadingeki ezivela nedatha engenisiwe. Umsebenzi ungasetshenziswa ngokubambisana neminye imisebenzi ye-Excel njenge-TRIM ne- SUBSTITUTE ngamafomula oklanyelwe ukususa lezi zinhlamvu ezingadingeki kusuka kwiphepha lokusebenzela.
02 ka 02
I-Excel CODE / UNICODE Umsebenzi
I-CODE / UNICODE Umsebenzi we-Syntax ne-Arguments
I-syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.
I-syntax yomsebenzi we-CODE yile:
= I-CODE (Umbhalo)
ngenkathi i-syntax yomsebenzi we-UNICODE yile:
= UNICODE (Umbhalo)
Umbhalo - (okudingekayo) umlingisi ofuna ukuthola inombolo yekhodi ye-ANSI.
Amanothi :
Ukuphikisana kombhalo kungaba ngumlingisi oyedwa ozungezwe amamaki okucaphuna kabili ("") angena ngqo emsebenzini noma esitokisini sefoni endaweni yalomlingisi ekhasini lokusebenzela njengoba kuboniswe emigqeni engu-4 no-9 esithombeni esingenhla
Uma ukuphikisana kombhalo kushiywe kungenalutho umsebenzi we-CODE uzobuyisela i- #VALUE! inani lephutha njengoba kuboniswe kulayini 2 esithombeni ngenhla.
Umsebenzi we-CODE ubonisa kuphela ikhodi yomlingisi womlingisi oyedwa. Uma i-argument yombhalo iqukethe umlingiswa ongaphezu kweyodwa - njengegama i- Excel eboniswe emigqeni engu-7 no-8 esithombeni ngenhla - kuphela ikhodi yomlingisi wokuqala iboniswa. Kulesi simo yiyona nombolo 69 okuyinto ikhodi uhlamvu lombhalo omkhulu E.
Izincwadi Zama-Avocacy vs. Lowercase Letters
Izinhlamvu ezinkulu noma izinhlamvu ezinkulu ekhibhodi zinamakhodi wezinhlamvu ezehlukene kunama-lowercase ahambisanayo noma izinhlamvu ezincane .
Isibonelo, inombolo yekhodi ye-UNICODE / ANSI ye-"A" engama-65 kuyilapho inombolo encane ye-UNICODE / ANSI yenombolo engezansi ikhonjisiwe emigqeni engu-4 no-5 esithombeni ngenhla.
Ukufaka umsebenzi we-CODE / UNICODE
Izinketho zokufaka noma yikuphi ukufaka ukuthayipha umsebenzi ngokuzenzekelayo, njenge:
= CODE (65) noma = UNICODE (A6)
noma ukusebenzisa ibhokisi lebhokisi lezinhlelo zokusebenza ukufaka umsebenzi kanye nokuphikisana kombhalo .
Izinyathelo ezilandelayo zisetshenziselwa ukufaka umsebenzi we-CODE esitokisini B3 esithombeni ngenhla:
- Chofoza kuseli B3 ukuze wenze iseli elisebenzayo - indawo lapho imiphumela yomsebenzi iboniswa khona
- Chofoza kuthebhu yefomula yemenyu ye-ribbon
- Khetha Umbhalo kusuka kubhebhoni ukuze uvule uhlu oluhlehlisiwe lomsebenzi
- Chofoza ku- CODE ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi
- Ebhokisini lebhokisi, chofoza ku- Text line
- Chofoza kuseli le-A3 kusikripthi sokufaka isicelo sokufaka lelo referensi yeseli ebhokisini lengxoxo
- Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
- Inombolo 64 kufanele ivele esitokisini B3 - lena ikhodi yomlingisi wezinhlamvu ze-ampersand "&"
- Uma uchofoza ku-cell B3 umsebenzi ophelele = I-CODE (A3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela