Basa reCAR neCODE

01 ye 02

Excel CHAR / UNICHAR Basa

Nhengo imwe neimwe inoratidzwa muExcel iri chaizvoizvo nhamba.

Makombiyuta anoshanda chete nenhamba. Tsamba dzealfabheti nedzimwe vanhu vakadzama - zvakadai se ampersand "&" kana hashtag "#" - dzinochengetedzwa uye dzinoratidzwa nekupa imwe nhamba imwe neimwe.

Pakutanga, kwete makombiyuta ose anoshandisa purogiramu yakaenzana yepurogiramu kana peji peji kana uchiverenga vanhu vakasiyana.

Semuenzaniso, Microsoft yakagadzira mapeji emitemo yakabva kune ANSI code code - ANSI inopfupika kuAmerican National Standards Institute - apo makombiyuta eMacintosh akashandisa Macintosh character set .

Zvinetso zvinogona kubuda paanenge achiedza kuchinja unhu hutsika kubva kune imwe sangano kuenda kune imwe zvichiita kuti uwedzere deta.

Universal Character Set

Kugadzirisa dambudziko iri munharaunda yepasi rose inozivikanwa seUnicode system yakagadzirwa mukati mekupedzisira kwema1980 inopa vanhu vose vanoshandiswa mumakombiyuta ose ega ega code code.

Pane makumi mapfumbamwe nemakumi mashanu akasiyana-siyana maikorodhe kana maikorodhe mukati meWindows ANSI code peji apo Unicode system yakagadzirirwa kuchengetedza mamiriyoni emitemo ye mamiriyoni.

Nokuda kwekuenzanirana, yekutanga 255 nhamba dzekodhi dzeNewicode system itsva dzinofananidza izvo zveAnSI system yemashoko emitauro yekumadokero nenhamba.

Nokuda kwezvinyorwa izvi, nhamba idzi dzinongororwa mumakombiyuta kuitira kuti kuisa tsamba pabhobhoyo inopinda mutsamba ye tsamba iyo kupinda purogiramu iri kushandiswa.

Zvisingaenzaniswi zvinyorwa uye zviratidzo - zvakadai sechiratidzo chekodzero - © - kana vanhu vakagadziriswa vanoshandiswa mumitauro yakasiyana-siyana vanogona kupinda purogiramu nekunyora mumutsara weAnsi kana kuti Unicode nhamba yehutano munzvimbo yaunoda.

Excel CHAR neCODE Mabasa

Excel ine mabasa akawanda anoshanda nendima idzi zvakananga: CHAR neCODE yevashanduri vose veExcel, pamwe neUNICHAR neUNICODE yakaiswa muExpcel 2013.

Icho CHAR neUNICHAR zvinoshandura kudzorera unhu hwekodhi rakapiwa apo CODE neUNICODE zvinoshanda zvinopesana - kupai code yehupi hunopiwa. Somuenzaniso, sezvinoratidzwa mumufananidzo uri pamusoro,

• chibereko che = CHAR (169) chikwangwani chekodzero ©;
• asi chiitiko che = CODE (©) chiri 169.

Saizvozvowo, kana mabasa maviri aya akabatanidzwa pamwe chete nenzira ye

= CODE (CHAR (169))

iyo yakagadziriswa iyo yakasarudzwa yaizova 169, sezvo mabasa maviri anoita basa rakasiyana nedzimwe.

Basa reCAR / UNICHAR Mabasa Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weCAR basa ndewokuti:

= CHAR (Nhamba)

nepo chirevo chebasa reUNICHAR ndechekuti:

= UNICHAR (Nhamba)

Nhamba - (inoda) nhamba pakati pe1 ne525 inoratidza kuti unoda ani.

Notes :

Nhauriro yeNhamba inogona kuva nhamba inopindira zvakananga mubasa kana sechitinho chekuyera kune nzvimbo yenhamba muhwhepa .

-Kana Nhaurirano yeNhamba isati iri nhamba pakati pe1 ne525, basa reCAR richadzoka #VALUE! kukanganisa kunoratidzika sezvinoratidzwa mumutsara wechina mumufananidzo uri pamusoro

Nekodhi nhamba huru kune 255, shandisa basa reUNICHAR.

-ku Nhamba ye nhamba ye zero (0) yakapinda, mabasa eCAR neUNICHAR achadzoka #VALUE! kukanganisa kunoratidzika sezvakaratidzwa mumutsara 2 mumufananidzo wepamusoro

Kupinda Basa reCAR / UNICHAR

Zvasarudzo zvekupinda chero basa zvinosanganisira kuisa basa mukati memunhu, zvakadai se:

= CHAR (65) kana = UNICHAR (A7)

kana kushandisa maitiro ' dialog box kuti uise basa uye nhamba yeNhamba .

Aya matanho anotevera akashandiswa kupinda muCAR basa mumusero B3 mumufananidzo uri pamusoro apa:

