30 Excel imagwira ntchito m'masiku 30: CODE

Zabwino zonse! Munafika kumapeto kwa sabata yoyamba ya mpikisano wa marathoni 30 Excel imagwira ntchito m'masiku 30, ataphunzira ntchito dzulo ZOPHUNZITSIRA (ZOCHITIKA). Lero tipumula pang'ono ndikuyang'ana ntchito yomwe ilibe zochitika zambiri zogwiritsira ntchito - ntchitoyo CODE (KODI). Ikhoza kugwira ntchito pamodzi ndi ntchito zina muzolemba zazitali komanso zovuta, koma lero tidzayang'ana zomwe zingakhoze kuchita paokha muzochitika zosavuta.

Chifukwa chake, tiyeni tithane ndi zidziwitso zantchitoyo CODE (CODE) ndikuwona zosankha zomwe mungagwiritse ntchito mu Excel. Ngati muli ndi malangizo kapena zitsanzo zogwiritsa ntchito, chonde gawanani nawo mu ndemanga.

Ntchito 07: KODI

ntchito CODE (CODE) imabweretsanso nambala yachilembo choyamba chachingwe. Kwa Windows, iyi idzakhala code kuchokera patebulo ANSI, ndi Macintosh - code kuchokera pa tebulo lachizindikiro Macintosh.

Kodi mungagwiritse ntchito bwanji CODE ntchito?

ntchito CODE (CODESYMB) imakulolani kuti mupeze mayankho a mafunso otsatirawa:

  • Kodi zilembo zobisika zomwe zili kumapeto kwa mawu obwera kuchokera kunja ndi chiyani?
  • Kodi ndingalowe bwanji munthu wapadera muselo?

Syntax KODI

ntchito CODE (CODE) ili ndi mawu awa:

CODE(text)

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

  • lemba (mawu) ndi zingwe zolembera zomwe mukufuna kupeza nambala yake yoyamba.

Misampha CODE (CODE)

Zotsatira zomwe zabwezedwa ndi ntchitoyi zitha kusiyanasiyana pamakina osiyanasiyana. Zizindikiro za ASCII (32 mpaka 126) nthawi zambiri zimagwirizana ndi zilembo pa kiyibodi yanu. Komabe, zilembo za manambala apamwamba (kuyambira 129 mpaka 254) zitha kusiyana.

Chitsanzo 1: Pezani zilembo zobisika

Zolemba zomwe zimakopera patsamba nthawi zina zimakhala ndi zilembo zobisika. Ntchito CODE (CODE) angagwiritsidwe ntchito kudziwa kuti zilembozi ndi zotani. Mwachitsanzo, cell B3 ili ndi zingwe zomwe zili ndi mawu akuti "mayeso' ili ndi zilembo 4 zonse. Mu cell C3, ntchito LEN (DLSTR) adawerengera kuti pali zilembo zitatu mu cell B3.

Kuti mudziwe code ya khalidwe lomaliza, mungagwiritse ntchito ntchitoyi ZABWINO (KULADZO) kuti mutulutse chomaliza cha chingwecho. Kenako gwiritsani ntchito CODE (CODE) kuti mupeze nambala yamunthuyo.

=CODE(RIGHT(B3,1))

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

30 Excel imagwira ntchito m'masiku 30: CODE

Mu cell D3, mutha kuwona kuti mawonekedwe omaliza a chingwe ali ndi code 160, zomwe zimagwirizana ndi malo osasweka omwe amagwiritsidwa ntchito pa mawebusaiti.

Chitsanzo 2: Kupeza zilembo

Kuti muyike zilembo zapadera mu Excel spreadsheet, mutha kugwiritsa ntchito lamulo chizindikiro (Zizindikiro) tabu Kuika (Ikani). Mwachitsanzo, mutha kuyika chizindikiro cha digiri ° kapena chizindikiro cha kukopera ©.

Chizindikiro chikayikidwa, code yake imatha kuzindikirika pogwiritsa ntchito ntchitoyi CODE (KODIMV):

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

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

30 Excel imagwira ntchito m'masiku 30: CODE

Tsopano popeza mukudziwa kachidindo, mutha kuyika zilembo pogwiritsa ntchito mabatani a manambala (osati manambala omwe ali pamwamba pa zilembo za zilembo). Chizindikiro chaumwini - 169. Tsatirani zotsatirazi kuti mulowetse munthuyu mu selo.

Kulowa pa kiyibodi manambala

  1. Dinani fungulo alt.
  2. Pa kiyibodi ya manambala, lowetsani nambala ya manambala 4 (ngati kuli kofunikira, onjezani ziro zomwe zikusowa): 0169.
  3. Tulutsani kiyi altkupanga mawonekedwe mu cell. Ngati ndi kotheka, dinani Lowani.

Kulowetsa kiyibodi popanda nambala

Mu laputopu, zimachitika kuti kugwiritsa ntchito makiyi a manambala, muyenera kuwonjezera makiyi apadera. Ndikupangira kuyang'ana izi ndi buku la ogwiritsa la laputopu yanu. Umu ndi momwe zimagwirira ntchito pa laputopu yanga ya Dell:

  1. Dinani batani Fn ndi F4, kuyatsa Numlock.
  2. Pezani nambala ya nambala yomwe ili pamakiyi a zilembo za zilembo. Pa kiyibodi yanga: D = 1, K=2 ndi zina zotero.
  3. Dinani Alt+Fn ndipo, pogwiritsa ntchito kiyibodi ya manambala, lowetsani manambala anayi (kuwonjezera ziro ngati kuli kofunikira): 0169.
  4. Zilekeni Alt+Fnkupanga chizindikiro cha kukopera kuwonekera mu cell. Ngati ndi kotheka, dinani Lowani.
  5. Mukamaliza, dinani kachiwiri fn+f4kuletsa Numlock.

Siyani Mumakonda