Lo lus muaj kev teeb tsa uas tso cai rau koj los hloov cov lus ncaj qha mus rau ob nqe lus (cov lus nkhaus hauv txoj kev tshwj xeeb) thaum koj ntaus. Txawm li cas los xij, qee zaum nws yog cov lus ncaj nraim uas xav tau hauv ib daim ntawv, piv txwv li qee cov khub yuav tsum tau hloov rov qab.
Muaj ntau qhov laj thawj los hloov cov lus qhia ob npaug nrog cov lus hais ncaj. Peb xav qhia koj txog txoj hauv kev yooj yim los hloov cov lus hais siv lub cuab yeej Nrhiav thiab Hloov (Nrhiav thiab hloov).
Ua ntej pib nrog kev hloov, lov tes taw tsis siv neeg hloov pauv ntawm cov lus ncaj nraim nrog cov khub hauv qhov chaw. Hauv kab ntawv dhau los, peb tau qhia tias qhov teeb tsa no tau teeb tsa li cas. Koj yuav tsum qhib qhov chaw autoformat raws nraim tib txoj kev thiab tua cov lus hloov pauv.
Tom qab qhov kev xaiv yog neeg xiam, nyem Ctrl + Hqhib lub dialog Nrhiav thiab Hloov (Nrhiav thiab hloov).
Sau cov lus hais hauv cov teb Nrhiav dab tsi (Nrhiav) thiab Hloov nrog (Hloov nrog), thiab nyem Hloov (Hloov). Excel yuav pom thawj cov lus qhia rau koj. Yog tias nws yog ob nqe lus, nias Hloov (Hloov) hloov lawv nrog cov lus ncaj qha.
Nyob rau hauv tib txoj kev, koj tuaj yeem pom oblique apostrophes thiab hloov lawv nrog cov ncaj ncaj.
Nco ntsoov: Yog tias koj tab tom nrhiav nrog wildcards enabled, siv cov cim cim kom phim cov quotes. Kev tshawb nrhiav ib txwm tsis paub qhov txawv ntawm ob nqe lus thiab cov lus ncaj nraim, tab sis kev tshawb nrhiav tsiaj qus ua. Yog tias koj siv wildcards, tuav tus yuam sij Alt thiab sau tus lej uas xav tau siv tus lej keypad hauv daim teb Nrhiav dab tsi (Nrhiav) sib raug rau tus yam ntxwv xav tau: 0145 - qhib apostrophe; 0146 - kaw apostrophe; 0147 - qhib quotes; 0148 - kaw lus.
Tom qab tag nrho cov manipulations tau piav nyob rau hauv tsab xov xwm no, tsis txhob hnov qab mus rov qhib qhov kev xaiv los hloov ncaj quotes nrog ob quotes, ntawm chav kawm, yog tias koj xav tau.