Maitiro ekudzima hunhu hwekutanga muexcel spreadsheet cell

Kazhinji, vashandisi veExcel spreadsheet editor vanotarisana nebasa rakadaro sekudzima hunhu hwekutanga musero retafura. Iwe unogona kuita iyi nzira uchishandisa nzira dzakasiyana siyana, semuenzaniso, uchishandisa akakosha akabatanidzwa anoshanda. Muchinyorwa ichi, tichafunga zvakadzama, tichishandisa mienzaniso, nzira dzinoverengeka dzinoita kubviswa kwemavara muchitokisi chetabular data.

Delete first character in excel spreadsheet

Kuti uite iyi nzira iri nyore, basa rinokosha rakabatanidzwa rinoshandiswa. Mirayiridzo yakadzama yekubvisa hunhu hwekutanga inoita seizvi:

1. Semuenzaniso, isu tine ndiro yakadaro ine imwe seti yedata pane yebasa regwaro respredishiti. Tinofanira kuita kubviswa kwemunhu wekutanga.

2. Pakutanga, tinofanira kuziva nhamba yose yemavara mumasero ose. Kuti uite chiito ichi, unofanirwa kushandisa DLSTR mushandisi. Basa iri rinokubvumira kuverenga nhamba yemavara. Fambisa chitubu kusero B2 woisarudza nebhatani rekuruboshwe. Pano tinotyaira mune inotevera formula: =DLSTR(A2). Iye zvino tinoda kukopa iyi fomula kumasero ezasi. Fambisa chinongedzo chembeva kukona yekurudyi yemunda B2. Chiratidzo chatora chimiro chediki plus chiratidzo chemumvuri wakasviba. Bata LMB uye dhonza formula kune mamwe maseru.

3. Padanho rinotevera, tinoenderera mberi nekubvisa 1st hunhu kuruboshwe. Kuita maitiro aya, mushandisi anonzi RIGHT anoshandiswa. Fambisa chitubu kusero B2 woisarudza nebhatani rekuruboshwe. Pano tinotyaira mune inotevera formula: =PRAWSIMV(A2;DLSTR(A2)-1). Mune iyi fomula, A2 ndiyo coordination yesero patiri kubvisa hunhu hwekutanga kubva kuruboshwe, uye LT(A2) -1 inhamba yemavara akadzoswa kubva kumagumo emutsara kurudyi.

Iyi nhamba yendima yega yega inoverengerwa nekubvisa hunhu humwe kubva pahuwandu hwehuwandu hwemavara.

4. Iye zvino tinoda kukopa iyi fomula kumasero ezasi. Fambisa chinongedzo chembeva kukona yekurudyi yemunda B2. Chiratidzo chatora chimiro chediki plus chiratidzo chemumvuri wakasviba. Bata LMB uye dhonza formula kune mamwe maseru. Nekuda kweizvozvo, takaita kubviswa kwemunhu wekutanga kuruboshwe kwesero rega rega rakasarudzwa. Ready!

Uyezve, unogona kushandisa akakosha anoshanda anonzi PSTR. Semuenzaniso, isu tine data mumasero ayo nhamba ye serial yevashandi inoratidzwa. Tinofanira kubvisa mavara ekutanga pamberi pekadoti kana nzvimbo. Iyo formula ichaita seizvi: =MID(A:A;TSVAGA(“.”;A:A)+2;DLSTR(A:A)-TSVAGA(“.”;A:A)).

Kubvisa munhu pamberi pemugadziri mupepeti yespredishiti

Pane mamiriro ezvinhu kana zvichidikanwa kudzima mavara kusvika kune imwe hunhu mugwaro respredishiti. Muchiitiko ichi, inotevera fomula iri nyore inoshanda: =REPLACE(A1,TSVAGA(“unhu”,A1),). Mhedzisiro yeshanduko:

