Zamkatimu
Dzulo pa marathon 30 Excel imagwira ntchito m'masiku 30 tinakumana ndi mlamu waulesi dzina lake ZINTHU (MALO). Izi sizimagwiritsidwa ntchito nthawi zambiri, koma nazo tidawona momwe operekera atatuwa amagwirira ntchito ku Excel. Tikukhulupirira kuti phunziroli linali lothandiza kwa inu.
Tidzapereka tsiku lachitatu la marathon kuti tiphunzire za ntchitoyi TRIM (TRIM). Mu Januwale, wina akuyesera kutaya mapaundi angapo owonjezera, ndipo chifukwa cha ichi mungagwiritse ntchito Excel kuti mupange chowerengera cha calorie kapena graph yochepetsa thupi mmenemo. Mwatsoka ntchito TRIM (TRIM) sichingakuthandizeni polimbana ndi mapaundi owonjezera, koma imatha kuchotsa malo owonjezera pamzere wamawu.
Chifukwa chake, tiyeni tiwone zidziwitso ndi zitsanzo zakugwiritsa ntchito ntchitoyi TRIM (TRIM) mu Excel. Ngati muli ndi zidule zanu kapena zitsanzo pa ntchitoyi, chonde gawanani nawo mu ndemanga. Ndipo zabwino zonse ndikuwerengera zopatsa mphamvu!
Ntchito 03: TRIM
ntchito TRIM (TRIM) imachotsa mipata yonse pazingwe kupatula mipata imodzi pakati pa mawu.
Kodi mungagwiritse ntchito bwanji TRIM?
ntchito TRIM (TRIM) itha kuthandiza kukonza zolembedwa zomwe zatsitsidwa patsamba kapena zotumizidwa kuchokera ku pulogalamu ina. Ntchito TRIM (TRIM):
- Imachotsa mipata kumayambiriro ndi kumapeto kwa mzere.
- Imachotsa mipata yonse palemba kupatula mipata imodzi pakati pa mawu.
- SIKUCHOTSA zilembo zapadera zokopera patsamba.
TRIM Syntax (TRIM)
Ntchito ya TRIM ili ndi mawu awa:
TRIM(text)
СЖПРОБЕЛЫ(текст)
- text (zolemba) ndizofotokozera za selo kapena zingwe zomwe mukufuna kuchotsamo mipata
TRIM TRAP
ntchito TRIM (TRIM) imangochotsa zilembo zomwe zili mumdanga palemba. Ngati mukukopera zolemba kuchokera patsamba, zitha kukhala ndi zilembo zosadukiza, zomwe zimagwira ntchito TRIM (TRIM) sichingachotsedwe.
Chitsanzo 1: Chotsani mipata kuyambira pachiyambi ndi kumapeto kwa chingwe
Mutha kugwiritsa ntchito TRIM (TRIM) kuti muchotse mipata yonse yotsogola ndi yotsatsira pa chingwe. Pachithunzi chomwe chili pansipa, selo C5 ili ndi malemba okhala ndi mipata iwiri yowonjezera kumayambiriro ndi awiri kumapeto kwa mzere. Ntchito TRIM (TRIM) mu cell C7 imachotsa mipata inayi.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Chitsanzo 2: Chotsani mipata yonse pakati pa mawu
Mutha kugwiritsa ntchito TRIM (TRIM) ku mipata yowonjezera pakati pa mawu omwe ali palembalo. Pachithunzichi, pali mipata itatu yowonjezera pakati pa mawu mu selo C5. Ntchito TRIM (TRIM) mu cell C7 imachotsa mipatayo, kuphatikiza mipata iwiri yowonjezereka kumayambiriro ndi kumapeto kwa zingwezo.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Chitsanzo 3: OSATI kuchotsa zilembo zapadera
ntchito TRIM (TRIM) SIKUCHOTSA zilembo zina zomwe zimagwiritsidwa ntchito ngati mipata. Mwachitsanzo, malo osasweka atha kupezeka m'mawu omwe amakopedwa kuchokera patsamba. Mu chithunzi pansipa, selo C5 ili ndi malo amodzi osasweka, ndipo samachotsedwa.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Mutha kufufuta pamanja mawonekedwe osasokoneza danga pogwiritsa ntchito ntchitoyi WOLEMBEDWA (SUBSTITUTE) kapena macro. Kenako, pa marathon athu 30 Excel imagwira ntchito m'masiku 30Muphunzira njira zingapo zoyeretsera deta mu Excel.
