Kowace hali a kwamfuta - wanda aka buga kuma wanda ba a iya bugawa - yana da lambar da aka sani da lambar haɗin Unicode ko darajarta.
Wani kuma, tsofaffi, kuma mafi ƙarancin halayen halayen shi ne ASCII , wadda take tsaye ga Ƙarin Maɓallin Ƙamus na Amurka , wanda aka kafa a cikin Unicode. A sakamakon haka, na farko characters 128 (0 zuwa 127) na Unicode saita yana da kama da ASCII saita.
Yawancin farko na haruffan Unicode na 128 an kira su haruffan sarrafawa kuma ana amfani da su don shirye-shiryen kwamfyuta don sarrafa na'urorin haɗi kamar masu wallafa.
Saboda haka, ba a nufin su yi amfani da su a cikin takardun aiki na Excel kuma zasu iya haifar da kurakurai daban-daban idan sun kasance. Ayyukan Excel ta CLEAN zai cire mafi yawan waɗannan rubutun da ba a buga ba - banda galibi na # 127.
01 na 03
Unicode Character # 127
Kalmomin Unicode # 127 yana sarrafa maɓallin sharewa akan keyboard. Saboda haka, ba a yi nufin kasancewa a cikin takardar aikin Excel ba.
Idan akwai, an nuna shi azaman nau'i mai nau'i mai nau'in akwatin - kamar yadda aka nuna a cikin cell A2 a cikin hoton da ke sama - kuma ana iya shigo ko kofe shi ba zato ba tsammani tare da wasu bayanai mai kyau.
Hannunsa na iya:
- haifar da matsaloli masu mahimmanci a cikin takardun aiki;
- shafi tasiri da kuma tace bayanai;
- haifar da matsalolin lissafi idan sun kasance a cikin tantanin halitta tare da bayanan da aka yi amfani dashi a cikin wani tsari .
02 na 03
Ana cire Unicode Yanayi # 127
Ko da yake wannan hali baza a iya cirewa tare da aikin CLEAN ba, ana iya cire shi ta amfani da tsari wanda ya ƙunshi ayyukan SUBSTITUTE da CHAR .
Misali a cikin hoton da ke sama yana nuna nau'in nau'i-nau'in nau'i-nau'i-nau'i hudu tare da lamba 10 a cikin cell A2 na takardar aiki na Excel.
Ayyukan LEN - wanda ya ƙidaya adadin haruffan a cikin tantanin halitta - a cikin cell E2 ya nuna cewa cell A2 yana ƙunshe da haruffa shida - lambobi biyu na lamba 10 da akwatunan huɗu don nau'in # 127.
Dangane da halin hali na # 127 a cikin salula A2, ƙarin buƙatu a cikin cell D2 ya dawo #VALUE! saƙon kuskure.
Cell A3 yana ƙunshe da takaddun SUBSTITUTE / CHAR
= SUBSTITUTE (A2, CHAR (127), "")don maye gurbin kalmomi huɗu na 127 daga cell A2 ba tare da komai ba - (wanda aka nuna ta alamar zane a ƙarshen dabara).
Saboda
- halin kirki a cikin cell E3 an rage zuwa biyu - na lambobi biyu a lamba 10;
- Bugu da ƙari a cikin cell D3 ya dawo amsar daidai ta 15 lokacin daɗa abun ciki don cell A3 + B3 (10 + 5).
Ayyukan SUBSTITUTE na ainihin maye gurbin yayin da ake amfani da aikin CHAR don gaya ma'anar abin da hali zai maye gurbin.
03 na 03
Ana cire Wuraren Ƙasashen Waje daga Fayil ɗin
Hakazalika da haruffan da ba a bugawa ba shine wuri marar karya (& nbsp) wanda zai iya haifar da matsaloli tare da lissafi da kuma tsarawa a cikin takardun aiki. Lambar lambar Unicode don wuraren da ba a karya ba shine # 160.
Ana amfani da wuraren da ba a karya a shafukan yanar gizo ba, don haka idan an kwafi bayanai zuwa Excel daga shafin yanar gizon, wurare marar karya zasu iya nunawa a cikin takarda.
Ana kawar da wuraren da ba a karya ba tare da wata hanyar da ta haɗu da ayyukan SUBSTITUTE, CHAR, da TRIM.