Maitiro ekubvisa apostrophe muExcel

Imwe yemakiibhodhi ekunyora ndiyo apostrophe, uye muExcel maspredishiti kazhinji inoreva manyorerwo enhamba. Ichi chiratidzo chinowanzoonekwa munzvimbo dzisina kufanira, dambudziko iri rinoitikawo nemamwe mavara kana mavara. Ngationei kuti tingabvisa sei tafura yekuvhiringidza mavara asina maturo.

Maitiro ekubvisa apostrophe inoonekwa muchitokisi

Apostrophe chiratidzo chepunctuation chaiyo, inonyorwa chete mumamiriro ezvinhu chaiwo. Semuenzaniso, inogona kuoneka mumazita chaiwo kana munhamba. Nekudaro, dzimwe nguva vashandisi veExcel vanonyora apostrophes munzvimbo dzisiridzo. Kana paine akawanda akawedzera mavara patafura, unogona kuatsiva nemamwe. Ngationei kuti tingazviita sei mumatanho mashoma ekukurumidza uchishandisa maturusi echirongwa.

1. Sarudza maseru anowanikwa mavara asiri iwo. Pa "Kumba" tab, tsvaga "Tsvaga uye sarudza" bhatani uye tinya pairi.

2. Sarudza chinhu che "Siva" mumenyu inovhura kana kudzvanya makiyi anopisa "Ctrl + H".

3. Bhokisi renhaurirano richavhurika neminda miviri. Mumutsara uri pasi pemusoro unoti "Tsvaga" unoda kuisa chiratidzo chakanyorwa zvisina kururama - munyaya iyi, apostrophe. Isu tinonyora mumutsara "Tsvanura ne" hunhu hutsva. Kana uchingoda kubvisa apostrophe, siya mutsetse wechipiri usina chinhu. Semuyenzaniso, ngatiisirei koma muchikamu che“Siva ne” tobaya bhatani rekuti “Siva Zvose”.

4. Ikozvino mutafura pachinzvimbo cheapostrofi mave nemakoma.

Iwe unogona kutsiva apostrophes kwete papepa rimwe chete, asi mubhuku rose. Dzvanya bhatani re "Sarudzo" mubhokisi rekutsiva dialog - sarudzo nyowani dzichaonekwa. Kuisa munhu mumwe panzvimbo peimwe pamapepa ese egwaro, sarudza iyo "Mubhuku" sarudzo mu "Tsvaga" chinhu uye tinya "Siva Zvese".

Nzira yekubvisa sei asingaoneki apostrophe pamberi petambo

Dzimwe nguva kana uchikopa kukosha kubva kune mamwe mapurogiramu, apostrophe inooneka pamberi penhamba mubhari yeformula. Hunhu uhu hausi muchitokisi. Iyo apostrophe inoratidza chimiro chemavara ezviri mukati mesero - nhamba inoumbwa sechinyorwa, uye izvi zvinokanganisa kuverenga. Mavara akadaro haagone kubviswa nekushandura fomati, zvishandiso Excel kana mabasa. Unofanira kushandisa Visual Basic Editor.

1. Kuvhura iyo Visual Basic yeMaapplication hwindo uchishandisa Alt+F kiyi musanganiswa
2. Mupepeti anowanika muChirungu chete. Isu tinowana pane yepamusoro menyu bha Isa (Isa) uye tinya pane chinhu icho Module (Module).

3. Nyora makro kuti ubvise apostrophe.

Chenjerera! Kana zvisingaite kugadzira macro iwe pachako, shandisa chinyorwa ichi.

4. Sarudza huwandu hwemaseru panowanikwa humwe hunhu, uye tinya kiyi musanganiswa "Alt + F8". Mushure meizvozvo, iyo apostrophes ichanyangarika uye nhamba dzichatora iyo chaiyo fomati.

Kubvisa dzimwe nzvimbo kubva patafura

Nzvimbo dzekuwedzera dzinoiswa mumatafura eExcel kugovera nhamba huru kuita zvikamu kana nekukanganisa. Kana iwe uchiziva kuti kune nzvimbo dzakawandisa mugwaro izvo zvisingafanirwe kuve, shandisa iyo Function Wizard.

1. Sarudza sero yemahara uye vhura iyo Function Manager hwindo. Rondedzero yemafomula inogona kuwanikwa nekudzvanya pa "F (x)" icon padyo neformula bar kana kuburikidza ne "Formulas" tebhu patoiri bhari.

