Indlela yokususa izikhala ezengeziwe kusuka kuDatha kumaSpredishithi e-Google

01 ngo-02

Umsebenzi we-Google Spreadsheets'TRIM

I-Google Spreadsheets 'I-TRIM Umsebenzi. © Ted French

Lapho idatha yombhalo ingeniswa noma ikopiwe kwizikhala ezengeziwe ze-Google Spreadsheet ngezinye izikhathi ifakwe kanye nedatha yombhalo.

Ekhompyutheni, isikhala esiphakathi kwamagama akuyona indawo engalutho kodwa uhlamvu, futhi, lezi zinhlamvu ezingaphezulu zingathinta indlela idatha esetshenziselwa ngayo ishidi - njengomsebenzi we- CONCATENATE ohlanganisa amangqamuzana amaningi wedatha abe munye.

Kunokuba uhlele ngokuzenzakalelayo idatha ukuze ususe izikhala ezingafuneki, sebenzisa umsebenzi we-TRIM ukususa izikhala ezengeziwe phakathi kwamagama noma ezinye izintambo zombhalo .

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)

Ukuphikisana komsebenzi we-TRIM ngu:

umbhalo - idatha ofuna ukususa izikhala kusuka. Lokhu kungaba:

Qaphela: Uma idatha yangempela ehlongozwayo isetshenziselwa ukuphikisana kombhalo , kufanele ifakwe emamaki okucaphuna, njenge:

= TRIM ("Susa izikhala ezengeziwe")

Ukususa i-Original Data ne-Paste Special

Uma ireferensi yeseli yendawo yedatha okufanele ihlolwe isetshenziselwa ukuphikisana kombhalo , umsebenzi awukwazi ukuhlala esitokisini esifanayo njengedatha yangempela.

Ngenxa yalokho, umbhalo ophethwe ekuqaleni kumele uhlale endaweni yawo yokuqala kushidi lokusebenzela. Lokhu kungabonisa izinkinga uma kunesidingo esikhulu sezintambo noma uma idatha yangempela isendaweni yomsebenzi obalulekile.

Enye indlela ezungeze le nkinga ukusebenzisa i- Paste Special kumanani okunamathisela kuphela ngemuva kokuthi idatha ikopishwe. Lokhu kusho ukuthi imiphumela yomsebenzi we-TRIM ingadluliselwa emuva kwedatha yangempela bese umsebenzi we-TRIM ususiwe.

Isibonelo: Susa izikhala ezengeziwe nge-TRIM Umsebenzi

Lesi sibonelo sihlanganisa izinyathelo ezidingekayo ukuze:

Ukufaka idatha yokufundisa

  1. Vula i-Google Spreadsheet enombhalo oqukethe izikhala ezengeziwe okudingeka zisuswe, noma ukopisha uphinde unamathisele imigqa engezansi engqamuzaneni A1 kuya ku-A3 kuphepha lokusebenzela Row 1 lweDatha ngezikhala ezengeziwe Umzila 2 weDatha ngezikhala ezengeziwe Umzila 3 weDatha Izikhala ezengeziwe

02 ka 02

Ukufaka umsebenzi we-TRIM

Ukufaka i-TRIM Umsebenzi wokuphikisa. © Ted French

Ukufaka umsebenzi we-TRIM

I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

  1. Uma usebenzisa idatha yakho siqu, chofoza esitokisini sephepha lokusebenzela lapho ufuna khona idatha ehlongozwe ukuhlala
  2. uma ulandela lesi sibonelo, chofoza ku-cell A6 ukuze wenze iseli elisebenzayo - yilapho umsebenzi we-TRIM uzofakwa nalapho umbhalo ohleliwe uzoboniswa khona
  3. Thayipha uphawu olulinganayo (=) olulandelwe igama le- trim function
  4. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngohlamvu T
  5. Uma igama TRIM livela ebhokisini, chofoza igama nge-pointer yegundane ukufaka igama lomsebenzi bese uvula ibakaki nxazonke esitokisini A6

