Mukati
Nezuro mumarathon 30 Excel inoshanda mumazuva makumi matatu takasangana nemukwasha ane usimbe ainzi NZIRA (NZVIMBO). Iri basa hariwanzo shandiswa mukuita, asi naro takaona mashandiro anoita matatu mareferenzi anoshanda muExcel. Ndinovimba iyi tutorial yakakubatsira iwe.
Tichapa zuva rechitatu remarathon pakudzidza kwebasa racho TRIM (TRIM). Muna Ndira, mumwe munhu ari kuedza kurasikirwa nemapaundi mashoma, uye nekuda kweichi chinangwa unogona kushandisa Excel kugadzira calorie counter kana uremu girafu mairi. Zvinosuruvarisa basa TRIM (TRIM) haizokubatsira mukurwisa mamwe mapaundi, asi inogona kubvisa dzimwe nzvimbo kubva pamutsetse wemavara.
Saka ngatitarisei ruzivo rwereferenzi uye mienzaniso yekushandisa basa TRIM (TRIM) muExcel. Kana iwe uine ako ega manomano kana mienzaniso pane iri basa, ndapota ugovane ivo mune zvakataurwa. Uye rombo rakanaka nekuverenga macalorie!
Basa 03: TRIM
basa TRIM (TRIM) inobvisa nzvimbo dzese kubva patambo yemavara kunze kwenzvimbo imwechete pakati pemazwi.
Unogona sei kushandisa iyo TRIM basa?
basa TRIM (TRIM) inogona kubatsira kuchenesa zvinyorwa zvakatorwa kubva pawebhusaiti kana kutorwa kunze kwenyika kubva kune imwe application. Function TRIM (TRIM):
- Inobvisa nzvimbo kwekutanga nekupera kwemutsara.
- Inobvisa nzvimbo dzese kubva pane zvinyorwa kunze kwenzvimbo imwechete pakati pemazwi.
- HASI kubvisa mamwe mavara akakosha akakopwa kubva pawebhusaiti.
TRIM Syntax (TRIM)
Basa reTRIM rine zvinotevera syntax:
TRIM(text)
СЖПРОБЕЛЫ(текст)
- text (chinyorwa) ireferensi sero kana tambo yemavara yaunoda kubvisa nzvimbo
TRIM TRAP
basa TRIM (TRIM) inobvisa chete mavara epanzvimbo pamavara. Kana iwe uri kukopa zvinyorwa kubva pawebhusaiti, inogona kunge iine isina-kupaza nzvimbo mavara, ayo anoshanda TRIM (TRIM) haigone kudzimwa.
Muenzaniso 1: Bvisa nzvimbo kubva pakutanga uye kumagumo kwetambo yemavara
Unogona kushandisa basa TRIM (TRIM) kubvisa ese anotungamira uye anoteedzera nzvimbo kubva kune yemavara tambo. Mumufananidzo uri pazasi, sero C5 ine zvinyorwa zvine nzvimbo mbiri dzekuwedzera pakutanga uye mbiri pamagumo emutsara. Function TRIM (TRIM) muchitokisi C7 inobvisa iyo 4 nzvimbo dzekuwedzera.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Muenzaniso 2: Bvisa zvese kunze kwenzvimbo imwechete pakati pemazwi
Unogona kushandisa basa TRIM (TRIM) kune dzimwe nzvimbo pakati pemazwi ari muchinyorwa. Mumufananidzo uri pazasi, pane dzimwe nzvimbo nhatu dzekuwedzera pakati pemazwi muchitokisi C5. Function TRIM (TRIM) muchitokisi C7 inobvisa nzvimbo idzodzo, pamwe nenzvimbo mbiri dzekuwedzera pakutanga nekupera kwetambo yemavara.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Muenzaniso 3: USATI sei kubvisa mamwe mavara akakosha
basa TRIM (TRIM) HAISI kubvisa mamwe mavara anoshandiswa senzvimbo. Semuenzaniso, nzvimbo isina-kutyora ingangove iripo mune zvinyorwa zvakakopwa kubva pawebhusaiti. Mumufananidzo uri pazasi, sero C5 ine imwe isina-kupwanya nzvimbo, uye haina kubviswa.
=TRIM(C5)
=СЖПРОБЕЛЫ(C5)
Iwe unogona kudzima iyo isiri-kupaza nzvimbo hunhu nemaoko uchishandisa basa SUBSTITUTE (SUBSTITUTE) kana macro. Gare gare, panguva yedu marathon 30 Excel inoshanda mumazuva makumi matatuIwe uchadzidza dzimwe nzira shoma dzekuchenesa data muExcel.
