Funda indlela yokususa iZithuba ezongezelelweyo ukusuka kwi-Excel

Yenza i-spreadsheet yakho ibonakale imnandi kwaye ihlaziye

Xa idatha yombhalo ingeniswa okanye ikopiwe kwi-Excel sheet sheet izikhala ezizezinye iyakuthi ifakwe kunye nedata yombhalo. Umsebenzi we-TRIM ungasetyenziselwa ukususa izithuba ezingaphezulu phakathi kwamagama okanye ezinye izixhobo zombhalo kwi-Excel - njengoko kuboniswe kwiseli A6 kumfanekiso ongentla.

Umsebenzi ufuna, nangona kunjalo, ukuba idatha yasekuqaleni isekhona kwindawo ethile ngaphandle koko umphumela womsebenzi uya kulahla.

Ngokuqhelekileyo, kukulungele ukugcina idatha yangaphambili. Iyakwazi ukufihla okanye ifumaneke kwelinye iphepha lokusebenzela ukuze liphume kwindlela.

Ukusebenzisa iMilinganiselo yeMigangatho kunye neSebenzi ye-TRIM

Ukuba ke, nangona kunjalo, isicatshulwa sasekuqaleni asisadingeki, ukhetho lwe-Excel lwamaxabiso oluthile lwenza ukuba kube lula ukugcina itekisi ehleliweyo ngelixa ususa idatha yangaphambili kunye ne-TRIM.

Indlela oku kusebenza ngayo, njengoko kuchaziwe ngezantsi, kukuba ixabiso lokunamathisela lisetyenziselwa ukunamathisela umsebenzi we-TRIM emva kwendawo yedatha yasekuqaleni okanye nakweyiphi enye indawo oyifunayo.

I-Syntax yeNkqubo yeeNtsebenzo kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-TRIM:

= ITHEMBA (Umbhalo)

Umbhalo - idatha ofuna ukususa izikhala kuzo. Le ngxabano ingaba:

• idatha echanekileyo edibeneyo kumanqaku okucaphuna.
• ireferensi yeseli kwindawo yokubhaliweyo kwiphepha lokusebenzela.

Umsebenzi we-TRIM

Kulo mfanekiso ungentla, umsebenzi we-TRIM - ophakathi kwiseli ye-A6 - isetyenziselwa ukususa izithuba ezizeleyo phambi nangaphandle kwedatha yombhalo ekhoyo kwiseli A4 kwiphepha lokusebenzela.

Isiphumo somsebenzi kwi-A6 sikopishwa kwaye senziwe ngokusetyenzwa - kusetyenziswa ixabiso lokunamathisela - ubuye kwisitrasi A4. Ukwenza njalo ubeka ikopi echanekileyo yomxholo kwi-A6 kwi-cell A4 kodwa ngaphandle komsebenzi we-TRIM.

Isinyathelo sokugqibela siza kususa umsebenzi we-TRIM kwiseli ye-A6 eshiya kuphela idatha yedatha ehleliwe kwi-cell A4.

Ukufaka umsebenzi we-TRIM

Izinketho zokungena kumsebenzi kunye nengxabano yayo zibandakanya:

1. Ukuthayipha umsebenzi opheleleyo: = I-TRIM (A4) kwi-cell A6.
2. Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yencoko ye -TRIM .

Amanyathelo angezantsi asebenzise ibhokisi yencoko yebhodi yencoko ye-TRIM ukufaka umsebenzi kwiseli A6 kwiphepha lokusebenzela.

1. Cofa kwiseli ye-A6 ukwenza i- cell esebenzayo- yilapho umsebenzi uya kuba khona.
2. Cofa kwiTrafom ithebhu yemenyu yebhondi .
3. Khetha umbhalo kwibhanethi ukuze uvule uluhlu lwehla lokuhla.
4. Cofa kwi- TRIM kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
5. Kwibhokisi yencoko, nqakraza kwi- Text line.
6. Cofa kwifowuni A4 kwiphepha lokusebenzela ukuze ufake eso saziso senxeba njengengqinano yombhalo womsebenzi.
7. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
8. Umgca wesicatshulwa Susa izithuba ezongezelelweyo ukusuka phakathi kwegama okanye umbhalo kufuneka zivele kwiseli ye-A6, kodwa ngegama elilodwa kuphela phakathi kwegama ngalinye.
9. Ukuba ucofa kwi-cell A6 umsebenzi opheleleyo = I-TRIM (A4) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

Ukudlulela kwiNkcazo yeNkcazo ngeMilinganiselo yokuHlanganisa

Amanyathelo ukususa idatha yangaphambili kwaye ekugqibeleni umsebenzi we-TRIM kwiseli A6:

1. Cofa kwi cell A6.
2. Cinezela iifayile ze Ctrl + c kwikhibhodi okanye nqakraza kwiKhiphi yeKopi kwikhaya laseKhaya lebhebhoni - idatha ekhethiweyo iya kubhalwa ngeeNtsana zokuHlaba.
3. Cofa kwiseli A4 - indawo yedatha yasekuqaleni.
4. Cofa kwiincinci encinci kwinqanaba laseKhotsheni kwiKhaya lasekhaya lebhebhoni ukuvula Imenyu yokunqumla imenyu ehla.
5. Cofa kwi- Values ukhetho kwimenyu ehlayo - njengoko kuboniswe kumfanekiso ongentla - ukunamathisela itekisi ehleliweyo kwi-cell A4.
6. Susa umsebenzi we-TRIM kwiseli ye-A6-ushiye idatha ehleliweyo kwiseli yasekuqaleni.

Ukuba umsebenzi we-TRIM awusebenzi

Kwikhompyutheni, isikhala phakathi kwamagama asiyindawo engenanto kodwa umlingisi, kwaye, ukukholelwa okanye cha, kukho uhlobo olungaphezulu kolunye uhlobo lomdlali.

Umsebenzi we-TRIM awuyi kususa bonke abalinganiswa bendawo. Ngokukodwa, isilwanyana esisodwa esisetyenziswa ngokuqhelekileyo esingasisuswanga yi-TRIM isikhala esingenanto sokuphulwa () esetyenziswe kumakhasi ewebhu.

Ukuba unedatha yekhasi lewebhu kunye neendawo ezingaphezulu ezingenakususa i-TRIM, zama le ndlela ye-TRIM ifom enye indlela engayilungisa ingxaki.