Sebenzisa umsebenzi ocacile ukususa inombolo yezinhlamvu zekhompiyutha ezingaphenduliwe ezikopishwe noma zangeniswa kufomethe lokusebenzela kanye nedatha enhle.
Le khodi yezinga eliphansi livame ukutholakala ekuqaleni kanye / noma ekupheleni kwamafayela wedatha.
Ezinye izibonelo ezivamile zalabo abalingiswa abangabhaliswanga yizinhlamvu ezixutshwe nombhalo kuzibonelo zamaseli A2 no-A6 esithombeni ngenhla.
Lezi zinhlamvu zingaphazamisa ukusebenzisa idatha ekusebenzeni kokusebenza komsebenzi njengokunyathelisa, ukuhlunga nokuhlunga idatha.
Susa i-ASCII engaphenduliwe kanye ne-Unicode Characters nge-CLEAN Function
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-32 zokuqala (0 kuya ku-31) zezinqola ze-Unicode ne-ASCII zifana futhi zibizwa ngokuthi yizinhlamvu zokulawula ezisetshenziselwa izinhlelo zokulawula amadivaysi omsakazo njengamaphrinta.
Njengalokhu, akuhloswe ukuthi kusetshenziswe kushidi lokusebenzela futhi kungabangela izinhlobo zeziphutha ezibalulwe ngenhla uma zikhona.
Umsebenzi ohlanzekile, owenza kuqala isethi yezinhlamvu ze-Unicode, yakhelwe ukususa izinhlamvu ezingu-32 zokuqala ezingezona zokunyathelisa ze-ASCII futhi ususe izinhlamvu ezifanayo kusuka kusethi ye-Unicode.
I-Syntax Esebenzayo Nama-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax ye-CLEAN umsebenzi yile:
= OKUQHELEKILE (Umbhalo)
Umbhalo - (okudingekayo) idatha yokuhlanzwa kwezinhlamvu ezingabhaliwe. Ukubhekisela kweseli endaweni yile datha kushidi lokusebenzela.
Isibonelo, ukuhlanza idatha kuseli A2 esithombeni ngenhla, faka ifomula:
= OKUKHULU (A2)
kwelinye iseli leshidi lomsebenzi.
Izinombolo zokuhlanza
Uma kusetshenziselwa ukuhlanza idatha yezinombolo, umsebenzi okhishiwe, ngaphezu kokususa noma yiliphi izinhlamvu ezingashicileli, kuzoguqula zonke izinombolo zibe umbhalo - ezingabangela amaphutha uma leyo datha isetshenziselwa ukubalwa.
Izibonelo: Ukususa Izinhlamvu ezingaphenduliwe
Kukholomu A esithombeni, umsebenzi we- CHAR usetshenziselwe ukwengeza izinhlamvu ezingezona zokuphrinta kumbhalo wombhalo njengoba kuboniswe kwibha yefomula ngaphezu kweshidi lomsebenzi we-cell A3 osuselwe eceleni nge-CLEAN function.
Kumakholomu B no-C wesithombe esingenhla, umsebenzi we-LEN, obala inani labalingiswa esitokisini, usetshenziselwa ukukhombisa umphumela wokusebenzisa umsebenzi ocacile kwimininingwane kukholomu A.
Ubuningi balinganisela iseli B2 yi-7 - izinhlamvu ezine zombhalo wezwi futhi ezintathu zezinhlamvu ezingezona ukuphrinta ezizungezile.
Ubuningi balinganisela esitokisini C2 ngu-4 ngoba umsebenzi we-CLEAN ungeziwe kwifomula futhi uhlukanisa izinhlamvu ezintathu ezingabonakali ngaphambi kokuba umsebenzi we-LEN ubale izinhlamvu.
Ukususa izinhlamvu # 129, # 141, # 143, # 144, no # 157
Iqoqo lezinhlamvu ze-Unicode liqukethe izinhlamvu ezingeziwe zokuphrinta ezingatholakali kwisethi yezinhlamvu ze-ASCII - izinombolo 129, 141, 143, 144, no-157.
Ngisho noma i-website ye-Excel yokusekela ithi ayikwazi, umsebenzi ocacile ungasusa lezi zinhlamvu ze-Unicode kusuka kudatha njengoba kuboniswe emgqeni amathathu ngenhla.
Kulesi sibonelo, umsebenzi ocacile kukholomu C usetshenziselwa ukuhlubula lezi zinhlamvu eziyisihlanu ezingabonakali zokulawula ukushiya futhi ukubala komlingiswa wezinhlamvu ezine zegama le-C3.
Ukususa Isici # 127
Kukhona umlingisi owodwa ongakushicileli kusethi ye-Unicode ukuthi umsebenzi ongeke ukwazi ukususa - umlingiswa obanjwe ebhokisini # 127 oboniswe esitokisini A4, lapho ezine zalezi zinhlamvu zizungezile umbhalo wezwi.
Ubuningi bomlingiswa obuyisishiyagalombili esitokisini C4 bufana nalokho esitokisini B4 nangenxa yokuthi umsebenzi ocacile ku-C4 uzama ngempumelelo ukuze ususe # 127 uqobo.
Kodwa-ke, njengoba kuboniswe emigqeni emihlanu nangaphezulu ayisithupha ngenhla, kukhona amafomula ahlukile usebenzisa imisebenzi ye-CHAR ne- SUBSTITUTE engasetshenziswa ukususa lo mlingisi:
- Ifomula emgqeni wesihlanu isebenzisa i-SUBSTITUTE ne-CHAR ukuze ithathe isikhundla somlingiswa # 127 ngomlingisi owenziwa umsebenzi ocacile-kulesi simo, umlingiswa # 7 (idethi emnyama ebonwe esitokisini A2);
- Ifomula emgqeni wesithupha isebenzisa imisebenzi ye-SUBSTITUTE ne-CHAR ukuze ithathe isikhundla sezinhlamvu # 127 ngokungenalutho njengoba kuboniswa ngamanothi angcaphuno amakhophi ( "" ) ekupheleni kwefomula kwiseli D6. Ngenxa yalokho, umsebenzi ocacile awudingekile kufomula, ngoba akekho uhlamvu oluzokhipha.
Ukususa izikhala ezingezona zokuphumula kusuka kwiphepha lokusebenzela
Ngokufanayo nezinhlamvu ezingaphenduliwe yisikhala esingenqamuki esingabangela izinkinga ngokubala nokufometha kushidi lokusebenzela. Inani le-Unicode lesikhala esingenzi-break is # 160.
Izikhala ezingenayo ukusetshenziswa zisetshenziswe kakhulu kumakhasi wewebhu - ikhodi ye-ht for it & nbsp; - ngakho-ke uma idatha ikopiwe ku-Excel kusuka ekhasini lewebhu, izikhala ezingenqamuki zingafakwa.
Enye indlela yokukhipha izikhala ezingekho ukuphumula kusuka kwiphepha lokusebenzela lihambisana nale fomula ehlanganisa imisebenzi ye-SUBSTITUTE, CHAR, ne-TRIM.