Gwiritsani ntchito ntchito YOLEMBEDWA kuchotsa makina osakanikizidwa omwe sali osindikizidwa omwe adakopizidwa kapena kulowetsedwa mu tsamba limodzi ndi deta yabwino.
Chotsatira ichi chazomwe zimapezeka kawirikawiri kumayambiriro ndi / kapena kutha kwa mafayilo a deta.
Zitsanzo zina zodziwika za malembo osasindikizidwa ndi malemba omwe amasakanizidwa ndi malemba mu zitsanzo m'maselo A2 ndi A6 mu chithunzi pamwambapa.
Zithunzizi zingathe kulepheretsa kugwiritsa ntchito deta pamakina opangira mapepala monga kusindikiza, kusankha, ndi kufotokoza deta.
Chotsani ASCII Osasindikizidwa ndi Anthu Omwe Amagwiritsa Ntchito Unicode ndi Ntchito YOFUNIKA
Chikhalidwe chilichonse pamakompyuta - chosindikizidwa ndi chosasindikizidwa - chiri ndi nambala yodziwika ngati code yake ya unicode kapena mtengo wake.
Chikhalidwe china, chokalamba, ndi chodziwika bwino ndicho ASCII, chomwe chimaimira American Standard Code for Interchange Information, chaphatikizidwa mu Unicode.
Zotsatira zake, zilembo 32 zoyambirira (0 mpaka 31) za seti la Unicode ndi ASCII ndizofanana ndipo zimatchulidwa kuti zilembo zomwe zimagwiritsidwa ntchito ndi mapulogalamu oletsa zipangizo zamakono monga osindikiza.
Zomwe zili choncho, sizikuyenera kugwiritsidwa ntchito pazenera ndipo zingayambitse zolakwika zomwe tatchulidwa pamwambapa.
Ntchito YOFUNIKA, yomwe inatsogoleredwa ndi Unicode, imakonzedwa kuchotsa zolemba 32 zoyambirira zosasindikiza ASCII ndikuchotsa zofanana zomwezo kuchokera ku Unicode.
Syntax ndi Zokambirana Zowoneka bwino
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Mawu omasulidwa a ntchito yovuta ndi:
= YOTSATIRA (Malemba)
Malembo - (oyenerera) deta yoyeretsedwa yosasindikizidwa. Selo lofotokozera malo a deta iyi mu worksheet.
Mwachitsanzo, kuyeretsa deta mu selo A2 mu chithunzi pamwambapa, lowetsani ndondomekoyi:
= YOTSATIRA (A2)
mu selo lina lamasewera.
Kusamba Numeri
Ngati ntchito yosintha chiwerengero, ntchito YOSACHITIKA, kuphatikizapo kuchotsa maina onse osasindikiza, idzasintha manambala onse mpaka malemba - zomwe zingapangitse zolakwika ngati deta ikugwiritsidwa ntchito powerengera.
Zitsanzo: Kuchotsa Zithunzi Zosasinthika
Mu chithunzi A mu chithunzi, ntchito ya CHAR yakhala ikugwiritsidwa ntchito kuwonjezera malemba osasindikiza ku mawu a mawu monga momwe amasonyezera mu barra ya fomula pamwamba pa tsamba la ntchito ya selo A3 yomwe imachotsedwa ndi ntchito YOLEMBEDWA.
Muzitsulo B ndi C za chithunzi pamwambapa, ntchito ya LEN, yomwe imawerengetsera chiwerengero cha anthu omwe ali mu selo, imagwiritsidwa ntchito kusonyeza zotsatira za ntchito YOYERA pa deta A.
Chikhalidwecho chikuwerengera selo B2 ndi 7 - zilembo zinayi za mawu ndi zitatu kwa malemba osasindikiza ozungulira.
Chikhalidwecho chimawerengedwa mu selo C2 ndi 4 chifukwa ntchito YOLEMBEDWA yawonjezeredwa pa njirayi ndipo imachotsapo malemba atatu omwe osasindikiza asanayambe kugwira ntchito ya LEN.
Kuchotsa Makhalidwe # 129, # 141, # 143, # 144, ndi # 157
Chikhalidwe cha Unicode chili ndi zina zomwe sizinasindikizidwe zomwe sizipezeka mu chikhalidwe cha ASCII - nambala 129, 141, 143, 144, ndi 157.
Ngakhale webusaiti ya Excel yothandizira ikunena kuti sizingatheke, ntchito YOSUNGA ikhoza kuchotsa zilembo za Unicode kuchokera pa data monga momwe ziliri mzere wachitatu pamwambapa.
Mu chitsanzo ichi, ntchito YOYERA mu chigawo C imagwiritsidwa ntchito kuchotsa awa asanu omwe sakuwoneka olamulira akutsanso chiwerengero cha chiwerengero cha zinayi zokha za mawu mu C3.
Kuchotsa Makhalidwe # 127
Pali chikhalidwe chimodzi chosasindikiza mu seti ya Unicode yomwe ntchito YOSIYANA sangathe kuchotsa - chiboliboli chofanana ndi bokosi # 127 chomwe chikuwonetsedwa mu selo A4, kumene olemba anayi akuzungulira mawu.
Chikhalidwe choposa asanu ndi atatu mu selo C4 ndi chimodzimodzi ndi selo B4 ndipo chifukwa CLEAN ntchito C4 akuyesa kupambana kuchotsa # 127 yekha.
Komabe, monga momwe tawonetsera m'mizere isanu ndi isanu ndi umodzi pamwambapa, pali njira zina zogwiritsira ntchito ntchito za CHAR ndi SUBSTITUTE zomwe zingagwiritsidwe ntchito kuchotsa khalidwe ili:
- Mndandanda wa mzere wachisanu umagwiritsa ntchito SUBSTITUTE ndi CHAR kuti mutengere khalidwe # # 127 ndi khalidwe lomwe CLEAN ntchito ingakhoze kuchotsa-mu nkhaniyi, khalidwe # 7 (dot dot wakuwonetsedwa mu selo A2);
- Mndandanda wa mzere wachisanu ndi chimodzi umagwiritsa ntchito SUBSTITUTE ndi CHAR kugwira ntchito m'malo mwa munthu # 127 popanda kanthu monga momwe amasonyezera ndi ndondomeko zopanda kanthu ( "" ) kumapeto kwa njirayi mu selo D6. Chotsatira chake, ntchito YOSUNGA sichifunika mu njirayi, popeza palibe khalidwe lochotsamo.
Kuchotsa Malo Osasweka Kuchokera Pakompyuta
Zofanana ndi zilembo zosasindikizidwa ndi malo osasweka omwe angayambitsenso mawerengedwe a mavuto ndi kufotokozera pa tsamba. Mtengo wa Unicode wosasweka ndi # 160.
Malo osasweka amagwiritsidwa ntchito kwambiri m'masamba - html code for it & nbsp; - kotero ngati deta ikukopedwa ku Excel kuchokera pa tsamba la intaneti, malo osasweka angaphatikizidwe.
Njira imodzi yochotsera malo osasunthika kuchokera pa tsambali ndi iyiyi yomwe ikuphatikiza ntchito SUBSTITUTE, CHAR, ndi TRIM.