Yi amfani da aikin CLEAN don cire adadin takardun kwamfuta wanda ba a iya bugawa ba wanda aka kofe ko kuma shigo da shi a cikin takardun aiki tare da bayanan mai kyau.
Wannan ƙananan lambar code ana samuwa a farkon da / ko ƙare fayilolin bayanai.
Wasu samfurori na yau da kullum na wadannan haruffan ba a bugawa su ne haruffan da aka haɗu tare da rubutun a cikin misalai a cikin kwayoyin A2 da A6 a cikin hoton da ke sama.
Wadannan haruffa zasu iya tsangwamar da yin amfani da bayanai a ayyukan ayyukan aiki kamar bugawa, rarraba, da kuma tace bayanai.
Cire Halin Kwafin Kayan da ba a Bugawa da kuma Unicode Characters tare da CLEAN Function
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, haruffa 32 na farko (0 zuwa 31) na Ƙungiyar Unicode da ASCII suna da alaƙa kuma an kira su a matsayin haruffa masu amfani da shirye-shiryen don sarrafa na'urori na zamani kamar masu bugawa.
Saboda haka, ba a yi amfani da su ba don amfani a cikin takardun aiki kuma zai iya haifar da wasu kurakurai da aka ambata a sama a yayin da suke.
Ayyukan CLEAN, wanda ke ƙaddamar da sakon layin Unicode, an tsara shi don cire rubutun farko na 32 wanda ba a buga rubutun ASCII ba kuma ya kawar da wannan haruffan daga cikin Unicode.
Hanyoyin aikin CLEAN da maganganu
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin aikin CLEAN shine:
= CLEAN (Rubutu)
Rubutu - (da ake buƙatar) bayanan da za a tsaftace daga rubutun da ba a bugawa ba. Sakamakon tantancewar salula ga wurin da wannan bayanan ke cikin aikin aiki.
Alal misali, don tsaftace bayanai a cikin salula A2 a cikin hoton da ke sama, shigar da dabara:
= CLEAN (A2)
cikin wani siginar aiki.
Lambobin tsaftacewa
Idan aka yi amfani da shi don tsaftace bayanan lamba, aikin CLEAN, baya ga cire duk wani rubutun da ba a buga ba, zai canza dukkan lambobi zuwa rubutu - wanda zai iya haifar da kurakurai idan ana amfani da wannan bayanan a lissafi.
Misalan: Cire Mujallar Ɗawuwar Batu
A cikin sashi A a cikin hoton, ana amfani da aikin CHAR don ƙara rubutun da ba a buga ba zuwa rubutun kalmomin kamar yadda aka nuna a cikin maɓallin tsari a sama da aikin aiki na cell A3 wanda aka cire tare da aikin CLEAN.
A cikin ginshiƙai B da C na hoton da ke sama, aikin LEN, wanda ya ƙidaya yawan adadin haruffa a cikin tantanin halitta, ana amfani dashi don nuna sakamakon yin amfani da aikin CLEAN akan bayanai a shafi na A.
Halin halin mutum na B2 yana 7 - haruffan hudu don kalman kalma da uku don abubuwan da ba a buga ba a ciki.
Halin halin kirki a C2 C 4 ne saboda aikin CLEAN an kara da shi a cikin tsari kuma ya cire kayan haruffa uku ba tare da bugu ba kafin aikin LEN ya ƙididdige haruffa.
Ana cire 'Yan wasa # 129, # 141, # 143, # 144, da # 157
Ƙungiyar haɗin Unicode yana ƙunshe da wasu baƙon rubutun da ba a samo su ba a cikin jerin halayen ASCII - lambobi 129, 141, 143, 144, da 157.
Ko da yake shafin yanar gizon na Excel ya ce ba zai iya ba, aikin CLEAN zai iya cire waɗannan haruffan Unicode daga bayanai kamar yadda aka nuna a jere uku a sama.
A cikin wannan misali, aikin CLEAN a shafi na C ana amfani da shi don yada waɗannan magunguna guda biyar wadanda ba a iya ganin su ba har yanzu sun sake ba da lissafi na mutum guda hudu kawai don kalman kalmar C3.
Cire Ayyuka # 127
Akwai wani abu wanda ba a buga a cikin Unicode ba cewa aikin CLEAN ba zai iya cirewa - nau'in nau'i mai siffar nau'i na X 127 ba a cell A4, inda hudu daga cikin waɗannan haruffa suna kewaye da rubutun kalmomin .
Halin halin mutum takwas a cell C4 yana daidai da cewa a cikin sakonni B4 kuma saboda aikin CLEAN a C4 yana ƙoƙarin ƙoƙarin cire # 127 a kansa.
Duk da haka, kamar yadda aka nuna a cikin layuka biyar da shida a sama, akwai wasu matakai masu amfani ta yin amfani da ayyukan CHAR da ayyukan SUBSTITUTE wanda za'a iya amfani da su don cire wannan hali:
- Maganin a jere biyar yana amfani da SUBSTITUTE da CHAR don maye gurbin hali # 127 tare da hali wanda aikin CLEAN zai iya cirewa-a cikin wannan yanayin, halin # 7 (ɗigon baki wanda aka gani a cell A2);
- Maganin a jere na shida yana amfani da ayyukan SUBSTITUTE da CHAR don maye gurbin hali # 127 tare da kome ba kamar yadda aka nuna ta alamomi maras kyau ( "" ) a ƙarshen dabarar a cell D6. A sakamakon haka, ba a buƙatar aikin CLEAN a cikin wannan tsari ba, saboda babu wani hali don cirewa.
Ana cire Wuraren Ƙasashen Waje daga Fayil ɗin
Hakazalika da haruffan da ba a bugawa ba shine wuri marar ɓatawa wanda zai iya haifar da matsaloli tare da lissafi da tsarawa a cikin takardun aiki. Ƙimar Unicode ga wuri marar ɓatawa shine # 160.
Ba a yi amfani da sararin samaniya ba a cikin shafukan yanar gizo - html code don shi & nbsp; - don haka idan an kwafa bayanan a cikin Excel daga shafin yanar gizon, za'a iya haɗa wuraren da ba a karya ba.
Ɗaya hanyar da za a cire ƙananan wurare daga ɗawainiyar aiki tare da wannan tsari wanda ya ƙunshi ayyukan SUBSTITUTE, CHAR, da TRIM.