Nhengo imwe neimwe pamakombiyuta - inonyorwa uye isina kudhindwa - ine nhamba inozivikanwa seyo Unicode character code kana kukosha.
Imwe, yakwegura, uye iri nani inonyatsozivikaniswa hutano ndiyo ASCII , iyo inomirira American Standard Code yeKushandurana kweNhau , yakabatanidzwa muUnicode set. Somugumisiro, mazita 128 ekutanga (0 kusvika 127) eUnicode yakagadzirwa akafanana neAscII yakagadzirirwa.
Yakawanda yekutanga 128 Unicode characters inoshandiswa sekutonga mashizha uye inoshandiswa nekombiyuta mapurogiramu ekudzivirira zvigadziri zvese zvakadai semapinduri.
Sezvo zvakadaro, havakwanisi kushandiswa mu Excel mapepa uye zvinogona kukonzera kukanganisa kwakasiyana kana kuripo. Basa reCLEAN rakanaka rinobvisa zvizhinji zvevasina kudhindwa - kunze kwehuwandu # 127.
01 of 03
Unicode Character # 127
Unicode character # 127 inodzora chinovhara pakibhodi. Sezvo zvakadaro, hazvifanirwi kuti zvivepo mune imwe Excel worksheet.
Kana iripo, inoratidzirwa semakumbo mashomanana-akafanana nemunhu - sezvinoratidzwa muchikamu cheA2 mumufananidzo wepamusoro - uye zvichida yakatorwa kana kunyoreswa pangozi pamwe chete nemamwe mashoko akanaka.
Kuvapo kwaro kungave:
- kukonzera matambudziko ekuumba mafungiro mune pepa rekushanda;
- inobata kugadzirisa uye kuchenesa kwedata;
- bvisai kuverenga matambudziko kana iri muchitokisi pamwe chete nedhidhiyo iri kushandiswa mumushonga .
02 of 03
Kubvisa Unicode Character # 127
Kunyange zvazvo munhu uyu asingakwanisi kubviswa nebasa rakanaka, rinogona kubviswa uchishandisa fomu ine SUBSTITUTE uye CHAR inoshanda.
Muenzaniso uri mumufananidzo uri pamusoro unoratidzira maitiro mana akafanana akafanana nemutsara pamwe nenhamba 10 muchitsetse A2 yeExpcel worksheet.
Basa reLEN - rinoverenga nhamba yevanhu vari muchitokisi - muchitokisi E2 inoratidza kuti cell A2 ine mifananidzo mitanhatu - iyo mairi maviri ehamba nhamba gumi pamwe nemabhokisi mana evanhu # 127.
Pamusana pekuvapo kwehutano # 127 muchitokisi A2, fomu yekuwedzera mumusero D2 inodzorera #VALUE! error message.
Cell A3 ine chinyorwa che SUBSTITUTE / CHAR
= SUBSTITUTE (A2, CHAR (127), "")kuti atsive mavara mana e # 127 kubva pachitsauko A2 pasina chinhu - (inoratidzwa nemabhuku asina zvaakagadzirirwa pamagumo emutsetse).
Semagumo
- chimiro chinowanikwa muchitsetse E3 chakapfupika kusvika zviviri - nokuda kwemajeri maviri ari nhamba yegumi;
- iyo inowedzera yekuwedzera mumusero D3 inodzorera mhinduro yakarurama ye15 paunowedzera zviri mukati yesero A3 + B3 (10 + 5).
Icho chinonzi SUBSTITUTE basa chinonyanya kushandiswa apo basa reCAR rinoshandiswa kutaurira fomu kuti chimiro chinotora chii.
03 of 03
Kubvisa Zvisiri-Kuputsa Mazhenje kubva Pashanduri
Zvakafanana nezvisiri izvo zvinyorwa zvinonyanya kushandiswa iyo isiri-break space (& nbsp) iyo inogonawo kukonzera matambudziko nekuverenga uye kuumba mumashandiro. Nhamba yekodhi yeNunicode yenzvimbo dzisina kuputsa ndeye # 160.
Nzvimbo dzisiri-kuputsa dzinoshandiswa zvakanyanya pamapeji ewebhu, saka kana data ikakopihwa kuExcel kubva peji yewebhu, nzvimbo dzisiri dzisina kupararira dzinogona kuratidzwa mune pepa.
Kubvisa nzvimbo dzisiri-kuputsa zvinogona kuitwa nemuumbi unosanganisira SUBSTITUTE, CHAR, uye TRIM mabasa.