Okuqukethwe
Siyakuhalalisela! Ufinyelele ekupheleni kwesonto lokuqala lemarathon 30 Excel isebenza ngezinsuku ezingama-30, ngifunde umsebenzi izolo IQINILE (KULUNGILE). Namuhla sizophumuza kancane futhi sibheke umsebenzi ongenawo amacala amaningi okusebenzisa - umsebenzi I-CODE (IKHODI). Ingasebenza kanye neminye imisebenzi kumafomula amade futhi ayinkimbinkimbi, kodwa namuhla sizogxila kulokho engakwenza ngokwayo ezimweni ezilula.
Ngakho-ke, ake sibhekane nolwazi lwereferensi lomsebenzi I-CODE (IKHODI) futhi ucabangele izinketho zokusetshenziswa kwayo ku-Excel. Uma unamathiphu noma izibonelo zokusebenzisa, sicela wabelane ngazo kumazwana.
Umsebenzi 07: IKHODI
Umsebenzi I-CODE (CODE) ibuyisela ikhodi yenombolo yohlamvu lokuqala lweyunithi yezinhlamvu yombhalo. Ku-Windows, lokhu kuzoba ikhodi evela etafuleni ANSI, kanye ne-Macintosh – ikhodi evela kuthebula lophawu I-Macintosh.
Ungawusebenzisa kanjani umsebenzi weKHODI?
Umsebenzi I-CODE (CODESYMB) ikuvumela ukuthi uthole izimpendulo zemibuzo elandelayo:
- Ithini inhlamvu efihliwe ekugcineni kombhalo ongenisiwe?
- Ngingalufaka kanjani uhlamvu olukhethekile kuseli?
I-Syntax CODE
Umsebenzi I-CODE (IKHODI) ine-syntax elandelayo:
CODE(text)
КОДСИМВ(текст)
- umbhalo (umbhalo) uwuchungechunge lombhalo ofuna ukulithola ikhodi yalo yokuqala.
Izicupho CODE (CODE)
Imiphumela ebuyiswe umsebenzi ingase ihluke kumasistimu wokusebenza ahlukene. Amakhodi ezinhlamvu ze-ASCII (32 kuya ku-126) ngokuvamile ahambisana nezinhlamvu kukhibhodi yakho. Nokho, izinhlamvu zezinombolo eziphezulu (kusuka ku-129 kuya ku-254) zingahluka.
Umbhalo okopishwe kuwebhusayithi kwesinye isikhathi uqukethe izinhlamvu ezifihliwe. Umsebenzi I-CODE (IKHODI) ingasetshenziswa ukuthola ukuthi bayini laba balingisi. Isibonelo, iseli B3 iqukethe iyunithi yezinhlamvu yombhalo equkethe igama elithi “test' inezinhlamvu ezi-4 sezizonke. Kuseli C3, umsebenzi LEN (DLSTR) ibale ukuthi kunezinhlamvu ezi-3 kuseli B5.
Ukunquma ikhodi yohlamvu lokugcina, ungasebenzisa umsebenzi KUPHELA (KWESOKUDLA) ukuze ukhiphe uhlamvu lokugcina lweyunithi yezinhlamvu. Bese usebenzisa umsebenzi I-CODE (IKHODI) ukuze uthole ikhodi yalolo mlingisi.
=CODE(RIGHT(B3,1))
=КОДСИМВ(ПРАВСИМВ(B3;1))
Kuseli D3, ungabona ukuthi uhlamvu lokugcina lwentambo lunekhodi 160, okuhambisana nesikhala esinganqamuki esisetshenziswa kumawebhusayithi.
Isibonelo sesi-2: Ukuthola ikhodi yomlingiswa
Ukufaka izinhlamvu ezikhethekile kusipredishithi se-Excel, ungasebenzisa umyalo uphawu (Izimpawu) ithebhu Insertion (Faka). Isibonelo, ungafaka uphawu lwedigri ° noma uphawu lwe-copyright ©.
Uma uphawu selufakiwe, ikhodi yalo inganqunywa kusetshenziswa umsebenzi I-CODE (KODSIMV):
=IF(C3="","",CODE(RIGHT(C3,1)))
=ЕСЛИ(C3="";"";КОДСИМВ(ПРАВСИМВ(C3;1)))
Manje njengoba usuyazi ikhodi, ungafaka uhlamvu usebenzisa ikhiphedi yezinombolo (hhayi izinombolo ezingenhla kwekhiphedi yezinhlamvu). Ikhodi yophawu lwe-copyright − 169. Landela lezi zinyathelo ezingezansi ukuze ufake lo mlingisi kuseli.
Ifaka ikhiphedi yezinombolo
- Cindezela inkinobho Alt.
- Ekhiphedi yezinombolo, faka ikhodi enamadijithi angu-4 (uma kudingeka, engeza oziro abangekho): 0169.
- Dedela ukhiye Altukwenza uhlamvu luvele kuseli. Uma kunesidingo, cindezela Faka.
Okokufaka kwekhibhodi ngaphandle kwephedi yezinombolo
Kuma-laptops, kwenzeka ukuthi ukuze usebenzise ukusebenza kwekhiphedi yezinombolo, udinga ukucindezela futhi okhiye abakhethekile. Ngincoma ukuthi uhlole lokhu ngemanuwali yomsebenzisi ye-laptop yakho. Nansi indlela esebenza ngayo kulaptop yami yakwaDell:
- Cindezela inkinobho Fn futhi F4, ukuvula INumlock.
- Thola iphedi yezinombolo etholakala kokhiye bekhibhodi yama-alfabhethi. Kukhibhodi yami: D = 1, K=2 njalo njalo.
- Chofoza Alt+Fn futhi, usebenzisa ikhiphedi yezinombolo, faka ikhodi yezinhlamvu ezinezinhlamvu ezi-4 (wengeza oziro uma kudingeka): 0169.
- Yekela Alt+Fnukwenza uphawu lwelungelo lobunikazi luvele kuseli. Uma kunesidingo, cindezela Faka.
- Uma usuqedile, chofoza futhi Fn+F4ukukhubaza INumlock.