01 na 02
Excel CHAR / UNICHAR Ayyuka
Kowace hali da aka nuna a cikin Excel shi ne ainihin gaskiya a lamba.
Kwamfuta kawai suna aiki tare da lambobi. Takardun haruffa da sauran haruffa na musamman - irin su ampersand "&" ko hashtag "#" - ana adanawa da kuma nuna su ta hanyar ba da lambar daban-daban ga kowannensu.
Asalin, ba duka kwakwalwa suna yin amfani da tsarin lambobi guda ɗaya ko lambar sharuɗɗa ba yayin da lambobi daban-daban ke lissafa.
Alal misali, Microsoft ya ci gaba da shafukan shafuka wanda ya dogara da tsarin tsarin ANSI - ANSI takaice ne don Cibiyar Harkokin Kasa na Amirka - yayin da kwakwalwa ta Macintosh sun yi amfani da saitunan Macintosh .
Matsaloli zasu iya tashi lokacin ƙoƙarin juyar da lambobin halayen daga tsarin daya zuwa wani sakamakon sakamakon bayanai na garbled.
Tsarin Zane na Duniya
Don gyara wannan matsala a halin da ake ciki na duniya wanda aka sani da tsarin Unicode ya fara a ƙarshen shekarun 1980 wanda ya ba duk haruffa da aka yi amfani da shi a cikin dukkan na'urori na kwamfuta wanda ya zama lamari na musamman.
Akwai alamomin lambobi 255 ko maki na code a cikin takardar shafi na ANSI yayin da aka tsara tsarin Unicode don riƙe fiye da maki maki miliyan daya.
Domin sake dacewa, matakan farko na 255 na sabon tsarin Unicode sunyi daidai da tsarin ANSI don sunadaran haruffa da lambobi.
Ga waɗannan haruffan haruffan, an tsara lambobin zuwa kwamfutar don rubuta rubutun a kan keyboard shigar da lambar don harafin zuwa cikin shirin da ake amfani dashi.
Alamomin da ba a daidaita ba - kamar alamar haƙƙin mallakar haƙƙin mallaka - © - ko haruɗɗan haruffa da ake amfani da su a cikin harsuna dabam-dabam za a iya shiga cikin shirin ta buga a cikin lambar ANSI ko lambar Unicode don hali a wurin da ake so.
Tasirin CHAR da kuma Ayyukan CODE
Excel yana da ayyuka da yawa waɗanda ke aiki tare da waɗannan lambobin kai tsaye: CHAR da CODE ga dukan sassan Excel, tare da UNICHAR da UNICODE an gabatar da shi a Excel 2013.
Ayyuka na CHAR da UNICHAR sun dawo da hali don lambar da aka ba ta yayin da CODE da UNICODE ke aiki da kishi - ba da lambar don halin da aka ba. Alal misali, kamar yadda aka nuna a cikin hoto a sama,
- sakamakon don = CHAR (169) shine alamar haƙƙin mallaka ©;
- yayin sakamakon sakamakon = CODE (©) ne 169.
Hakazalika, idan an haɗa nauyin biyu a cikin nau'i na
= CODE (CHAR (169))
da fitarwa don wannan tsari zai kasance 169, tun da ayyukan biyu sunyi aiki na gaba da ɗayan.
Halin na CHAR / UNICHAR da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin aikin CHAR shine:
= CHAR (Lambar)
yayin haɗin aikin UNICHAR shine:
= UNICHAR (Lambar)
Lambar - (da ake buƙata) lamba tsakanin 1 da 255 ƙayyade abin da kake so.
Bayanan kula :
Lambar Magana zai iya zama lambar da aka shiga cikin kai tsaye a cikin aikin ko tantancewar salula zuwa wuri na lambar a cikin takarda.
-Idan ƙididdigar lamba ba lamba ce tsakanin 1 da 255, aikin CHAR zai dawo da #VALUE! nauyin kuskure kamar yadda aka nuna a jere 4 a cikin hoto a sama
Don lambobin lambobi fiye da 255, yi amfani da aikin UNICHAR.
- idan an shigar da gardama mai lamba na zero (0), ayyukan CHAR da UNICHAR zasu dawo da #VALUE! nauyin kuskure kamar yadda aka nuna a jere 2 a cikin hoto a sama
Shigar da aikin CHAR / UNICHAR
Zaɓuɓɓuka don shiga ko dai aiki sun haɗa da buga aikin tare da hannu, kamar:
= CHAR (65) ko = UNICHAR (A7)
ko amfani da maganganun maganganu don shigar da aikin da kuma Magana Number .
Ana amfani da matakai na gaba don shigar da aikin CHAR a cikin cell B3 a cikin hoton da ke sama:
- Danna kan tantanin halitta B3 don sa shi tantanin aiki - wurin da aka nuna sakamakon aikin
- Danna maɓallin Formulas na shafin rubutun
- Zaɓi Rubutu daga rubutun don buɗe jerin sauke ayyukan
- Danna CHAR a cikin jerin don kawo akwatin maganganun aikin
- A cikin akwatin maganganu, danna kan Lambar
- Danna kan A3 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
- Alamar alamar mamaki - ! - ya kamata ya bayyana a tantanin halitta B3 tun lokacin da kalmar ANSI ta kasance 33
- Lokacin da ka danna kan tantanin halitta E2 cikakken aikin = CHAR (A3) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
Kayan aikin CHAR / UNICHAR Yana amfani
Amfani da ayyukan CHAR / UNICHAR zai kasance don fassara lambar shafi na code zuwa haruffan fayilolin da aka kirkiro akan sauran nau'ikan kwakwalwa.
Alal misali, ana amfani da aikin CHAR don cire haruffan da ba a so ba tare da bayanan da aka shigo. Za'a iya amfani da aikin tare da wasu ayyuka na Excel irin su TRIM da SUBSTITUTE a cikin siffofin da aka tsara don cire wadannan haruffan da ba a so ba daga takardun aiki.
02 na 02
Excel CODE / UNICODE aiki
CODE / UNICODE Ayyukan aiki da jayayya
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara.
Haɗin kan aikin CODE shine:
= CODE (Rubutu)
yayin da haɗin aikin aikin UNICODE shine:
= UNICODE (Rubutun)
Rubutu - (buƙatar) halin da kake son nemo lambar lambar ANSI.
Bayanan kula :
Bayanan rubutun na iya zama nau'in halayen da ke kewaye da alamomi biyu ("") ya shiga cikin aikin ko tantancewar salula akan wurin da hali yake a cikin takardun aiki kamar yadda aka nuna a cikin layuka 4 da 9 a cikin hoto a sama
Idan an bar jigidar rubutu a banza aikin aikin CODE zai dawo da #VALUE! nauyin kuskure kamar yadda aka nuna a jere 2 a cikin hoto a sama.
Ayyukan CODE kawai nuna nau'in haruffa don hali guda. Idan hujjar rubutu ta ƙunshi hali fiye da ɗaya - kamar kalmar Excel da aka nuna a cikin layuka 7 da 8 a cikin hoton da ke sama - kawai lambar don hali na farko an nuna shi. A wannan yanayin shi ne lamba 69 wanda shine lambar haruffa don babban harafin E.
Uppercase vs. Lettercase Letters
Ƙwallafi ko haruffan haruffan a kan keyboard suna da lambobin halayen daban daban fiye da ƙananan ƙananan ko ƙananan haruffa.
Alal misali, lambar code UNICODE / ANSI ga babban "A" shine 65 yayin da ƙananan "lambar" UNICODE / ANSI lambar lambar 97 kamar yadda aka nuna a cikin layuka 4 da 5 a cikin hoton da ke sama.
Shigar da CODE / UNICODE Function
Zaɓuɓɓuka don shiga ko dai aiki sun haɗa da buga aikin tare da hannu, kamar:
= CODE (65) ko = UNICODE (A6)
ko amfani da maganganun maganganu don shigar da aikin da kuma Magana na Text .
Ana amfani da matakai na gaba don shigar da aikin CODE a cikin cell B3 a cikin hoton da ke sama:
- Danna kan tantanin halitta B3 don sa shi tantanin aiki - wurin da aka nuna sakamakon aikin
- Danna maɓallin Formulas na shafin rubutun
- Zaɓi Rubutu daga rubutun don buɗe jerin sauke ayyukan
- Danna CODE cikin jerin don kawo akwatin maganganun na aikin
- A cikin akwatin maganganu, danna kan Rubutun rubutu
- Danna kan A3 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
- Yawan lamba 64 ya kamata ya bayyana a tantanin halitta B3 - wannan shine lambar haruffan ampersand hali "&"
- Lokacin da ka danna kan tantanin B3 da cikakken aikin = CODE (A3) ya bayyana a cikin maɓallin tsari a sama da takardun aiki