Umlingiswa ngamunye kwi-computer - ephrintiwe futhi engaphenduliwe - inombhalo eyaziwa njengekhodi yayo yezinhlamvu ze-Unicode noma inani.
Omunye, osemdala, futhi owaziwa kakhulu uhlamvu lwe- ASCII , olumelela i- American Standard Code for Interchange Information , lifakwe kwisethi ye-Unicode. Ngenxa yalokho, izinhlamvu ezingu-128 zokuqala (0 kuya ku-127) zeqoqo le-Unicode lifana nesethi ye-ASCII.
Eziningi zezinhlamvu ezingu-128 zokuqala ze-Unicode zibhekwa njengezinhlamvu zokulawula futhi zisetshenziselwa izinhlelo zekhompyutha ukulawula amadivaysi okusebenza njengamaphrinta.
Njengalokhu, akuhloswe ukuthi kusetshenziswe kuma- worksheets e-Excel futhi kungabangela amaphutha ahlukahlukene uma ekhona. Umsebenzi we-Excel ohlanzekile uzosusa iningi lalabo abalingiswa abangabhaliwe - ngaphandle kohlamvu # 127.
01 ka-03
Isici se-Unicode # 127
Umlingisi we-Unicode # 127 ulawula ukhiye wokususa ekhibhodi. Ngakho-ke, akuhloswe ukuba kube khona kwi-Excel sheet sheet.
Uma ikhona, iboniswa njengobunjwa obubomvu obunobhokisi - njengoba kuboniswa esitokisini A2 esithombeni ngenhla - futhi kungenzeka ukuthi ingeniswe noma ikopiwe ngengozi kanye nedatha ethile enhle.
Ubukhona bayo:
- ubangele izinkinga zokufometha ezilula kumshini wokusebenzela;
- kuthinta ukuhlunga nokuhlunga kwedatha;
- bangela izinkinga zokubala uma zikhona esitokisini kanye nedatha esetshenziselwa ifomula .
02 ka-03
Ukususa Isici se-Unicode # 127
Ngisho noma lo mlingisi akakwazi ukususwa nge-CLEAN umsebenzi, ungasuswa usebenzisa ifomula equkethe imisebenzi ye- SUBSTITUTE ne- CHAR .
Isibonelo esithombeni esingenhla sibonisa uhlamvu oluthile lwesigxathu kanye nombolo 10 ku-cell A2 yephepha lokusebenzela le-Excel.
Umsebenzi we-LEN - obala inani labalingiswa esitokisini - esitokisini E2 sibonisa ukuthi iseli A2 liqukethe izinhlamvu eziyisithupha - amadijithi amabili wenombolo 10 kanye namabhokisi amane omlingiswa # 127.
Ngenxa yobunjalo bezinhlamvu # 127 ku-cell A2, ifomula lokufaka ekomelweni D2 libuyisela i- #VALUE! umlayezo wephutha.
I-Cell A3 iqukethe ifomu le-SUBSTITUTE / CHAR
= SUBSTITUTE (A2, CHAR (127), "")ukufaka esikhundleni izinhlamvu ezine ezingu- # 127 kusuka kwiseli A2 engenalutho - (kuboniswe ngamamaki okucaphuna angenalutho ekupheleni kwefomula).
Ngenxa yalokho
- isibalo sobuningi esitokisini E3 sincishisiwe sibe ngamabili - amadijithi amabili enombolweni engu-10;
- ifomula lokufaka ekomelweni D3 libuyisa impendulo efanele ye-15 ngenkathi ingeza okuqukethwe kweseli A3 + B3 (10 + 5).
Umsebenzi we-SUBSTITUTE uqobo uyashintsha ngenkathi umsebenzi we-CHAR usetshenziselwa ukutshela ifomula ukuthi yiliphi uhlamvu oluthathe isikhundla.
03 ka 03
Ukususa izikhala ezingezona zokuphumula kusuka kwiphepha lokusebenzela
Ngokufanayo nezinhlamvu ezingaphenduliwe yi-space non-breaking (& nbsp) engabangela izinkinga ngokubala nokufometha kushidi lokusebenzela. Inombolo yekhodi ye-Unicode yezikhala ezingenqamuki ingu- # 160.
Izikhala ezingenayo ukuphulwa zisetshenziselwa kakhulu kumakhasi ewebhu, ngakho uma idatha ikopiwe ku-Excel kusuka kukhasi lewebhu, izikhala ezingekho-hluki zingabonakala kukhasi lokusebenzela.
Ukukhipha izikhala ezingekho ukuphulwa kungenziwa ngefomula ehlanganisa imisebenzi SUBSTITUTE, CHAR, kanye ne-TRIM.