Yuav ua li cas Siv Excel's Clean Function

Cov txheej txheem:

2024 Tus sau: Abigail Brown | [email protected]. Kawg hloov kho: 2023-12-17 06:49

Yuav Paub

Tom tshem cov cim ASCII, sau =CLEAN(Text).
Siv SUBSTITUTE muaj nuj nqi los hloov cov cim Unicode rau hauv cov cim ASCII.

Ntawm no yog yuav ua li cas siv Clean ua haujlwm hauv Microsoft Excel 2019, 2016, 2013, 2010, thiab Excel rau Microsoft 365. Cov haujlwm huv huv tshem tawm ntau cov cim hauv computer uas tsis tau luam tawm. los yog import rau hauv daim ntawv ua haujlwm vim tias cov cim no tuaj yeem cuam tshuam rau kev luam ntawv, txheeb xyuas, thiab lim cov ntaub ntawv.

CLEAN Function Syntax thiab Arguments

Ib txoj haujlwm syntax yog nws qhov layout thiab suav nrog lub npe, brackets, thiab kev sib cav. Lub syntax rau CLEAN muaj nuj nqi yog:

=CLEAN(Text)

Text

(yuav tsum tau) yog

cell reference

rau qhov chaw ntawm cov ntaub ntawv no hauv daim ntawv koj xav ntxuav.

Piv txwv, hais cell A2 muaj cov qauv no:

=CHAR(10)&"Calendar"&CHAR(9)

Txhawm rau ntxuav qhov ntawd, koj yuav nkag mus rau cov qauv rau hauv lwm daim ntawv xovtooj:

=CLEAN(A2)

Qhov tshwm sim tsuas yog lo lus

Calendar

hauv cell A2.

Ntxiv rau kev tshem tawm cov cim tsis luam tawm, CLEAN muaj nuj nqi kuj hloov cov lej rau cov ntawv, uas yuav ua rau muaj kev ua yuam kev yog tias koj tom qab siv cov ntaub ntawv hauv kev suav.

Tshem tawm Cov Ntawv Tsis Sau, Tsis yog ASCII Cov Cim

Thaum lub CLEAN muaj nuj nqi yog qhov zoo tshaj plaws rau kev tshem tawm cov cim tsis tau luam tawm ASCII, muaj ob peb lub cim uas tsis tau luam tawm uas poob sab nraum ASCII ntau yam uas koj xav tau tshem tawm..

Cov cim tsis tuaj yeem luam tawm ntawm Unicode suav nrog tus lej 129, 141, 143,144 , and 157 . Tsis tas li ntawd, koj tuaj yeem xav tshem tawm 127 , uas yog tus lej rho tawm thiab tseem tsis tau luam tawm.

Ib txoj hauv kev tshem tawm cov ntaub ntawv no yog kom muaj SUBSTITUTE muaj nuj nqi hloov nws mus rau hauv ASCII cim uas CLEAN muaj nuj nqi tuaj yeem tshem tawm. Koj tuaj yeem zes qhov SUBSTITUTE thiab CLEAN ua haujlwm kom yooj yim dua.

=CLEAN(SUBSTITUTE(A3, CHAR(129), CHAR(7)))

Hloov pauv, ib tus tuaj yeem hloov pauv tus cwj pwm tsis zoo uas tsis luam tawm yam tsis muaj dab tsi ("").

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

Dab tsi yog Cov Cim Tsis Sau?

Txhua tus cim hauv lub computer - luam tau thiab tsis luam tawm - muaj tus lej hu ua nws tus cim Unicode lossis tus nqi. Lwm tus, laus dua, thiab paub zoo dua cov cim teeb yog ASCII, uas sawv cev rau American Standard Code for Information Interchange, tau muab tso rau hauv Unicode teeb.

Vim li ntawd, thawj 32 tus cim (0 txog 31) ntawm Unicode thiab ASCII cov teeb tsa zoo ib yam. Lawv siv los ntawm cov kev pab cuam los tswj cov khoom siv peripheral xws li tshuab luam ntawv, hla ntau lub platform. Yog li ntawd, lawv tsis yog npaj los siv rau hauv daim ntawv ua haujlwm thiab tuaj yeem ua yuam kev thaum tam sim no.

The CLEAN muaj nuj nqi, uas ua tiav cov cim Unicode teeb tsa, tshem tawm thawj 32 cov cim tsis luam tawm ASCII, thiab cov cim tib yam los ntawm Unicode teeb.