Izindlela Ezi-2 Zokukhipha Izikhala Phakathi Kwamagama noma Izinombolo Kumaseli E-Excel

Kulesi sihloko, uzofunda izindlela ezi-2 ezisheshayo zokususa izikhala ezengeziwe phakathi kwamagama noma zonke izikhala kumaseli e-Excel. Ungasebenzisa umsebenzi I-TRIM (TRIM) noma ithuluzi Thola bese ushintsha (Thola futhi Faka esikhundleni) ukuze uhlanze okuqukethwe kwamaseli ku-Excel.

Uma unamathisela idatha evela emthonjeni wangaphandle eshidini le-Excel (umbhalo ongenalutho, izinombolo, njll.), ungase ugcine usunezikhala ezengeziwe kanye nedatha ebalulekile. Lezi kungaba izikhala eziholayo nezilandelanayo, izikhala eziningi phakathi kwamagama, noma izihlukanisi eziyizinkulungwane ngezinombolo.

Ngenxa yalokho, ithebula libukeka lingahlelekile futhi kuba nzima ukulisebenzisa. Kungase kubonakale sengathi umsebenzi olula ungaba nzima. Isibonelo, thola umthengi oqanjwe igama John Doe (azikho izikhala ezengeziwe phakathi kwezingxenye zegama), kuyilapho etafuleni ligcinwa ngokuthi “John Doe“. Noma izinombolo ezingakwazi ukufingqwa, futhi izikhala ezengeziwe yizo ezinecala.

Kulesi sihloko uzofunda ukuthi ungasula kanjani idatha ezikhaleni ezengeziwe:

• Sisusa zonke izikhala ezingeziwe phakathi kwamagama, futhi sinqamula izikhala eziholayo nezilandelanayo
  • Kusetshenziswa umsebenzi we-TRIM (TRIM).
  • Sebenzisa ithuluzi elithi Thola & Faka esikhundleni (Thola futhi Faka esikhundleni)
• Susa ZONKE izikhala phakathi kwamagama noma izinombolo

Susa zonke izikhala ezengeziwe phakathi kwamagama, nqamula izikhala eziholayo nezilandelanayo

Ake sithi sinetafula elinamakholomu amabili. Kukholomu Igama iseli lokuqala liqukethe igama John Doe, ibhalwe ngendlela efanele, okungukuthi ngaphandle kwezikhala ezengeziwe. Wonke amanye amaseli aqukethe inketho yokungena enezikhala ezengeziwe phakathi kwegama lokuqala nesibongo, kanye nasekuqaleni nasekupheleni (izikhala eziholayo nezilandelanayo). Ekholamu yesibili, enesihloko ubude, ikhombisa inani lezinhlamvu egameni ngalinye.

Sebenzisa umsebenzi we-TRIM ukuze ususe izikhala ezengeziwe

Kukhona umsebenzi ku-Excel I-TRIM (TRIM), esetshenziselwa ukususa izikhala ezengeziwe embhalweni. Ngezansi uzothola imiyalelo yesinyathelo ngesinyathelo sokusebenza naleli thuluzi:

1. Engeza ikholomu yomsizi eduze kwedatha yakho. Ungakwazi yini ukuyisho Qalisa.
2. Kuseli lokuqala lekholomu elisizayo (C2), faka ifomula ukuze ususe izikhala ezengeziwe:

   =TRIM(A2)

   =СЖПРОБЕЛЫ(A2)

   

3. Kopisha le fomula kuwo wonke amaseli kukholamu. Ungasebenzisa amathiphu avela esihlokweni Indlela yokufaka ifomula efanayo kuwo wonke amaseli akhethiwe ngesikhathi esisodwa.
4. Shintshanisa ikholomu yangempela nedatha etholiwe. Ukuze wenze lokhu, khetha wonke amaseli wekholomu eyisizayo bese uchofoza Ctrl + Cukukopisha idatha ebhodini lokunamathisela. Okulandelayo, khetha iseli lokuqala lekholomu yokuqala (kithi A2), cindezela Shift + F10 noma ikhi yemenyu yesinqamuleli, kanye nekhi V (NGANYE).
5. Susa ikholomu yomsizi.