Ukufaka Ukungqubuzana Komsebenzi

Njengoba kuboniswe esithombeni esingenhla, ukuphikisana komsebenzi we-TRIM kufakwe ngemuva kokubhalwa okuvulekile nxazonke.

  1. Chofoza ku-cell A1 kusikripthi sokusebenza ukuze ufake leli referensi yeseli njengokungqubuzana kombhalo
  2. Cindezela ukhiye wokungena kwikhibhodi ukungena ibhakha lokuvala " ) " emva kokuphikisana komsebenzi futhi ukuqedela umsebenzi
  3. Umugqa wombhalo ovela esitokisini A1 kufanele uvele esitokisini A6, kodwa ngesikhala esisodwa phakathi kwegama ngalinye
  4. Uma uchofoza ku-cell A6 umsebenzi ophelele = I-TRIM (A1) ivela kubha yefomula ngaphezulu kwephepha lokusebenzela.

Ukukopisha umsebenzi nge-Handle Fill

Isibambo sokugcwalisa sisetshenziselwa ukukopisha umsebenzi we-TRIM esitokisini A6 kumaseli A7 no-A8 ukuze ususe izikhala ezengeziwe emigqeni yombhalo kuma-A2 no-A3.

  1. Chofoza ku-cell A6 ukuze wenze iseli esebenzayo
  2. Beka isikhombisi segundane phezu kwesikwele esimnyama ekhoneni elingezansi elingakwesokudla le-cell A6 - isilinki sizoshintshela kwesibonakaliso esengeziwe " + "
  3. Chofoza bese ubamba inkinobho yegundane lesokunxele bese uhudula isibambo sokugcwalisa phansi esitokisini A8
  4. Khipha inkinobho yegundane - amaseli A7 no-A8 kufanele aqukathe imigqa eqoshiwe yombhalo kusuka kumaseli A2 no-A3 njengoba kuboniswe esithombeni ekhasini 1

Ukususa i-Original Data ne-Paste Special

Idatha yasekuqaleni kumaseli A1 kuya ku-A3 ingasuswa ngaphandle kokuphazamisa idatha enqanyuliwe ngokusebenzisa okukhethwa kukho kwamanani okunamathisela okukhethekile ukuze unamathisele idatha yangempela kumaseli A1 kuya ku-A3.

Ngemva kwalokho, imisebenzi ye-TRIM kuma cell A6 kuya ku-A8 nayo izosuswa njengoba ingasadingeki.

#REF! amaphutha : uma umsebenzi wokukopisha nokunamathisela ojwayelekile usetshenziselwa esikhundleni sokunamathela amanani , imisebenzi ye-TRIM izofakwa kumaseli A1 kuya ku-A3, okuzoholela ku-#REF eminingi! amaphutha aboniswa kushidi lokusebenzela.

  1. Gqamisa amaseli A6 kuya ku-A8 kushidi lokusebenzela
  2. Kopisha idatha kulawa maseli usebenzisa i- Ctrl + C ekhibhodi noma Hlela> Kopisha kumamenyu - la maseli amathathu kufanele ahlongozwe emngceleni ohlanganisiwe ukuze akhombise ukuthi akopishwe
  3. Chofoza kuseli A1
  4. Chofoza ku- Hlela> Namathisela okhethekile> Namathisela amanani kuphela kwamamenyu ukunamathisela kuphela imiphumela yomsebenzi we-TRIM kumaseli A1 kuya ku-A3
  5. Umbhalo oqoshiwe kufanele ube khona kumaseli A1 kuya ku-A3 kanye namaseli A6 kuya ku-A8
  6. Gqamisa amaseli A6 kuya ku-A8 kushidi lokusebenzela
  7. Cindezela ukhiye wokususa ekhibhodi ukuze ususe imisebenzi emithathu ye-TRIM
  8. Idatha elungisiwe kufanele isabile kumaseli A1 kuya ku-A3 ngemuva kokususa imisebenzi