2 Nzira dzekubvisa Nzvimbo Pakati peMazwi kana Nhamba muExcel Masero

Muchikamu chino, iwe uchadzidza 2 nzira dzinokurumidza kubvisa dzimwe nzvimbo pakati pemashoko kana nzvimbo dzese kubva kuExcel maseru. Unogona kushandisa basa TRIM (TRIM) kana chishandiso Tsvaga & Tsiva (Tsvaga uye Dzorera) kuchenesa zviri mukati memasero muExcel.

Paunoisa data kubva kune yekunze sosi muExcel sheet (yakajeka mavara, manhamba, nezvimwewo), unogona kupedzisira uine dzimwe nzvimbo pamwe neakakosha data. Idzi dzinogona kuve dzinotungamira uye dzinotevera nzvimbo, nzvimbo dzakawanda pakati pemazwi, kana zviuru zvinopatsanura munhamba.

Nekuda kweizvozvo, tafura inotaridzika zvishoma isina kuchena uye inova yakaoma kushandisa. Zvingaita sekuti basa riri nyore rinogona kuoma. Semuenzaniso, tsvaga mutengi anonzi John Doe (hapana imwe nzvimbo pakati pezvikamu zvezita), nepo patafura inochengetwa se“John Doe“. Kana kuti nhamba dzisingagoni kupfupikiswa, uye zvakare dzimwe nzvimbo dzine mhosva.

Kubva kuchinyorwa ichi iwe uchadzidza nzira yekubvisa data kubva kune dzimwe nzvimbo:

• Isu tinobvisa ese ekuwedzera nzvimbo pakati pemazwi, uye zvakare cheka inotungamira uye yekutevera nzvimbo
  • Kushandisa iyo TRIM (TRIM) basa
  • Isa iyo Tsvaga & Tsiva chishandiso (Tsvaga uye Tsiva)
• Bvisa nzvimbo dzese pakati pemazwi kana nhamba

Bvisa nzvimbo dzese dzekuwedzera pakati pemazwi, cheka inotungamira uye yekutevera nzvimbo

Ngatitii tine tafura ine makoramu maviri. Muchikamu zita sero rekutanga rine zita John Doe, yakanyorwa nemazvo, kureva pasina dzimwe nzvimbo. Mamwe masero ese ane sarudzo yekupinda ine dzimwe nzvimbo pakati pezita rekutanga nerekupedzisira, pamwe nekutanga nekuguma (nzvimbo dzinotungamira nedzinotevera). Muchikamu chechipiri, ine musoro urefu, inoratidza nhamba yemavara muzita rega rega.

Shandisa iyo TRIM basa kubvisa dzimwe nzvimbo

Pane basa muExcel TRIM (TRIM), iyo inoshandiswa kubvisa dzimwe nzvimbo kubva pane zvinyorwa. Pazasi iwe unowana nhanho-ne-nhanho mirairo yekushanda neichi chishandiso:

1. Wedzera koramu yemubatsiri padivi pe data rako. Unogona kuzvitumidza here? Trim.
2. Musero rekutanga rekoramu yekubatsira (C2), isa fomula yekubvisa dzimwe nzvimbo:

   =TRIM(A2)

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

   

3. Kopa fomura iyi kune mamwe maseru ari mukoramu. Iwe unogona kushandisa mazano kubva muchinyorwa Maitiro ekuisa fomula imwechete mumaseru ese akasarudzwa kamwechete.
4. Chinja mbiru yekutanga nedata rakagamuchirwa. Kuti uite izvi, sarudza ese maseru emubatsiri column uye tinya Ctrl + Ckukopa data kune clipboard. Tevere, sarudza sero rekutanga rekoramu yekutanga (munyaya yedu A2), tinya Shift + F10 kana kiyi yekudimbudzira menyu, uyezve kiyi V (NE).
5. Bvisa mutsara wemubatsiri.

Ready! Takabvisa nzvimbo dzese dzekuwedzera nebasa TRIM (TRIM SPACES). Zvinosuruvarisa, nzira iyi inotora nguva yakawanda, kunyanya kana tafura yakakura.

Cherechedza: Kana iwe uchiri kuona dzimwe nzvimbo mushure mekushandisa fomula, iwo mameseji anogona kunge aine nzvimbo dzisiri dzekutyora. Nzira yekuvabvisa sei, unogona kudzidza kubva pamuenzaniso uyu.

Shandisa Tsvaga uye Kutsiva chishandiso kubvisa dzimwe nzvimbo pakati pemazwi

Iyi sarudzo inoda basa shoma, asi inokubvumira kubvisa chete nzvimbo dzekuwedzera pakati pemashoko. Nzvimbo dzinotungamira uye dzekutevera dzichachekwawo kusvika pa1, asi dzisina kubviswa zvachose.

1. Sarudza imwe kana mamwe makoramu e data yaunoda kubvisa mamwe nzvimbo pakati pemazwi.
2. dzvanya Ctrl + Hkuvhura dialog box Tsvaga & Tsiva (Tsvaga uye tsiva).
3. Pinda nzvimbo kaviri mumunda Tsvaga chii (Tsvaga) uye kamwe mumunda Tsiva ne (Yatsiviwa ne).
4. dzvanya Tsiva zvese (Tsvanura Zvose) uye ipapo OKkuvhara hwindo remashoko rinoonekwa.
5. Dzokorora danho rechina kusvika meseji yaoneka Hatina kuwana chekutsiva… (Hatina kuwana chero chinhu chaida kutsiviwa…).

Bvisa nzvimbo dzese pakati penhamba

Ngatitii une tafura ine nhamba umo mapoka emanhamba (zviuru, mamiriyoni, mabhiriyoni) akapatsanurwa nenzvimbo. Muchiitiko ichi, Excel inobata nhamba sezvinyorwa uye hapana masvomhu anogona kuitwa.

Nzira iri nyore yekubvisa dzimwe nzvimbo ndeye kushandisa yakajairwa Excel chishandiso - Tsvaga & Tsiva (Tsvaga uye tsiva).

• dzvanya Ctrl+Space (Space) kusarudza maseru ese ari mukoramu.
• dzvanya Ctrl + Hkuvhura dialog Tsvaga & Tsiva (Tsvaga uye tsiva).
• Mu Tsvaga chii (Tsvaga) isa imwe nzvimbo. Ita shuwa munda Tsiva ne (Siva ne) - isina chinhu.
• dzvanya Tsiva zvese (Tsvanura Zvose), ipapo OK. Voila! Nzvimbo dzese dzakabviswa.

Bvisa nzvimbo dzese uchishandisa fomula

Unogona kuona zvichibatsira kushandisa fomula kubvisa nzvimbo dzese. Kuti uite izvi, iwe unogona kugadzira iyo yekubatsira koramu uye isa inotevera fomula:

=SUBSTITUTE(A1," ","")

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

pano A1 ndiro sero rekutanga muchikamu chine nhamba kana mazwi, umo nzvimbo dzese dzinofanira kubviswa.

Tevere, tevera nhanho dzakafanana sezviri muchikamu chekubvisa ese ekuwedzera nzvimbo pakati pemazwi uchishandisa fomula.