MSExcel: Nzira yekuwana sei chinzvimbo chemunhu patambo?

Excel tsvaga chinzvimbo chemunhu mu tambo

Kutsvaga chinzvimbo chemunhu mu tambo kunogona kuva nyore kwazvo kushanda mu MSExcel, nekushandisa inoenderana yakavakirwa-basa GADZIRA.

Excel tsvaga chimiro chinzvimbo mune tambo uye inobvisa substring

Semuenzaniso, ngatitaurei kuti tine zvinyorwa zvemazita uye mazita emafaira, uye tinongoda kuwana mhedzisiro yekupedzisira nemazita faira.

Muchiitiko ichocho, kunyangwe vlookup remberi muExcel raisabatsira, sezvo raisatendera kuburitsa chero ruzivo kubva kuhukuru tambo.

Mhinduro yakanakisa ndeyokushandisa basa GADZIRA kuti uwane chinzvimbo chomunhu tambo, uye shandisa nhamba iyi kubvisa iyo tambo yakasara uchishandisa iyo MID basa muExcel.

Tsvaga chinzvimbo chehunhu muExcel tambo

Kuti uwane chinzvimbo chemutambi wakapihwa muExcel, ingoshandisa basa rinoti GADZIRA patambo, uchipa se parameter iyo hunhu hwekuwana uye tambo yaunofanira kutsvaga, semuenzaniso uchireva kune imwe sitokisi iri muExcel spreadsheet .

'=FIND("char",”string”)

Bvisa tambo kubva pane hunhu

Wobva washandisa ruzivo rwechimiro chechimiro, shandisa basa MID kuti ubvise tambo inodikanwa uchitanga mushure mechi yakawanikwa nekuwedzera +1, uye uchibvisa tambo yacho yese uchishandisa tambo kureba zvakakwana, senge 999, kuti kuve nechokwadi chekuvhara iyo mhedzisiro yose.

'=MID(“string”,”char”+1,999)

Excel bvisa zvinyorwa pamberi pehunhu

Kubvisa zvinyorwa pamberi pemutambi akapihwa muExcel, ingo tsvaga chimiro, uye shandisa LEFT basa nemutambi mumwe chete kuburitsa rugwaro pamberi pehunhu hwawanikwa.

'=LEFT(“string”,”char”-1)

Tsvaga nth kuitika kwehunhu mune tambo kupfuura

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Kutsvaga iko zvinoitika chechimiro mu tambo muExcel kunoitwa nekushandisa iyo miviri mabasa GADZIRA uye SUBSTITUTE.

I SUBSTITUTE basa rinotsiva rakakumbirwa nth chiitiko chewakatsvaga hunhu neakakosha, uye basa rekuti GADZIRA rinowana chinzvimbo chehunyanzvi hunhu mudambo.

Kungosarudza nth chiitiko chekutarisa mu tambo yakapihwa, uye mhedzisiro yacho inozoratidzwa ichiratidza kuitika kwe nth mumutambo.

'=FIND(CHAR(1),SUBSTITUTE(“string”,”char”,CHAR(1),nth))

Excel tsvaga chinzvimbo chemunhu mu tambo from right

Kuti uwane chinzvimbo chemunhu tambo kubva kurudyi, isu tinoshandisa solutioj yakafanana tichishandisa GADZIRA uye SUBSTITUTE kuwana kwekupedzisira kuitika kweye munhu akapihwa tambo.

Nemhinduro iyi, chinzvimbo chekupedzisira chemunhu patambo, chino zvakare chinzvimbo chemunhu tambo kubva kurudyi, chinozoratidzwa.

'=FIND(CHAR(1),SUBSTITUTE(“string”,”char”,CHAR(1),LEN(A2)-LEN(SUBSTITUTE(“string”,”char”,""))),1)

Mibvunzo Inowanzo Bvunzwa

Ndeipi formula inogona kushandiswa muExcel kuti izive chinzvimbo chehunhu mukati me tambo yemavara, kubatsira mukunyengera kwedata uye kuongororwa?

Shandisa iyo `Tsvaga` kana` yekutsvaga` basa muExcel kuti uwane chinzvimbo chehunhu mukati me tambo. Iyo formula inoratidzika kunge `= tsvaga ( hunhu , cell_reference) Chinja ` hunhu ` nehunhu hwauri kutsvaga uye `cell_reference` ne sero rine zvinyorwa.

Zadzisa 2019 Excel yeVatanga mune vhidhiyo