30 Excel inoshanda mumazuva makumi matatu: CODE

Makorokoto! Wakasvika pakupera kwevhiki rekutanga remarathon 30 Excel inoshanda mumazuva makumi matatu, ndadzidza basa nezuro YAKAKONZESWA (YAKASINGWA). Nhasi tichazorora zvishoma uye totarisa basa risina akawanda ekushandisa kesi - basa CODE (CODE). Inogona kushanda pamwe chete nemamwe mabasa mune akareba uye akaoma mafomula, asi nhasi isu tichaisa pfungwa pane zvaanogona kuita ari ega mumatambudziko akareruka.

Saka, ngatitarisei ruzivo rwereferenzi pane basa CODE (CODE) uye funga nezvesarudzo dzekushandisa kwayo muExcel. Kana iwe uine matipi kana mienzaniso yekushandisa, ndapota ugovane iwo mumhinduro.

Basa 07: CODE

basa CODE (CODE) inodzosa kodhi nhamba yemavara ekutanga etambo yemavara. Kune Windows, iyi ichava kodhi kubva patafura ANSI, uye nokuda kweMacintosh - kodhi kubva patafura yechiratidzo Macintosh.

Ungashandisa sei iyo CODE basa?

basa CODE (CODESYMB) inokutendera kuti uwane mhinduro kumibvunzo inotevera:

  • Nderipi mavara akavanzika pamagumo ezvinyorwa zvaunzwa kunze kwenyika?
  • Ndingapinza sei munhu akakosha muchitokisi?

Syntax CODE

basa CODE (CODE) ine sintakisi inotevera:

CODE(text)

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

  • chinyorwa (chinyorwa) tambo yemavara ine yekutanga kodhi kodhi yaunoda kuwana.

Miteyo CODE (CODE)

Mibairo yakadzoserwa nebasa inogona kusiyana pane akasiyana masisitimu anoshanda. Iwo ASCII makodhi makodhi (32 kusvika 126) anonyanya kuenderana nemavara ari pakhibhodi yako. Nekudaro, mavara enhamba dzepamusoro (kubva pa129 kusvika 254) anogona kusiyana.

Muenzaniso 1: Wana kodhi yakavanzika yehunhu

Mameseji akakopwa kubva pawebhusaiti dzimwe nguva ane mavara akavanzwa. Function CODE (CODE) inogona kushandiswa kuona kuti mavara aya ndeapi. Semuenzaniso, sero B3 rine tambo yemavara ine izwi rekuti "bvunzo' ine mavara mana pamwe chete. Musero C4, basa LEN (DLSTR) yakaverengera kuti kune mavara matatu muchitokisi B3.

Kuti uone kodhi yemhando yekupedzisira, unogona kushandisa basa RUDYI (KURUDHI) kuburitsa chimiro chekupedzisira chetambo. Zvadaro shandisa basa racho CODE (CODE) kuti uwane kodhi yemunhu iyeye.

=CODE(RIGHT(B3,1))

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

30 Excel inoshanda mumazuva makumi matatu: CODE

Musero D3, unogona kuona kuti hunhu hwekupedzisira hwetambo ine kodhi 160, iyo inopindirana nenzvimbo isina kuputsa iyo inoshandiswa pawebsite.

Muenzaniso 2: Kutsvaga kodhi yehunhu

Kuisa mavara akakosha muExcel spreadsheet, unogona kushandisa rairo chiratidzo (Zviratidzo) tab Kuisa (Insert). Semuenzaniso, unogona kuisa chiratidzo chedhigirii ° kana chiratidzo chekodzero ©.

Kana chiratidzo chaiswa, kodhi yayo inogona kutsanangurwa uchishandisa basa CODE (KODSIMV):

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

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

30 Excel inoshanda mumazuva makumi matatu: CODE

Iye zvino zvawaziva kodhi, unogona kuisa mavara uchishandisa nhamba yekiyi (kwete nhamba dziri pamusoro pearufabheti keypad). Kodhi yechiratidzo chekodzero − 169. Tevedzera matanho ari pasi apa kuti uise hunhu uhu musero.

Kupinda pamakiyipadhi enhamba

  1. Dhinda kiyi alt.
  2. Pakiyipedhi yenhamba, isa kodhi ine manhamba (kana zvichidikanwa, wedzera mazero asipo): 0169.
  3. Sunungura kiyi altkuita kuti hunhu huoneke muchitokisi. Kana zvichidiwa, dzvanya pinda.

Kiyibhodhi inopinza isina padhi yenhamba

Mumalaptops, zvinoitika kuti kuti ushandise mashandiro eiyo nhamba keypad, unofanirwa kuwedzera makiyi akakosha. Ini ndinokurudzira kutarisa izvi nebhuku remushandisi relaptop yako. Heano maitiro azvinoita paDell laptop yangu:

  1. Dzvanya kiyi Fn uye F4, kubatidza Numlock.
  2. Tsvaga padhi yenhamba iri pamakiyi ekhibhodi yearufabheti. Pa keyboard yangu: D=1, K=2 zvichingoenda zvakadaro.
  3. Click Alt+Fn uye, uchishandisa keypad yenhamba, isa iyo 4-manhamba kodhi kodhi (kuwedzera zero kana zvichidikanwa): 0169.
  4. Rega kuenda Alt+Fnkuita kuti chiratidzo chekodzero chioneke muchitokisi. Kana zvichidiwa, dzvanya pinda.
  5. Kana wapedza, tinya zvakare Fn+F4kuremadza Numlock.

Leave a Reply