Ayyukan Excel 30 a cikin kwanaki 30: CODE

Taya murna! Kun yi shi zuwa ƙarshen makon farko na tseren marathon 30 Excel yana aiki a cikin kwanaki 30, Bayan nazarin aikin jiya Kafaffen (GYARA). A yau za mu ɗan ɗan huta kuma mu dubi aikin da ba shi da yawancin lokuta masu amfani - aikin CODE (CODE). Zai iya yin aiki tare da wasu ayyuka a cikin tsari mai tsawo da rikitarwa, amma a yau za mu mayar da hankali kan abin da zai iya yi da kansa a cikin mafi sauki lokuta.

Don haka, bari mu yi ma'amala da bayanin tunani akan aikin CODE (CODE) kuma la'akari da zaɓuɓɓukan amfani da shi a cikin Excel. Idan kuna da tukwici ko misalan amfani, da fatan za a raba su a cikin sharhi.

Aiki 07: CODE

aiki CODE (CODE) yana dawo da lambar lamba na harafin farko na zaren rubutu. Don Windows, wannan zai zama lambar daga tebur ANSI, kuma don Macintosh - lambar daga teburin alamar Macintosh.

Ta yaya za ku yi amfani da aikin CODE?

aiki CODE (CODESYMB) yana ba ku damar samun amsar waɗannan tambayoyin:

• Menene ɓoyayyen hali a ƙarshen rubutun da aka shigo da shi?
• Ta yaya zan iya shigar da hali na musamman a cikin tantanin halitta?

CODE syntax

aiki CODE (CODE) yana da ma'ana mai zuwa:

CODE(text)

КОДСИМВ(текст)

• rubutu (rubutu) sigar rubutu ce wacce lambar haruffa ta farko kake son samu.

CODE (CODE)

Sakamakon da aikin ya dawo zai iya bambanta akan tsarin aiki daban-daban. Lambobin haruffa ASCII (32 zuwa 126) galibi sun dace da haruffan da ke kan madannai naka. Koyaya, haruffa don manyan lambobi (daga 129 zuwa 254) na iya bambanta.

Misali 1: Samo boyayyar lambar haruffa

Rubutun da aka kwafi daga gidan yanar gizo wani lokaci yana ƙunshe da ɓoyayyun haruffa. Aiki CODE Ana iya amfani da (CODE) don tantance menene waɗannan haruffa. Misali, cell B3 yana ƙunshe da igiyoyin rubutu wanda ya ƙunshi kalmar "gwajin' haruffa 4 ne gabaɗaya. A cikin cell C3, aikin LEN (DLSTR) an ƙididdige cewa akwai haruffa 3 a cikin tantanin halitta B5.

Don ƙayyade lambar harafin ƙarshe, zaku iya amfani da aikin RIGHT (DAMA) don cire harafin ƙarshe na kirtani. Sannan yi amfani da aikin CODE (CODE) don samun lambar wannan harafin.

=CODE(RIGHT(B3,1))

=КОДСИМВ(ПРАВСИМВ(B3;1))

A cikin cell D3, zaku iya ganin cewa harafin ƙarshe na kirtani yana da lambar 160, wanda yayi daidai da sararin da ba ya karyewa wanda ake amfani da shi akan gidajen yanar gizo.

Misali 2: Neman lambar haruffa

Don saka haruffa na musamman a cikin maƙunsar rubutu na Excel, zaku iya amfani da umarnin alama (Alamomin) tab sa (Saka). Misali, zaku iya saka alamar digiri ° ko alamar haƙƙin mallaka ©.

Da zarar an saka alama, ana iya tantance lambar ta ta amfani da aikin CODE (KODSIMV):

=IF(C3="","",CODE(RIGHT(C3,1)))

=ЕСЛИ(C3="";"";КОДСИМВ(ПРАВСИМВ(C3;1)))

Yanzu da ka san lambar, za ka iya saka haruffa ta amfani da faifan maɓalli na lamba (ba lambobi sama da faifan haruffa ba). Lambar alamar haƙƙin mallaka - 169. Bi matakan da ke ƙasa don shigar da wannan halin cikin tantanin halitta.

Shigar da faifan maɓalli na lamba

1. Latsa madannin alt.
2. A kan faifan maɓalli, shigar da lambar lambobi 4 (idan ya cancanta, ƙara sifilai da suka ɓace): 0169.
3. Saki maɓallin altdon sanya hali ya bayyana a cikin tantanin halitta. Idan ya cancanta, danna Shigar.

Shigar da allon madannai ba tare da kushin lamba ba

A cikin kwamfyutocin kwamfyutoci, yana faruwa cewa don amfani da aikin faifan maɓalli na lamba, kuna buƙatar kuma danna maɓallai na musamman. Ina ba da shawarar duba wannan tare da littafin mai amfani don kwamfutar tafi-da-gidanka. Ga yadda yake aiki akan kwamfutar tafi-da-gidanka na Dell:

1. Danna maɓalli Fn da F4, kunnawa Lambar lamba.
2. Nemo kushin lamba dake kan maɓallan madannai na haruffa. A madannai na: D = 1, K=2 da sauransu.
3. Click Alt+Fn kuma, ta amfani da faifan maɓalli na lamba, shigar da lambar haruffa 4 (ƙara sifilai idan ya cancanta): 0169.
4. Bari tafi Alt+Fndon sanya alamar haƙƙin mallaka ta bayyana a cikin tantanin halitta. Idan ya cancanta, danna Shigar.
5. Idan an gama, sake danna Fn+F4a kashe Lambar lamba.