Momwe mungachotsere apostrophe mu Excel

Chimodzi mwa zizindikiro zopumira za kiyibodi ndi apostrophe, ndipo mu Excel spreadsheets nthawi zambiri amatanthauza mtundu wa manambala. Chizindikirochi nthawi zambiri chimapezeka m'malo osayenera, vutoli limachitikanso ndi zilembo zina kapena zilembo. Tiyeni tiwone momwe tingachotsere tebulo la kusokoneza zilembo zopanda pake.

Momwe mungachotsere apostrophe yowonekera mu cell

Apostrophe ndi chizindikiro chopumira chapadera, chimalembedwa pazochitika zenizeni. Mwachitsanzo, ikhoza kuwoneka m'maina oyenerera kapena m'mawerengero. Komabe, nthawi zina ogwiritsa ntchito Excel amalemba apostrophes m'malo olakwika. Ngati pali zilembo zowonjezera patebulo, mutha kuzisintha ndi zina. Tiyeni tiwone momwe tingachitire munjira zingapo zofulumira pogwiritsa ntchito zida za pulogalamuyi.

1. Sankhani ma cell omwe zilembo zolakwika zili. Pa tabu "Home", pezani batani la "Pezani ndi kusankha" ndikudina.

2. Sankhani "Bwezerani" chinthu mu menyu yomwe imatsegula kapena dinani makiyi otentha "Ctrl + H".

3. Bokosi la zokambirana lidzatsegulidwa ndi magawo awiri. Mu mzere pansi pa mutu wakuti "Pezani" muyenera kulowa chizindikiro cholembedwa molakwika - pamenepa, apostrophe. Timalemba mu mzere "Bwezerani ndi" khalidwe latsopano. Ngati mukufuna kuchotsa apostrophe, siyani mzere wachiwiri wopanda kanthu. Mwachitsanzo, tiyeni tilowe m'malo mwa koma mugawo la "Bwezerani ndi" ndikudina batani la "Bwezerani Zonse".

4. Tsopano mu tebulo m'malo mwa apostrophes pali koma.

Mutha kusintha ma apostrophes osati pa pepala limodzi lokha, komanso m'buku lonse. Dinani batani la "Zosankha" m'bokosi la zokambirana - zosankha zatsopano zidzawonekera. Kuti muyike chilembo chimodzi m'malo mwa china pamapepala onse a chikalatacho, sankhani njira ya "M'buku" mu "Sakani" ndikudina "Bwezerani Zonse".

Momwe mungachotsere apostrophe yosaoneka pamaso pa chingwe

Nthawi zina pokopera zikhalidwe kuchokera ku mapulogalamu ena, apostrophe imawonekera pamaso pa nambala mu bar ya formula. Khalidweli silili muselo. Apostrophe imasonyeza zolemba za zomwe zili mu selo - chiwerengerocho chimapangidwa ngati malemba, ndipo izi zimasokoneza kuwerengera. Makhalidwe otere sangathe kuchotsedwa mwa kusintha mawonekedwe, zida Excel kapena ntchito. Muyenera kugwiritsa ntchito Visual Basic Editor.

1. Kutsegula zenera la Visual Basic for Applications pogwiritsa ntchito makiyi a Alt + F
2. Mkonzi akupezeka mu Chingerezi chokha. Timapeza pa menyu yapamwamba Ikani (Ikani) ndikudina chinthucho Module (Module).

3. Lembani zazikulu kuchotsa apostrophe.

Chenjerani! Ngati sizingatheke kupanga macro nokha, gwiritsani ntchito mawuwa.

4. Sankhani ma cell omwe mawonekedwe owonjezera akuwonekera, ndikusindikiza makiyi "Alt + F8". Pambuyo pake, ma apostrophes adzazimiririka ndipo manambala atenga mawonekedwe oyenera.

Kuchotsa mipata yowonjezera patebulo

Mipata yowonjezera imayikidwa m'matebulo a Excel kuti agawe ziwerengero zazikulu m'magawo kapena molakwitsa. Ngati mukudziwa kuti pali mipata yambiri muzolemba zomwe siziyenera kukhala, gwiritsani ntchito Function Wizard.

1. Sankhani selo laulere ndikutsegula zenera la Function Manager. Mndandanda wa mafomuwo utha kupezeka podina chizindikiro cha "F(x)" pafupi ndi kapamwamba kapena kudzera pa "Mafomula" pagulu lazida.