1. Dzvanya pane sero B3 kuti riite sero rinoshanda - nzvimbo iyo migumisiro yebasa iri kuratidzwa
2. Dzvanya paMafomu yebhu yebhoni yebhoni
3. Sarudza Rugwaro kubva kubhoni kuti uzarure basa rinoderera pasi
4. Dzvanya pa CHAR mumutsara kuti uburise bhokisi rebasa rebasa
5. Mubhokisi rebhokisi, tora paNhamba yemurongo
6. Dzvanya pane sero A3 mune pepa rekushanda kuti uise iyo seferensi mubhokisi rebhokisi
7. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
8. Iko kushevedzera mark character - ! - inofanira kuonekwa muchitokisi B3 kubvira apo ANSI yerudzi rwekodhi ndeye 33
9. Paunenge uchinge uri pa cell E2 zvakakwana basa = CHAR (A3) inowanikwa mubhadha yepamusoro pane pepa rekushanda

CHAR / UNICHAR Mabasa Kushandisa

Zvishandiswa zveCAR / UNICHAR zvinenge zviri kushandura nhamba dzemapurogiramu emukodhi kuva zvinyorwa zvefaira zvakasikwa kune mamwe marudzi emakombiyuta.

Semuenzaniso, basa reCAR rinowanzoshandiswa kubvisa tsanga dzisina kudiwa dzinowanikwa nedhipatimendi inotumirwa. Basa racho rinogona kushandiswa pamwe chete nedzimwe mabasa eExcel akadai se TRIM uye SUBSTITUTE mumazamu akagadzirirwa kubvisa tsamba idzi dzisina kudiwa kubva pahwhepa.

02 of 02

Excel CODE / UNICODE Basa

ICODE / UNICODE Kushanda Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.

Mutsara weCODE basa nderekuti:

= CODE (Nyaya)

nepo chirevo chebasa reUNICODE ndechekuti:

= UNICODE (Rugwaro)

Nyaya - (inoda) chimiro chaunoda kuwana nhamba ye code ANSI.

Notes :

Izwi rinopesana rinogona kuva chimiro chimwechete chakakomberedzwa nekodhi yemashoko ekutsanangura ("") yakapinda zvakananga mubasa kana sero rinoreva nzvimbo yehutano mune pepa rekuita sezvinoratidzwa mumitsara 4 ne9 mumufananidzo uri pamusoro

Kana nhaurirano yemashoko yakasara isina chinhu CODE basa ichadzorera #VALUE! kukanganisa kunoratidzika sezvakaratidzwa mumutsara 2 mumufananidzo wepamusoro.

ICODE inoshanda chete inoratidza chimiro chemhando yeunhu mumwe chete. Kana iyo nhaurirano yemashoko ine zvinyorwa zvinopfuura imwechete - zvakadai sezwi Excel rinoratidzwa mumitsara 7 ne8 mumufananidzo wepamusoro - chete kemo yehutano hwekutanga inoratidzwa. Muchiitiko ichi iyi nhamba 69 iyo ndiyo mhando yekodhi yemutsamba wechizhinji E.

Mutsara vs. Tsamba dzezasi dzeChechi

Makukutu kana mazita makuru pamusoro pebhobhoyo ane maitiro akasiyana ehutano kupfuura echezasi kana mazita mashoma .

Somuenzaniso, UNICODE / ANSI nhamba yekodhi ye "A" yakawanda 65 asi apo nhamba yepasi ye "UN" yeUNICODE / ANSI nhamba 97 sezvinoratidzwa mumitsara 4 ne5 mumufananidzo uri pamusoro.

Kupinda CODE / UNICODE Basa

Zvasarudzo zvekupinda chero basa zvinosanganisira kuisa basa mukati memunhu, zvakadai se:

= CODE (65) kana = UNICODE (A6)

kana kushandisa maitiro 'dialog box kuti uise basa uye Text argument.

Aya matanho anotevera akashandiswa kupinda muCODE basa mumusero B3 mumufananidzo uri pamusoro apa:

1. Dzvanya pane sero B3 kuti riite sero rinoshanda - nzvimbo iyo migumisiro yebasa iri kuratidzwa
2. Dzvanya paMafomu yebhu yebhoni yebhoni
3. Sarudza Rugwaro kubva kubhoni kuti uzarure basa rinoderera pasi
4. Dzvanyira paCODE mune urongwa kuti ubudise bhokisi rebasa rebasa
5. Mubhokisi rebhokisi, chengeta paMagwaro
6. Dzvanya pane sero A3 mune pepa rekushanda kuti uise iyo seferensi mubhokisi rebhokisi
7. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
8. Nhamba 64 inofanira kuonekwa muchitokisi B3 - iyi ndiyo mhando yekodzero yemafersand ""
9. Paunenge uchinyora pa cell B3 basa rakakwana = CODE (A3) inowanikwa mubhairi yepamusoro pane pepa pepaji