2. Vhura chikamu che "Chinyorwa", chakanyorwa mubhokisi rebhokisi kana pa "Formulas" tab sechikamu chakasiyana. Iwe unofanirwa kusarudza iyo TRIM basa. Mufananidzo unoratidza nzira mbiri.

3. Sero rimwe chete rinogona kuita nharo dzebasa. Isu tinodzvanya pane yatinoda sero, zita rayo rinowira mumutsara wekupokana. Zvadaro, tinya "OK".

4. Tinozadza mitsara yakawanda, kana zvichidiwa. Dzvanya pasero repamusoro panowanikwa fomula uye bata pasi dema square marker mukona yezasi yekurudyi. Sarudza maseru ese kwaunoda kukosha kana mameseji pasina nzvimbo uye sunungura bhatani rembeva.

Zvinokosha! Hazvibviri kujekesa pepa rose rezvimwe nzvimbo, iwe uchafanirwa kushandisa fomula mumakoramu akasiyana nguva imwe neimwe. Kuvhiya kunotora nguva shoma, saka hapazove nekunetseka.

Maitiro ekubvisa asingaoneki akakosha mavara

Kana chimiro chakakosha mumashoko hachiverengeki nepurogiramu, chinofanira kubviswa. Basa reTRIM harishandi mumamiriro ezvinhu akadaro, nokuti nzvimbo yakadaro pakati pemavara haisi nzvimbo, kunyange zvazvo yakafanana zvikuru. Pane nzira mbiri dzekubvisa gwaro kubva kune asingaverengeki mavara. Nzira yekutanga yekubvisa mavara asina kujairika eExcel ndeye kushandisa iyo "Replace" sarudzo.

1. Vhura hwindo rekutsiva kuburikidza nebhatani rekuti "Tsvaga uye sarudza" pane main tab. Chimwe chishandiso chinovhura iyi dialog box ndiyo nzira yekudimbudzira yekhibhodi "Ctrl + H".
2. Kopa mavara asingaverengeki (nzvimbo isina chinhu yavanogara) uye anamira mumutsetse wekutanga. Chikamu chechipiri chinosiiwa chisina chinhu.
3. Dzvanya bhatani re "Replace All" - mavara achanyangarika kubva papepa kana kubva mubhuku rose. Iwe unogona kugadzirisa huwandu mu "Parameters", danho iri rakakurukurwa kare.

Munzira yechipiri, isu zvakare tinoshandisa maficha eFundo Wizard. Semuenzaniso, ngatiisei yekupinda ine mutsara wekutyora mune imwe yemaseru.

1. Chikamu che "Chinyorwa" chine PRINT basa, inobata kune chero mavara asingadhindike. Iwe unofanirwa kuisarudza kubva pakurongwa.

2. Isu tinozadza mundima chete mubhokisi rebhokisi - panofanira kuoneka sero dhizaini uko kune humwe hunhu. Dzvanya bhatani rekuti "OK".

Mamwe mavara haagone kubviswa uchishandisa basa, mumamiriro ezvinhu akadaro zvakakodzera kutendeukira kune anotsiva.

• Kana iwe uchida kuisa chimwe chinhu pachinzvimbo chemavara asingaverengeki, shandisa iyo SUBSTITUTE basa. Iyi nzira inobatsirawo mumamiriro ezvinhu apo kukanganisa kunoitwa mumashoko. Basa racho nderechikamu che "Text".
• Kuti fomula ishande nemazvo, unofanirwa kuzadza nharo nhatu. Chikamu chekutanga chine sero rine mavara anotsiviwa mavara. Mutsara wechipiri wakachengeterwa hunhu hwakatsiviwa, mumutsara wechitatu tinonyora hunhu hutsva kana tsamba. Mazwi mazhinji anodzokorora mavara, saka nharo nhatu hadzina kukwana.

• Nhamba yekuitika inhamba inoratidza kuti ndeupi hunhu hweakawanda akafanana hunofanira kutsiviwa. Muenzaniso unoratidza kuti vara rechipiri rokuti “a” rakatsiviwa, kunyange zvazvo riri mushoko zvakarurama. Ngatinyorei nhamba 1 mundima ye "Nhamba yeChiitiko", uye mhedzisiro ichachinja. Iye zvino unogona kudzvanya OK.

mhedziso

Chinyorwa chakafunga nzira dzese dzekubvisa apostrophe. Kutevera mirairo iri nyore, mushandisi wega wega achakwanisa kubata nebasa pasina matambudziko.