Ntchito za CHAR ndi CODE za Excel

01 a 02

Excel CHAR / UNICHAR Ntchito

Ikani Zizindikiro ndi Zizindikiro ndi CHAR ndi Ntchito UNICHAR. © Ted French

Chikhalidwe chilichonse chowonetsedwa mu Excel chilidi nambala.

Makompyuta amangogwira ntchito ndi manambala. Makalata a alfabeti ndi zina zapadera - monga ampersand "&" kapena hashtag "#" - amasungidwa ndi kuwonetsedwa mwa kupereka nambala yosiyana kwa aliyense.

Poyambirira, si makompyuta onse amagwiritsa ntchito njira yofanana ndiyi kapena tsamba lamakalata polemba osiyana.

Mwachitsanzo, Microsoft inakhazikitsa masamba omwe amatsatira kachilombo ka ANSI - ANSI ndi yochepa kwa American National Standards Institute - pamene makompyuta a Macintosh amagwiritsa ntchito chikhalidwe cha Macintosh .

Mavuto angayambike pamene akuyesera kusintha machitidwe a chikhalidwe kuchokera kumtundu wina kupita ku wina chifukwa cha kuwononga deta.

Chikhalidwe cha Anthu Onse

Kuti athetse vutoli chikhalidwe cha anthu onse chomwe chimadziwika kuti Unicode dongosolo chinapangidwa kumapeto kwa zaka za m'ma 1980 zomwe zimapereka malembo onse ogwiritsidwa ntchito mu makompyuta onse apadera.

Pali zizindikiro zotsatila makumi awiri ndi zisanu ndi ziwiri kapena ma code omwe ali mu Windows ANSI code tsamba pomwe dongosolo la Unicode likukonzedwa kuti likhale ndi mfundo imodzi ya code.

Pofuna kugwirizanitsa, zizindikiro zoyamba 255 za Unicode zatsopano zikufanana ndi za ANSI dongosolo la anthu omasulira chinenero cha kumadzulo.

Kwa mafanidwe awa, zizindikiro zimakonzedwa mu kompyutayi kuti kulemba kalata pa kibokosilo mulowetse chikhomo cha kalata mu pulojekiti yogwiritsidwa ntchito.

Zosagwirizana ndi zizindikiro ndi zizindikiro - monga chizindikiro cha chilolezo - © - kapena zilembo zovomerezeka zomwe zimagwiritsidwa ntchito m'zinenero zosiyanasiyana zingalowe mu pulogalamuyo polemba mu code ANSI kapena nambala ya Unicode kwa chikhalidwe chomwe mukufuna.

Excel CHAR ndi CODE Ntchito

Excel ili ndi ntchito zingapo zomwe zimagwira ntchito ndi manambala awa mwachindunji: CHAR ndi CODE kwa Mabaibulo onse a Excel, kuphatikizapo UNICHAR ndi UNICODE zomwe zinayambika mu Excel 2013.

Ntchito za CHAR ndi UNICHAR zimabweretsanso chikhalidwe cha code yomwe wapatsidwa pamene ntchito za CODE ndi UNICODE zimachita zosiyana -patseni code ya khalidwe lopatsidwa. Mwachitsanzo, monga momwe tawonetsera pa chithunzi pamwambapa,

Mofananamo, ngati ntchito ziwirizo zinali zogwirizana palimodzi

= CODE (CHAR (169))

chiwerengero cha chigamulocho chidzakhala 169, chifukwa ntchito ziwirizo zimagwira ntchito yosiyana ndi inayo.

Ntchito za CHAR / UNICHAR Ntchito Syntax ndi Arguments

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya CHAR ndi:

= CHAR (Nambala)

pamene mawu ogwirizana a ntchito ya UNICHAR ndi awa:

= UNICHAR (Nambala)

Chiwerengero - (chofunika) chiwerengero pakati pa 1 ndi 255 chosonyeza chomwe mukufuna.

Mfundo :

Nambala ya Nambala ingakhale nambala yomwe inalowa mwachindunji ku ntchito kapena selo lofotokozera malo komwe chiwerengero chili mu tsamba .

-Ngati kukangana kwa Namba sikulumikiza pakati pa 1 ndi 255, ntchito ya CHAR idzabweretsa #VALUE! Phindu la malingaliro monga momwe tawonedwera mzere 4 mu chithunzi pamwambapa

Kwa manambala a nambala oposa 255, gwiritsani ntchito ntchito ya UNICHAR.

-ngati nambala ya zero (0) yalowa, ntchito za CHAR ndi UNICHAR zidzabweretsa #VALUE! Phindu lachinyengo monga likuwonetsedwa mzere 2 mu chithunzi pamwambapa

Kulowa ntchito ya CHAR / UNICHAR

Zosankha zogwira ntchito iliyonse zimaphatikizapo kujambula ntchitoyo pamanja, monga:

= CHAR (65) kapena = UNICHAR (A7)

kapena kugwiritsira ntchito ' bokosi ' la bokosi kuti alowe ntchito ndi nambala ya Number .

