Chotsani ASCII Chikhalidwe # 127 mu Excel

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, malemba 128 oyambirira (0 mpaka 127) a seti ya Unicode ndi ofanana ndi a ASCII.

Zambiri 128 zoyamba za Unicode zimatchulidwa ngati zilembo zoyendetsa ndipo zimagwiritsidwa ntchito ndi mapulogalamu a makompyuta kuti athetse zipangizo zamakono monga osindikiza.

Momwemo, iwo sakuyenera kugwiritsidwa ntchito mu Excel masamba ndipo akhoza kupanga zolakwika zosiyanasiyana ngati alipo. Ntchito yosavuta ya Excel idzachotsa ambiri mwazinthu zosasindikizidwa - kupatula khalidwe # 127.

01 a 03

Unicode Character # 127

Chotsani ASCII Chikhalidwe # 127 kuchokera ku Data mu Excel. © Ted French

Unicode khalidwe # 127 amalamulira fungulo lochotsera pa kibokosi. Momwemo, sikuti cholinga chake chidzakhalapo mu tsamba la Excel.

Ngati lilipo, limasonyezedwa ngati khalidwe lopangidwa ndi bokosi - monga momwe likusonyezedwera mu selo A2 mu chithunzi pamwambapa - ndipo mwinamwake chinatumizidwa kapena kukopera mwangozi pamodzi ndi deta yabwino.

Kukhalapo kwake kungakhale:

02 a 03

Kuchotsa Unicode Character # 127

Ngakhale chikhalidwe ichi sichitha kuchotsedwa ndi NTCHITO yosavuta, ikhoza kuchotsedwa pogwiritsa ntchito fomu yomwe ili ndi ntchito SUBSTITUTE ndi CHAR .

Chitsanzo mu chithunzi pamwambapa chikuwonetsera khalidwe layilo lopangidwa ndi makina pamodzi ndi nambala 10 mu selo A2 ya pepala la Excel.

Ntchito ya LEN - yomwe imawerengetsera chiwerengero cha anthu mu selo - mu selo E2 imasonyeza kuti selo A2 liri ndi zilembo zisanu ndi chimodzi - ziwerengero ziwiri za nambala 10 kuphatikizapo mabokosi anayi a khalidwe # 127.

Chifukwa cha kukhalapo kwa khalidwe # 127 mu selo A2, njira yowonjezera mu selo D2 imabwerera #VALUE! uthenga wolakwika.

Mayi A3 ali ndi ndondomeko ya SUBSTITUTE / CHAR

= SUBSTITUTE (A2, CHAR (127), "")

kuti mutengere zilembo zinayi # 127 kuchokera ku selo A2 popanda kanthu - (zowonetsedwa ndi zizindikiro zopanda kanthu pamapeto a fomu).

Zotsatira zake

  1. chiwerengero cha chiwerengero mu selo E3 chachepetsedwa kukhala awiri - kwa chiwerengero cha chiwerengero cha 10;
  2. Mndandanda wa Kuwonjezera mu selo D3 imabweretsanso yankho lolondola la 15 poonjezera zomwe zili mu selo A3 + B3 (10 + 5).

Ntchito SUBSTITUTE imasintha kwenikweni pamene ntchito ya CHAR imagwiritsidwa ntchito pofotokozera chikhalidwe chimene chikhalidwe chimalowetsera.

03 a 03

Kuchotsa Malo Osasweka Kuchokera Pakompyuta

Zofanana ndi zilembo zosasindikizidwa ndizomwe sizingatheke (& nbsp) zomwe zingayambitsenso mawerengedwe a mavuto ndi kufotokozera pa tsamba. Nambala ya chiwerengero cha Unicode m'malo osasweka ndi # 160.

Malo osasweka amagwiritsidwa ntchito kwambiri m'masamba, kotero ngati deta ikukopedwa ku Excel kuchokera pa tsamba la webusaiti, malo osasweka angasonyeze pa tsamba.

Kuchotsa malo osasweka kungakhoze kupangidwa ndi ndondomeko yomwe imaphatikiza ntchito SUBSTITUTE, CHAR, ndi TRIM.