2. Tsegulani gulu la "Text", lalembedwa m'bokosi la zokambirana kapena pa "Mafomula" tabu ngati gawo losiyana. Muyenera kusankha ntchito ya TRIM. Chithunzicho chikuwonetsa njira ziwiri.

3. Selo limodzi lokha litha kukhala mkangano wantchito. Timadina pa cell yomwe tikufuna, dzina lake lidzagwera pamzere wotsutsana. Kenako, dinani "Chabwino".

4. Timadzaza mizere ingapo, ngati kuli kofunikira. Dinani pa cell yomwe ili pamwamba pomwe njirayo ili ndikuyika chikhomo chakuda mukona yakumanja. Sankhani ma cell onse omwe mukufuna makonda kapena zolemba popanda mipata ndikumasula batani la mbewa.

Zofunika! Sizingatheke kuchotsa pepala lonse la malo owonjezera, muyenera kugwiritsa ntchito ndondomekoyi mumagulu osiyanasiyana nthawi iliyonse. Opaleshoniyo imatenga nthawi pang'ono, kotero sipadzakhala zovuta.

Momwe mungachotsere zilembo zapadera zosawoneka

Ngati chizindikiro chapadera m'mawu sichiwerengedwa ndi pulogalamuyo, chiyenera kuchotsedwa. Ntchito ya TRIM siigwira ntchito ngati izi, chifukwa malo otere pakati pa zilembo si malo, ngakhale ali ofanana kwambiri. Pali njira ziwiri zochotsera chikalata kuchokera ku zilembo zosawerengeka. Njira yoyamba yochotsera zilembo zosadziwika za Excel ndikugwiritsa ntchito njira ya "Replace".

1. Tsegulani zenera lolowa m'malo kudzera pa batani la "Pezani ndikusankha" pa tabu yayikulu. Chida china chomwe chimatsegula bokosi la zokambirana ndi njira yachidule ya kiyibodi "Ctrl + H".
2. Koperani zilembo zosawerengeka (malo opanda kanthu omwe amakhala) ndikuziyika pamzere woyamba. Gawo lachiwiri latsala lopanda kanthu.
3. Dinani batani la "Bwezerani Zonse" - zilembo zidzasowa pa pepala kapena m'buku lonse. Mutha kusintha magawo mu "Parameters", sitepe iyi idakambidwa kale.

Mu njira yachiwiri, timagwiritsanso ntchito mawonekedwe a Function Wizard. Mwachitsanzo, tiyeni tiyike cholowera chokhala ndi mzere woduka mu cell imodzi.

1. Gulu la "Text" lili ndi ntchito ya PRINT, imakhudzidwa ndi zilembo zilizonse zosasindikizidwa. Muyenera kusankha izo pa mndandanda.

2. Timadzaza gawo lokhalo mu bokosi la zokambirana - payenera kuwonekera dzina la cell pomwe pali mawonekedwe owonjezera. Dinani batani "Chabwino".

Zilembo zina sizingachotsedwe pogwiritsa ntchito ntchitoyi, muzochitika zotere ndiyenera kusinthira m'malo.

• Ngati mukufuna kuyika china m'malo mwa zilembo zosawerengeka, gwiritsani ntchito SUBSTITUTE. Njirayi imathandizanso pazochitika zomwe zolakwika zimapangidwira m'mawu. Ntchitoyi ndi ya gulu la "Text".
• Kuti fomulayo igwire bwino ntchito, muyenera kulemba mfundo zitatu. Gawo loyamba lili ndi cell yokhala ndi mawu omwe zilembo zimasinthidwa. Mzere wachiwiri umasungidwa kwa munthu wosinthidwa, mu mzere wachitatu timalemba khalidwe kapena chilembo chatsopano. Mawu ambiri amabwereza zilembo, kotero kuti mfundo zitatu sizokwanira.

• Nambala yochitika ndi nambala yosonyeza kuti ndi ziti zamitundu ingapo yomwe iyenera kusinthidwa. Chitsanzo chikusonyeza kuti chilembo chachiwiri “a” chinalowedwa m’malo, ngakhale kuti chili m’mawu molondola. Tiyeni tilembe nambala 1 mu gawo la "Nambala ya Zochitika", ndipo zotsatira zake zisintha. Tsopano mukhoza dinani Chabwino.

Kutsiliza

Nkhaniyi inafotokoza njira zonse zochotsera apostrophe. Potsatira malangizo osavuta, wogwiritsa ntchito aliyense adzatha kuthana ndi ntchitoyi popanda mavuto.