Phunzirani momwe Mungachotse Malo Owonjezera kuchokera ku Excel

Pangani sewero lanu liwoneke bwino komanso labwino

Pamene deta yanu imatumizidwa kapena kukopedwa mu Excel pamapangidwe ena owonjezera nthawi zina akhoza kuphatikizidwa pamodzi ndi deta. Ntchito TRIM ingagwiritsidwe ntchito kuchotsa malo owonjezera kuchokera pakati pa mawu kapena masalimo ena a Excel - monga momwe akusonyezera mu selo A6 mu chithunzi pamwambapa.

Ntchitoyo imafuna, ngakhalebe, kuti deta yapachiyambi ikhalebe kwinakwake pokhapokha ngati ntchitoyo ikutha.

Kawirikawiri, ndibwino kusunga deta yapachiyambi. Ikhoza kubisika kapena ili pa tsamba lina lamasewera kuti lisatulukidwe.

Kugwiritsira ntchito Makhalidwe Achidindo ndi Ntchito TRIM

Ngati, ngakhale, malemba oyambirira sakufunikiranso, Excel adasankha machitidwe abwino amachititsa kuti athe kusunga malemba pomwe akuchotsa deta yapachiyambi ndi ntchito TRIM.

Momwe izi zimagwirira ntchito, monga momwe tafotokozera m'munsimu, ndikuti malingaliro amtunduwu amagwiritsidwa ntchito kusonkhanitsa ntchito ya TRIM kuchokera pamwamba pa deta yapachiyambi kapena malo ena onse omwe mukufuna.

Syntax ndi Opangana za TRIM Function

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya TRIM ndi:

= TRIM (Ndemanga)

Malemba - deta yomwe mukufuna kuchotsa malo. Mtsutso uwu ukhoza kukhala:

• deta yeniyeni yomwe ili mkati mwa zizindikiro za ndemanga.
• selo lotanthauzira kwa malo a zolemba deta mu tsamba la ntchito.

Chitsanzo cha ntchito TRIM

Mu chithunzi pamwambapa, ntchito ya TRIM - yomwe ili mu selo A6 - imagwiritsidwa ntchito kuchotsa mipata yowonjezera kuchokera kutsogolo ndi pakati pa deta yomwe ili mu selo A4 ya tsamba.

Ntchitoyi imachokera ku A6 kenako imakopedwa ndi kuyikidwa - pogwiritsira ntchito phindu - kubwerera ku selo A4. Kuchita kotero kumapereka kabuku lenileni la zomwe zili mu A6 mu selo A4 koma popanda ntchito TRIM.

Gawo lomaliza liyenera kuchotsa ntchito TRIM mu selo A6 kusiya malemba omwe asinthidwa mu selo A4.

Kulowa Ntchito ya TRIM

Zosankha zogwira ntchito ndi ndemanga zake zikuphatikizapo:

1. Kujambula ntchito yonse: = TRIM (A4) mu selo A6.
2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito TRIM ntchito dialog box.

Masitepewa pansipa agwiritse ntchito TRIM function dialog box kuti alowe ntchito mu selo A6 pa tsamba.

1. Dinani pa selo A6 kuti mupange selo yogwira ntchito - apa ndi kumene ntchitoyi idzapezeka.
2. Dinani pa Fomu tab ya menyu yowonjezera.
3. Sankhani Mawu kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi.
4. Dinani pa TRIM m'ndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
5. Mu bokosi la bokosi, dinani palemba mzere.
6. Dinani pa selo A4 mu tsamba lothandizira kuti mulowetse selolo monga magwiridwe a ntchito.
7. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.
8. Mzere wa malemba Chotsani Zowonjezera kuchokera Pakati pa Mawu kapena Malemba ziyenera kuoneka mu selo A6, koma ndi danga limodzi lokha pakati pa mawu aliwonse.
9. Ngati inu mutsegula pa selo A6 ntchito yonse = TRIM (A4) ikuwonekera pazenera yapamwamba pamwamba pa tsamba.

Kupatula Zomwe Zachiyambi Zina ndi Makhalidwe Abwino

Zochitika kuchotsa deta yapachiyambi ndipo potsiriza TRIM ikugwira ntchito mu selo A6:

1. Dinani pa selo A6.
2. Dinani makiyi a Ctrl + c pa kibokosilo kapena dinani Koperani Pakhomo la Tsamba lachitsulo - deta yosankhidwa idzazunguliridwa ndi Antsamba Oyendayenda.
3. Dinani pa selo A4 - malo a deta yapachiyambi.
4. Dinani pamsana wawung'ono pansi pa batani loyika Pakhomo la Home la Ribbon kuti mutsegule Zosakaniza Zokonda pansi.
5. Dinani pazomwe mungasankhe pazinthu zowonongeka - monga momwe zasonyezedwera pa chithunzi pamwambapa - kusindikiza malemba omwe asinthidwa kubwerera ku selo A4.
6. Chotsani ntchito TRIM mu selo A6 - kusiya data yokhayokha mu selo yapachiyambi.

Ngati Ntchito ya TRIM Ikusagwira Ntchito

Pa kompyutayi, danga pakati pa mawu silochabechabe dera koma khalidwe, ndipo, kulikhulupirira kapena ayi, pali mtundu umodzi wokhala ndi malo.

Ntchito TRIM sidachotsa anthu onse. Makamaka, malo omwe amagwiritsidwa ntchito mobwerezabwereza omwe TRIM sadzachotsa ndi malo osasweka () omwe amagwiritsidwa ntchito m'masamba a intaneti.

Ngati muli ndi deta yamtaneti ndi malo ena omwe TRIM sangathe kuchotsa, yesani ntchito iyi TRIM njira yothetsera vuto.