Ilungile! Sisuse zonke izikhala ezengeziwe ngomsebenzi I-TRIM (IZIKHALA ZAMA-TRIM). Ngeshwa, le ndlela ithatha isikhathi esiningi, ikakhulukazi uma itafula likhulu impela.

Qaphela: Uma usabona izikhala ezengeziwe ngemva kokusebenzisa ifomula, umbhalo cishe uqukethe izikhala ezinganqamuki. Ungawasusa kanjani, ungafunda kulesi sibonelo.

Sebenzisa ithuluzi elithi Thola bese Ufaka esikhundleni ukuze ususe izikhala ezengeziwe phakathi kwamagama

Le nketho idinga umsebenzi omncane, kodwa ikuvumela ukuthi ususe izikhala ezengeziwe phakathi kwamagama. Izikhala eziholayo nezilandelanayo nazo zizosikwa zibe ngu-1, kodwa zingasuswa ngokuphelele.

1. Khetha ikholomu eyodwa noma ngaphezulu yedatha ofuna ukususa kuyo izikhala ezengeziwe phakathi kwamagama.
2. Cindezela Ctrl + Hukuze uvule ibhokisi lengxoxo Thola bese ushintsha (Thola bese ufaka esikhundleni).
3. Faka isikhala kabili ensimini Thola Yini (Thola) futhi kanye ensimini Faka esikhundleni se- (Kufakwe esikhundleni).
4. Chofoza inkinobho Faka esikhundleni konke (Faka esikhundleni Konke) bese-ke OKukuvala iwindi lolwazi elivelayo.
5. Phinda isinyathelo sesi-4 kuze kuvele umyalezo Asikwazanga ukuthola okuthile okungashintsha... (Asitholanga lutho obeludinga ukushintshwa…).

Susa zonke izikhala phakathi kwezinombolo

Ake sithi unetafula elinezinombolo lapho amaqoqo amadijithi (izinkulungwane, izigidi, izigidigidi) ahlukaniswa ngezikhala. Kulokhu, i-Excel ithatha izinombolo njengombhalo futhi akukho msebenzi wezibalo ongenziwa.

Indlela elula yokususa izikhala ezengeziwe ukusebenzisa ithuluzi elijwayelekile le-Excel - Thola bese ushintsha (Thola bese ufaka esikhundleni).

• Cindezela Ctrl+Space (Isikhala) ukuze ukhethe wonke amaseli kukholamu.
• Cindezela Ctrl + Hukuvula ibhokisi Thola bese ushintsha (Thola bese ufaka esikhundleni).
• In the Thola Yini (Thola) faka isikhala esisodwa. Qinisekisa inkambu Faka esikhundleni se- (Faka esikhundleni ngokuthi) – akunalutho.
• Chofoza inkinobho Faka esikhundleni konke (Susa Konke), bese OK. Voila! Zonke izikhala zisusiwe.

Susa zonke izikhala usebenzisa ifomula

Ungase ukuthole kuwusizo ukusebenzisa ifomula ukuze ususe zonke izikhala. Ukuze wenze lokhu, ungakha ikholomu eyisizayo bese ufaka ifomula elandelayo:

=SUBSTITUTE(A1," ","")

=ПОДСТАВИТЬ(A1;" ";"")

Lapha A1 iyiseli lokuqala kukholamu equkethe izinombolo noma amagama, lapho zonke izikhala kufanele zikhishwe khona.

Okulandelayo, landela izinyathelo ezifanayo njengasesigabeni sokususa zonke izikhala ezengeziwe phakathi kwamagama usebenzisa ifomula.