Njira ziwiri Zochotsera Malo Pakati pa Mawu kapena Nambala mu Maselo a Excel

M'nkhaniyi, muphunzira njira ziwiri zachangu zochotsera mipata yowonjezera pakati pa mawu kapena mipata yonse kuchokera ku maselo a Excel. Mutha kugwiritsa ntchito TRIM (TRIM) kapena chida Pezani & Sinthani (Pezani ndi Kusintha) kuti muyeretse zomwe zili m'maselo mu Excel.

Mukayika deta kuchokera ku gwero lakunja kupita ku pepala la Excel (malemba omveka, manambala, ndi zina zotero), mutha kukhala ndi malo owonjezera pamodzi ndi deta yofunikira. Izi zitha kukhala malo otsogola ndi otsata, mipata ingapo pakati pa mawu, kapena olekanitsa masauzande ambiri.

Chifukwa chake, tebulo limawoneka losawoneka bwino ndipo kumakhala kovuta kugwiritsa ntchito. Zingaoneke ngati ntchito yosavuta ikhoza kukhala yovuta. Mwachitsanzo, pezani wogula dzina lake John Doe (palibe mipata yowonjezera pakati pa magawo a dzina), pomwe patebulo amasungidwa ngati “John Doe“. Kapena manambala omwe sangathe kufotokozedwa mwachidule, komanso malo owonjezera ndi omwe amachititsa.

Kuchokera m'nkhaniyi muphunzira momwe mungachotsere deta kuchokera kumalo owonjezera:

• Timachotsa mipata yonse yowonjezereka pakati pa mawu, ndikudulanso mipata yoyambira ndi yotsatira
  • Kugwiritsa ntchito TRIM (TRIM) ntchito
  • Ikani chida cha Pezani & Kusintha (Pezani ndi Kusintha)
• Chotsani mipata YONSE pakati pa mawu kapena manambala

Chotsani mipata yonse yowonjezera pakati pa mawu, dulani mipata yoyambira ndi yotsatira

Tiyerekeze kuti tili ndi tebulo lokhala ndi mizati iwiri. Mugawo dzina selo loyamba lili ndi dzina John Doe, zolembedwa molondola, mwachitsanzo popanda mipata yowonjezera. Maselo ena onse ali ndi mwayi wolowera ndi mipata yowonjezera pakati pa mayina oyambirira ndi omaliza, komanso kumayambiriro ndi kumapeto (malo otsogolera ndi otsatila). Mugawo lachiwiri, ndi mutu utali, imasonyeza chiwerengero cha zilembo mu dzina lililonse.

Gwiritsani ntchito TRIM kuchotsa mipata yowonjezera

Pali ntchito mu Excel TRIM (TRIM), yomwe imagwiritsidwa ntchito kuchotsa mipata yowonjezera pamawu. Pansipa mupeza malangizo atsatanetsatane ogwiritsira ntchito chida ichi:

1. Onjezani gawo lothandizira pafupi ndi deta yanu. Kodi mungatchule Sakani.
2. Mu selo loyamba la gawo lothandizira (C2), lowetsani fomula kuti muchotse malo owonjezera:

   =TRIM(A2)

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

   

3. Lembani fomulayi m'maselo ena onse omwe ali mugawoli. Mutha kugwiritsa ntchito malangizo omwe ali m'nkhaniyi Momwe mungayikitsire chilinganizo chomwecho m'maselo onse osankhidwa nthawi imodzi.
4. Bwezerani mzati woyamba ndi zomwe mwalandira. Kuti muchite izi, sankhani ma cell onse agawo lothandizira ndikudina Ctrl + Ckukopera deta pa clipboard. Kenako, sankhani selo loyamba lagawo loyambirira (kwathu A2), dinani Shift + F10 kapena batani lachidule la menyu, ndiyeno kiyi V (NDI).
5. Chotsani gawo lothandizira.

Okonzeka! Tinachotsa malo onse owonjezera ndi ntchitoyi TRIM (TRIM SPACES). Tsoka ilo, njirayi imatenga nthawi yambiri, makamaka pamene tebulo ndi lalikulu kwambiri.

Zindikirani: Ngati mukuwonabe malo owonjezera mutagwiritsa ntchito fomula, mawuwo amakhala ndi mipata yosasweka. Momwe mungawachotsere, mungaphunzire kuchokera ku chitsanzo ichi.

Gwiritsani ntchito chida cha Pezani ndi Kusintha kuti muchotse mipata yowonjezera pakati pa mawu

Njirayi imafuna ntchito yochepa, koma imakulolani kuchotsa mipata yowonjezera pakati pa mawu. Malo otsogola ndi otsogola adzakonzedwanso kukhala 1, koma osachotsedwa kwathunthu.

1. Sankhani mzere umodzi kapena zingapo za data zomwe mukufuna kuchotsa mipata yowonjezera pakati pa mawu.
2. Press Ctrl + Hkuti mutsegule bokosi la zokambirana Pezani & Sinthani (Pezani ndikusintha).
3. Lowetsani danga kawiri m'munda Pezani Chiyani (Pezani) ndipo kamodzi m'munda Sinthanitsani ndi (Kusinthidwa ndi).
4. atolankhani Bwezerani zonse (Bwezerani Zonse) ndiyeno OKkuti mutseke zenera lazidziwitso lomwe likuwoneka.
5. Bwerezani sitepe 4 mpaka uthenga utawonekera Sitinapeze chomwe chingasinthire ... (Sitinapeze chilichonse chomwe chiyenera kusinthidwa ...).

Chotsani mipata yonse pakati pa manambala

Tiyerekeze kuti muli ndi tebulo lokhala ndi manambala momwe magulu a manambala (zikwi, mamiliyoni, mabiliyoni) amasiyanitsidwa ndi mipata. Pankhaniyi, Excel imagwiritsa ntchito manambala ngati zolemba ndipo palibe masamu omwe angachitike.

Njira yosavuta yochotsera malo owonjezera ndikugwiritsa ntchito chida chokhazikika cha Excel - Pezani & Sinthani (Pezani ndikusintha).

• Press Ctrl+Space (Space) kuti musankhe ma cell onse omwe ali mgululi.
• Press Ctrl + Hkuti mutsegule kukambirana Pezani & Sinthani (Pezani ndikusintha).
• Mu Pezani Chiyani (Pezani) lowetsani danga limodzi. Onetsetsani munda Sinthanitsani ndi (Bwezerani ndi) - opanda kanthu.
• atolankhani Bwezerani zonse (Sinthani Zonse), ndiye OK. Voila! Malo onse achotsedwa.

Chotsani mipata yonse pogwiritsa ntchito fomula

Mutha kuwona kuti ndizothandiza kugwiritsa ntchito fomula kuchotsa mipata yonse. Kuti muchite izi, mutha kupanga gawo lothandizira ndikuyika fomula ili:

=SUBSTITUTE(A1," ","")

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

apa A1 ndi selo loyamba mumzere wokhala ndi manambala kapena mawu, momwe mipata yonse iyenera kuchotsedwa.

Kenako, tsatirani njira zomwe zili mgawo lochotsa mipata yonse pakati pa mawu pogwiritsa ntchito fomula.