• A1 ndiyo munda uri kuongororwa.
• Chimiro chinhu kana ruzivo rwechinyorwa umo sero richachekererwa kuruboshwe.

Uyezve, iyi nzira inogona kusanganiswa nekuchenesa data "Pashure".

Kudzima chimiro pamberi pecomma mupepeti yespredishiti

Pane mamiriro ezvinhu kana zvichidikanwa kubvisa nzvimbo dzedesimali mugwaro respredishiti. Pakadai, inotevera fomula iri nyore inoshanda: =REPLACE(A1;1;TSVAGA(“&”;A1);). Mhedzisiro yeshanduko:

Kubvisa mavara kusvika panzvimbo mupepeti yespredishiti

Pane mamiriro ezvinhu kana zvichidikanwa kudzima mavara kusvika pane imwe nzvimbo mugwaro respredishiti. Muchiitiko ichi, inotevera fomula iri nyore inoshanda: =KUTSVAGA(A1;1;TSVAGA(“&”;A1);). Mhedzisiro yeshanduko:

Kubvisa nemushandisi weSUBSTITUTE

Kubvisa mavara kunogona kuitwa nechirevo chiri nyore chinonzi SUBSTITUTE. Maonero ese emushandisi: =SUBSTITUTE(zvinyorwa, zvekare_zvinyorwa, zvitsva_zvinyorwa, nhamba_yekupinda).

• Chinyorwa - heino ndima ine data inofanira kuchinjwa yakaiswa.
• Old_text ndiyo data inoshanduka.
• New_text - data inozoiswa panzvimbo yepakutanga.
• entry_number igakava rekusarudza. Inokubvumira kutsiva mavara kutanga nenhamba chaiyo.

Semuenzaniso, kana tichida kuita kubviswa kwemapoinzi ari kuruboshwe rwechinyorwa chikuru, saka isu tinofanirwa kuisa inotevera fomula: = SUBSTITUTE(A1;”.”;” “).

Tichishandisa fomula iyi, tinotsiva hunhu hwakapihwa, hwakanyorwa kuruboshwe rwechinyorwa chikuru, nenzvimbo. Iye zvino tinofanira kuita kubviswa kwenzvimbo idzi. Kuita maitiro aya, mushandisi anoshandiswa, ane zita rekuti TRIM. Basa racho rinokubvumira kuti uwane nzvimbo dzisingakoshi uye udzibvise. Maonero ese emushandisi anoita seizvi: =TRIMSPACES().

Zvinokosha! Iyi fomula inobvisa chete nzvimbo dzakajairika. Semuenzaniso, kana mushandisi akawedzera ruzivo rwakakopwa kubva kune imwe saiti kuenda kupepa rebasa, saka rinogona kunge riine nzvimbo, asi mavara akafanana nawo. Muchiitiko ichi, TRIM opareta haashande kudzima. Pano iwe uchada kushandisa Tsvaga uye Bvisa chishandiso.

Kudzima neCLEAN opareta

Sarudzo, unogona kuisa iyo PRINT opareta. Maonero akajairwa emushandisi wekubvisa mavara asingadhindike anoita seizvi: =KUCHENANA(). Iri basa rinobvisa mavara asina kudhinda mumutsara (kutsemuka kwemitsara, mavara endima, masikweya akasiyana, zvichingodaro). Iyo opareta inodiwa mumamiriro ezvinhu apo inodiwa kuita kubviswa kwetambo yekutyora.

Zvinokosha! Mushandi anobvisa chete akawanda emamwe mavara.

Mhedziso nemhedziso pamusoro pekubviswa kwevatambi vekutanga

Taona nzira dzekubvisa hunhu hwekutanga kubva muruzivo rwetabular. Nzira dzinoreva kushandiswa kwevashandisi vakabatanidzwa. Kushandisa mabasa kunobvumira iwe kumhanyisa zvakanyanya maitiro ekushanda nehuwandu hukuru hwetabular ruzivo.