Okuqukethwe
Izolo kumarathon 30 Excel isebenza ngezinsuku ezingama-30 sazithela kusbali oyivila igama lakhe IZINDABA (IZINDAWO). Lo msebenzi awuvamisile ukusetshenziswa ekusebenzeni, kodwa ngawo sibone ukuthi ama-opharetha amareferensi amathathu asebenza kanjani ku-Excel. Ngethemba ukuthi lesi sifundo sibe usizo kuwe.
Sizonikela ngosuku lwesithathu lwemarathon esifundweni somsebenzi I-TRIM (I-TRIM). NgoJanuwari, othile uzama ukulahlekelwa amakhilogremu ambalwa engeziwe, futhi ngale njongo ungasebenzisa i-Excel ukuze udale ikhalori counter noma igrafu yokulahlekelwa isisindo kuyo. Ngeshwa umsebenzi I-TRIM (TRIM) ngeke ikusize ekulweni namaphawundi engeziwe, kodwa ingasusa izikhala ezengeziwe emugqeni wombhalo.
Ngakho-ke ake sibheke ulwazi lwereferensi nezibonelo zokusebenzisa umsebenzi I-TRIM (TRIM) ku-Excel. Uma unamaqhinga akho noma izibonelo kulo msebenzi, sicela wabelane ngazo kumazwana. Futhi inhlanhla ngokubala ama-calories!
Umsebenzi 03: I-TRIM
Umsebenzi I-TRIM (TRIM) isusa zonke izikhala kuyunithi yezinhlamvu yombhalo ngaphandle kwezikhala ezilodwa phakathi kwamagama.
Ungawusebenzisa kanjani umsebenzi we-TRIM?
Umsebenzi I-TRIM (TRIM) ingasiza ekuhlanzeni umbhalo olandwe kuwebhusayithi noma ongeniswe kusuka kolunye uhlelo lokusebenza. Umsebenzi I-TRIM (TRIM):
- Ikhipha izikhala ekuqaleni nasekupheleni komugqa.
- Ikhipha zonke izikhala embhalweni ngaphandle kwesikhala esisodwa phakathi kwamagama.
- AYIKUSUSI ezinye izinhlamvu ezikhethekile ezikopishwe kuwebhusayithi.
I-TRIM Syntax (TRIM)
Umsebenzi we-TRIM une-syntax elandelayo:
TRIM(text)
СЖПРОБЕЛЫ(текст)
- text (umbhalo) uyireferensi yeseli noma iyunithi yezinhlamvu yombhalo ofuna ukususa kuyo izikhala
NQAPHELA TRAP
Umsebenzi I-TRIM (TRIM) isusa kuphela izinhlamvu zesikhala ezijwayelekile embhalweni. Uma ukopisha umbhalo kuwebhusayithi, ungase ube nezinhlamvu zesikhala ezinganqamuki, ezisebenza I-TRIM (TRIM) ayikwazi ukususwa.
Isibonelo sokuqala: Susa izikhala ekuqaleni nasekupheleni kweyunithi yezinhlamvu yombhalo
Ungasebenzisa umsebenzi I-TRIM (TRIM) ukususa zonke izikhala eziholayo nezilandelanayo kuyunithi yezinhlamvu yombhalo. Emfanekisweni ongezansi, iseli C5 liqukethe umbhalo onezikhala ezimbili ezengeziwe ekuqaleni nezimbili ekugcineni komugqa. Umsebenzi I-TRIM (TRIM) kuseli C7 isusa lezo zikhala ezi-4 ezengeziwe.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Isibonelo sesi-2: Susa zonke izikhala ngaphandle kokukodwa phakathi kwamagama
Ungasebenzisa umsebenzi I-TRIM (TRIM) ezikhaleni ezengeziwe phakathi kwamagama embhalweni. Esithombeni esingezansi, kunezikhala ezintathu ezengeziwe phakathi kwamagama kuseli C5. Umsebenzi I-TRIM (TRIM) kuseli C7 isusa lezo zikhala, kanye nezikhala ezimbili ezengeziwe ekuqaleni nasekupheleni kweyunithi yezinhlamvu yombhalo.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Isibonelo sesi-3: UNGAZISUSI KANJANI ezinye izinhlamvu ezikhethekile
Umsebenzi I-TRIM (I-TRIM) AYIKUSUSI ezinye izinhlamvu ezisetshenziswa njengezikhala. Isibonelo, isikhala esinganqamuki kungenzeka sibe khona embhalweni okopishwe kuwebhusayithi. Esithombeni esingezansi, iseli C5 liqukethe indawo eyodwa enganqamuki, futhi ayisuswa.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Ungasusa uhlamvu lwesikhala esinganqamuki ngesandla ngokusebenzisa uhlelo I-SUBSTITUTE (SUBSTITUTE) noma amakhro. Kamuva, ngesikhathi semarathon yethu 30 Excel isebenza ngezinsuku ezingama-30Uzofunda ezinye izindlela ezimbalwa zokuhlanza idatha ku-Excel.
