Funda ukuthi ungasusa kanjani izikhala ezengeziwe kusuka ku-Excel

Yenza i-spreadsheet yakho ibonakale imnandi futhi ihlelekile

Lapho idatha yombhalo ingeniswa noma ikopiwe kwi-Excel sheet sheet izikhala ezengeziwe zingase zifakwe ngezinye izikhathi kanye nedatha yombhalo. Umsebenzi we-TRIM ungasetshenziswa ukususa izikhala ezengeziwe phakathi kwamazwi noma ezinye izintambo zombhalo ku-Excel - njengoba kuboniswe esitokisini A6 esithombeni ngenhla.

Kodwa-ke, umsebenzi udinga ukuba idatha yangempela ihlale ingenjalo kwenye indawo ngaphandle kokusebenza komkhiqizo.

Ngokuvamile, kungcono ukugcina idatha yangempela. Kungaba kufihliwe noma kufakwe kwenye i-sheetsheet yokusebenzela ukuyiyeka.

Ukusebenzisa Amanani Okunamathisela Ngomsebenzi we-TRIM

Uma, noma kunjalo, umbhalo wokuqala awusadingeki, ukhetho lwama-Excel lwezintambo lwenza kube lula ukugcina umbhalo ohleliwe ngenkathi ususa idatha yangempela kanye ne-TRIM.

Indlela lokhu kusebenza ngayo, njengoba kuchazwe ngezansi, yilokho amagugu wokunamathisela asetshenziselwa ukunamathisela umsebenzi we-TRIM okukhipha emuva kwedatha yangempela noma kunoma iyiphi enye indawo oyifunayo.

I-syntax ye-TRIM kanye ne-Arguments ye-TRIM

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-TRIM yilezi:

= TRIM (Umbhalo)

Umbhalo - idatha ofuna ukususa izikhala kusuka. Le mpikiswano ingaba:

• idatha yangempela ehlanganiswe kumamaki okucaphuna.
• ireferensi yeseli endaweni yedatha yombhalo ekhasini lokusebenzela.

Isibonelo sokusebenza se-TRIM

Emfanekisweni ngenhla, umsebenzi we-TRIM - osesithombeni A6 - usetshenziselwa ukususa izikhala ezengeziwe kusukela phambili naphakathi kwedatha yombhalo esesitokisini A4 sephepha lokusebenzela.

Ukukhishwa komsebenzi ku-A6 kukopishwa futhi kusetshenziswe - usebenzisa amanani wokunamathisela - ubuyele esitokisini A4. Ukwenza kanjalo ubeka ikhophi eqondile yezinto eziku-A6 esitokisini A4 kodwa ngaphandle komsebenzi we-TRIM.

Isinyathelo sokugcina sizosusa umsebenzi we-TRIM kuseli A6 ushiya idatha ehleliwe efonini A4.

Ukufaka umsebenzi we-TRIM

Izinketho zokufaka umsebenzi kanye nokuphikisana kwazo zihlanganisa:

1. Ukuthayipha umsebenzi ophelele: = TRIM (A4) ibe yiseli A6.
2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lebhokisi lengxoxo ye- TRIM .

Izinyathelo ezingezansi zisebenzisa ibhokisi lokusebenza lomsebenzi we-TRIM ukuze ufake umsebenzi ku-cell A6 ephepheni lokusebenzela.

1. Chofoza kuselili A6 ukuze lenze iseli elisebenzayo - yilapho umsebenzi uzobe khona.
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon .
3. Khetha Umbhalo kusuka kubhebhoni ukuze uvule uhlu oluhlehlisiwe lomsebenzi.
4. Chofoza ku- TRIM kuhlu ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
5. Ebhokisini lebhokisi, chofoza ku- Text line.
6. Chofoza ku-cell A4 kushidi lokufaka ukuze ufake leyo reference reference njenge-argument ye-Text yomsebenzi.
7. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
8. Umugqa wombhalo Susa izikhala ezengeziwe kusuka phakathi kwamazwi noma umbhalo kufanele zivele esitokisini A6, kodwa ngesikhala esisodwa kuphela phakathi kwegama ngalinye.
9. Uma uchofoza kweseli A6 umsebenzi ophelele = I-TRIM (A4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

Ukudlulisela phezu kwedatha yokuqala kanye nemigomo yokunamathisela

Izinyathelo zokususa idatha yangempela futhi ekugcineni umsebenzi we-TRIM kuseli cell A6:

1. Chofoza kuseli A6.
2. Cindezela ukhiye we- Ctrl + c ekhibhodi noma uchofoze inkinobho yeKopi kuthebhu laseKhaya lebhebhoni - idatha ekhethiwe izozungezwa yizintuthwane zokuhamba.
3. Chofoza kuseli A4 - indawo yedatha yangempela.
4. Chofoza kumcibisholo omncane phansi kwe-Inkinobho Yokunamathisela kuthebhu yaseKhaya yebhande ukuze uvule Izinketho zokunamathisela izinketho.
5. Chofoza ku- Values inketho kwimenyu ehlehlisayo - njengoba kuboniswe esithombeni ngenhla - ukunamathisela umbhalo ohleliwe emuva kweseli A4.
6. Susa umsebenzi we-TRIM esitokisini A6 - ushiye idatha ehleliwe esitokisini sokuqala.

Uma umsebenzi we-TRIM awusebenzi

Ekhompyutheni, isikhala esiphakathi kwamagama akuyona indawo engenalutho kepha umlingisi, futhi, uma ukholwa noma cha, kukhona uhlobo olungaphezu koyedwa lomlingisi wesikhala.

Umsebenzi we-TRIM ngeke ususe zonke izinhlamvu zesikhala. Ngokuyinhloko, isilwane esisodwa esisetshenziselwa isikhala esingaxoshwa yi-TRIM yisithuba esingezona () esetshenziswe kumakhasi wewebhu.

Uma unedatha yekhasi lewebhu ngezikhala ezengeziwe ukuthi i-TRIM ayikwazi ukususa, zama le-TRIM umsebenzi ifomula ehlukile engalungisa inkinga.