Susa i-ASCII Impawu # 127 kwi-Excel

Umlingisi ngamnye kwi-khompyutheni ephrintiweyo kwaye engaprintwa - inombhalo eyaziwa njengekhowudi yayo ye- Unicode okanye ixabiso.

Omnye, omdala, kunye nolwazi olubhekiselele kumgca we- ASCII , omelela i- American Standard Code ye-Interchange Information , ifakwe kwisinqununu se-Unicode. Ngenxa yoko, iibalo zokuqala ezingu-128 (0 ukuya ku-127) zesethi ye-Unicode zifana nokusekwa kwe-ASCII.

Uninzi lwezinhlamvu zokuqala ezingu-128 ze-Unicode zibhekiswa njengabalinganiswa bokulawula kwaye zisetyenziswe ngeekhompyutheni zokulawula izixhobo zepheripherina ezifana nabaphrinta.

Ngaloo ndlela, azenzelwe ukusetyenziswa kwiifom zephepha ze- Excel kwaye zingabangela iiphene ezahlukeneyo ukuba zikhona. Umsebenzi ococekileyo we-Excel uya kususa abaninzi balabalingiswa abangabhaliswanga - ngaphandle kweyompawu # 127.

01 ka 03

Unicode Character # 127

Umlingisi we-Unicode # 127 ulawula ukhiye wokucima kwikhibhodi. Ngaloo ndlela, akuhlose ukuba kubekho kwiphepha lokusebenzela lase Excel.

Ukuba kukho, iboniswa njengomgca onobumba obunobumba - njengokuba kuboniswe kwiseli ye-A2 kumfanekiso ongentla-kwaye mhlawumbi ungeniswe okanye ukopishwe ngengozi kunye nedatha efanelekileyo.

Ubuso bayo:

• kubangela iingxaki zokufometha ezilula kwiphepha lokusebenzela;
• cha phazela ukuhlunga nokuhlunga kwedata;
• kubangela iingxaki zokubala ukuba zikhona kwiseli kunye nedatha esetyenziswa kwifom .

02 ka 03

Ukususa Uphawu lwe-Unicode # 127

Nangona lo mlingiswa ungeke ususwe nge-CLEAN function, ungasuswa usebenzisa ifom equkethe imisebenzi ye- SUBSTITUTE ne- CHAR .

Umzekelo kumfanekiso ongasentla ubonisa uhlamvu lwesine oluxubileyo kunye nombolo 10 kwiseli A2 kwiphepha lokusebenzela lase Excel.

Umsebenzi we-LEN - obala inani labalinganiswa kwiseli - kwiseli ye-E2 ibonisa ukuba iseli A2 iqulethe abalinganiswa abathandathu - iidijithi ezimbini zeenombolo 10 kunye neebhokisi ezine ze-# 127.

Ngenxa yobukho bamagama # 127 kwiseli ye-A2, ifomula yokufakela kwiseli D2 ubuyisela i-#VALUE! umyalezo wephutha.

Iseli A3 liqukethe ifom SUBSTITUTE / CHAR

= SUBSTITUTE (A2, CHAR (127), "")

ukutshintsha iingubo ezi-# 127 ukusuka kwiseli ye-A2 engenanto-(iboniswe ngamanqaku angenanto angaphaya ekupheleni kwefomula).

Nje ngeziphumo

1. Ukubala komlingiswa kwisisele se-E3 kuncitshiswe kuba mabini - kwiidijithi ezimbini kwinani le-10;
2. Ifomula yokufakela kwiseli D3 ubuyisela impendulo echanekileyo ye-15 xa ufaka isiqulatho se-A3 + B3 (10 + 5).

Umsebenzi we-SUBSTITUTE uyenzela ukutshintsha ngexesha umsebenzi we-CHAR usetyenziselwa ukuxelela umhlathi ukuba yiyiphi indimi ekumele ithathe indawo.

03 ka 03

Ukususwa kweZithuba ezingenzi ukuPhula kwiShishini lokuSebenza

Ngokufanayo kunye nabalingani abangaprintwa yindawo yokungafihli (& nbsp) enokubangela iingxaki ngokubala nokufometha kwiphepha lokusebenzela. Inombolo yekhowudi ye-Unicode yeendawo ezingaphuliyo yi-# 160.

Izikhala ezingabhiyozeli zisetyenziselwa kakhulu kumaphepha ewebhu, ngoko ukuba iikopi ikopiwe kwi-Excel ukusuka kwiphepha lewebhu, izikhala ezingabikho zingabonakalisa kwiphepha lokusebenzela.

Ukususwa kweendawo ezingenziwanga kungenziwa ngefomu edibanisa i-SUBSTITUTE, CHAR, kunye ne-TRIM.