Zotsatira izi zinagwiritsidwa ntchito kulowa ntchito ya CHAR mu selo B3 mu chithunzi pamwambapa:

  1. Dinani pa selo B3 kuti mupange selo yogwira ntchito - malo omwe zotsatira za ntchitoyi zikuwonetsedwa
  2. Dinani pa Fomu tab ya menyu yowonjezera
  3. Sankhani Mawu kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi
  4. Dinani pa CHAR mndandanda kuti mubweretse bokosi lazokambirana
  5. Mu bokosi la bokosi, dinani pa Nambala
  6. Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
  7. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
  8. Chizindikiro chachizindikiro - ! - ziyenera kuoneka mu selo B3 popeza code yake ya khalidwe la ANSI ndi 33
  9. Mukasindikiza pa selo E2 ntchito yonse = CHAR (A3) ikuwonekera pa bar barolomu pamwamba pa tsamba

CHAR / UNICHAR Ntchito Ntchito

Zogwiritsira ntchito za CHAR / UNICHAR zikutanthawuza kumasulira nambala za tsamba la code kukhazikitsa zilembo kwa mafayilo opangidwa pa ma kompyuta ena.

Mwachitsanzo, ntchito ya CHAR imagwiritsidwa ntchito kuchotsa zida zosafunika zomwe zimawoneka ndi deta yosatumizidwa. Ntchitoyi ikhoza kugwiritsidwa ntchito pamodzi ndi ntchito zina za Excel monga TRIM ndi SUBSTITUTE mwa maonekedwe omwe akuchotsedwera kuchotsa zilembo izi zosafunika kuchokera pa tsamba.

02 a 02

Chitsanzo CODE / UNICODE Ntchito

Pezani Mayina a Makhalidwe ndi Ntchito za CODE ndi UNICODE. © Ted French

CODE / UNICODE Ntchito ya Syntax ndi Arguments

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa.

Chidule cha ntchito ya CODE ndi:

= CODE (Malemba)

pamene mawu ogwirizana a ntchito ya UNICODE ndi:

= UNICODE (Malemba)

Malemba - (oyenera) khalidwe limene mukufuna kupeza nambala ya code ya ANSI.

Mfundo :

Mtsutsano wa Malemba ukhoza kukhala khalidwe limodzi lozunguliridwa ndi zilembo ziwiri ("" ") zomwe zimalowa mwachindunji kumalo ogwiritsira ntchito kapena selo lofotokozera za malo a khalidwelo mu tsamba lomwe likuwonetsedwa ngati mzere 4 ndi 9 pa chithunzi pamwambapa

Ngati kukangana kwalemba kumasiyidwa, ntchito ya CODE idzabwerenso #VALUE! Phindu lachinyengo monga likuwonetsedwa mzere 2 mu chithunzi pamwambapa.

CODE imangowonjezera chikhazikitso cha chikhalidwe cha chikhalidwe chimodzi. Ngati mkangano wamakalata uli ndi khalidwe loposa limodzi - monga mawu Excel owonetsedwa mzere 7 ndi 8 pa chithunzi pamwambapa - kokha kachidindo ka khalidwe loyamba likuwonetsedwa. Pankhaniyi ndi nambala 69 yomwe ndi chikhalidwe cha khalidwe la kalata yaikulu E.

Zolemba Zolemba Zolemba Zochepa

Makalata akuluakulu kapena akuluakulu pa khididiyi ali ndi zizindikiro zosiyana siyana kuposa zilembo zochepa kapena zochepa .

Mwachitsanzo, nambala ya code ya UNICODE / ANSI ya "A" yaikulu ndi 65 pamene nambala ya code ya UNICODE / ANSI ndi 97 monga momwe ikuwonetsera mzere 4 ndi 5 pa chithunzi pamwambapa.

Kulowa ntchito ya CODE / UNICODE

Zosankha zogwira ntchito iliyonse zimaphatikizapo kujambula ntchitoyo pamanja, monga:

= CODE (65) kapena = UNICODE (A6)

kapena kugwiritsira ntchito 'bokosi' la bokosi kuti alowe ntchito ndi ndemanga ya Malemba .

Zotsatira izi zidagwiritsidwa ntchito kulowa mu CODE ntchito mu selo B3 mu chithunzi pamwambapa:

  1. Dinani pa selo B3 kuti mupange selo yogwira ntchito - malo omwe zotsatira za ntchitoyi zikuwonetsedwa
  2. Dinani pa Fomu tab ya menyu yowonjezera
  3. Sankhani Mawu kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi
  4. Dinani pa CODE m'ndandanda kuti mubweretse bokosi lazokambirana
  5. Mu bokosi la bokosi, dinani palemba mzere
  6. Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
  7. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
  8. Nambala 64 iyenera kuoneka mu selo B3 - iyi ndi chikhalidwe cha khalidwe la ampersand khalidwe "&"
  9. Mukasindikiza pa selo B3 ntchito yonse = CODE (A3) ikuwoneka mu barra ya fomu pamwamba pa tsamba