Yuav ua li cas tshem tawm apostrophe hauv Excel

Ib qho ntawm cov cim cim cim cim yog apostrophe, thiab hauv Excel cov ntawv nthuav dav nws feem ntau txhais tau tias cov ntawv nyeem ntawm cov lej. Cov cim no feem ntau tshwm sim hauv qhov chaw tsis tsim nyog, qhov teeb meem no kuj tshwm sim nrog lwm cov cim lossis cov ntawv. Cia peb kawm seb yuav ua li cas kom tshem tau lub rooj ntawm kev cuam tshuam cov cim tsis zoo.

Yuav ua li cas tshem tawm apostrophe pom nyob rau hauv ib lub cell

Ib qho apostrophe yog cov cim cim tshwj xeeb, nws tsuas yog sau rau hauv qee kis. Piv txwv li, nws yuav tshwm sim hauv cov npe kom raug lossis hauv cov lej muaj nuj nqis. Txawm li cas los xij, qee zaum cov neeg siv Excel sau apostrophes hauv qhov chaw tsis raug. Yog tias muaj ntau cov cim ntxiv hauv lub rooj, koj tuaj yeem hloov lawv nrog lwm tus. Cia peb xav seb yuav ua li cas hauv ob peb kauj ruam ceev siv qhov kev pab cuam cov cuab yeej.

1. Xaiv cov hlwb uas cov cim tsis raug nyob. Hauv "Tsev" tab, nrhiav "Nrhiav thiab xaiv" khawm thiab nyem rau ntawm nws.

2. Xaiv cov khoom "Hloov" hauv cov ntawv qhia zaub mov uas qhib lossis nias lub pob kub "Ctrl + H".

3. Lub dialog box yuav qhib nrog ob lub teb. Hauv kab hauv qab nqe lus "Nrhiav" koj yuav tsum nkag mus rau lub cim uas sau tsis raug - qhov no, apostrophe. Peb sau rau hauv kab "Hloov nrog" tus cim tshiab. Yog tias koj tsuas xav tshem lub apostrophe, tawm ntawm kab thib ob. Piv txwv li, cia peb hloov lub cim rau hauv kab "Hloov nrog" thiab nyem lub pob "Hloov tag nrho".

4. Tam sim no nyob rau hauv lub rooj es tsis txhob ntawm apostrophes muaj commas.

Koj tuaj yeem hloov apostrophes tsis yog ntawm ib daim ntawv xwb, tab sis thoob plaws hauv phau ntawv. Nyem qhov "Options" khawm nyob rau hauv lub hloov dialog box - cov kev xaiv tshiab yuav tshwm sim. Txhawm rau ntxig ib tus cim tsis yog lwm tus ntawm txhua nplooj ntawv ntawm cov ntaub ntawv, xaiv "Nyob hauv phau ntawv" kev xaiv hauv "Nrhiav" yam khoom thiab nyem "Hloov Txhua".

Yuav ua li cas tshem tawm qhov tsis pom apostrophe ua ntej ib txoj hlua

Qee lub sij hawm thaum luam qhov tseem ceeb los ntawm lwm cov kev pab cuam, ib qho apostrophe tshwm sim ua ntej tus naj npawb hauv cov qauv bar. Tus cwj pwm no tsis nyob hauv lub cell. Lub apostrophe qhia cov ntawv nyeem ntawm cov ntsiab lus ntawm tes - tus lej yog formatted raws li cov ntawv nyeem, thiab qhov no cuam tshuam nrog kev suav. Cov cim zoo li no tsis tuaj yeem raug tshem tawm los ntawm kev hloov cov qauv, cov cuab yeej Excel los yog functions. Koj yuav tsum siv Visual Basic Editor.

1. Qhib Visual Basic rau daim ntawv thov qhov rai siv Alt + F qhov tseem ceeb ua ke
2. Tus editor tsuas muaj ua lus Askiv xwb. Peb pom ntawm cov ntawv qhia zaub mov sab saum toj Ntxig (Ntxig) thiab nyem rau ntawm cov khoom Module (Module).

3. Sau ib qho macro tshem tawm apostrophe.

Mloog! Yog tias nws tsis tuaj yeem tsim macro koj tus kheej, siv cov ntawv no.

4. Xaiv qhov ntau ntawm cov hlwb uas cov cim ntxiv tshwm, thiab nias qhov tseem ceeb ua ke "Alt + F8". Tom qab ntawd, cov apostrophes yuav ploj mus thiab cov lej yuav siv qhov tseeb.

Tshem tawm qhov chaw ntxiv ntawm lub rooj

Cov chaw ntxiv yog muab tso rau hauv Excel cov lus los faib cov lej loj rau hauv qhov chaw lossis yuam kev. Yog tias koj paub tias muaj ntau qhov chaw hauv cov ntaub ntawv uas yuav tsum tsis txhob ua, siv Function Wizard.

1. Xaiv ib lub xovtooj dawb thiab qhib lub qhov rais Function Manager. Cov npe ntawm cov qauv tuaj yeem nkag mus tau los ntawm kev nyem rau ntawm "F(x)" icon nyob ib sab ntawm lub formula bar lossis ntawm "Formulas" tab ntawm toolbar.

2. Qhib "Tsev" qeb, nws tau teev nyob rau hauv lub dialog box los yog nyob rau hauv lub "Formulas" tab raws li ib tug cais seem. Koj yuav tsum xaiv TRIM muaj nuj nqi. Daim duab qhia ob txoj kev.

3. Tsuas yog ib lub xov tooj tuaj yeem dhau los ua qhov kev sib cav. Peb nyem rau ntawm qhov xav tau ntawm tes, nws lub npe yuav poob rau hauv kab lus sib cav. Tom ntej no, nyem "OK".

4. Peb sau ntau kab, yog tias tsim nyog. Nyem rau ntawm lub xov tooj saum toj kawg nkaus uas tus qauv nyob thiab tuav lub cim square dub nyob rau sab xis sab xis. Xaiv tag nrho cov hlwb uas koj xav tau qhov tseem ceeb lossis cov ntawv tsis muaj qhov chaw thiab tso tus nas khawm.

Tseem ceeb! Nws yog tsis yooj yim sua kom tshem tag nrho cov ntawv ntawm qhov chaw ntxiv, koj yuav tsum tau siv cov mis hauv cov kab sib txawv txhua zaus. Kev ua haujlwm yuav siv sijhawm me ntsis, yog li yuav tsis muaj teeb meem.

Yuav ua li cas tshem tawm cov cim tshwj xeeb tsis pom

Yog tias tus cim tshwj xeeb hauv cov ntawv nyeem tsis tuaj yeem nyeem tau los ntawm qhov program, nws yuav tsum raug tshem tawm. Qhov kev ua haujlwm TRIM tsis ua haujlwm zoo li no, vim tias qhov chaw nruab nrab ntawm cov cim tsis yog qhov chaw, txawm tias lawv zoo sib xws. Muaj ob txoj hauv kev los tshem cov ntaub ntawv los ntawm cov cim tsis tau nyeem. Thawj txoj hauv kev los tshem tawm cov cim Excel tsis paub yog siv qhov "Hloov" kev xaiv.

1. Qhib lub qhov rais hloov los ntawm "Nrhiav thiab xaiv" khawm ntawm lub ntsiab tab. Lwm yam cuab yeej uas qhib lub dialog box yog cov keyboard shortcut "Ctrl + H".
2. Luam cov cim tsis tau nyeem (qhov chaw khoob uas lawv nyob) thiab muab tso rau hauv thawj kab. Qhov chaw thib ob yog sab laug.
3. Nias lub pob "Hloov Tag Nrho" - cov cim yuav ploj ntawm daim ntawv lossis los ntawm tag nrho phau ntawv. Koj tuaj yeem kho qhov ntau hauv "Parameters", cov kauj ruam no tau tham ua ntej.

Hauv txoj kev thib ob, peb rov siv cov yam ntxwv ntawm Function Wizard. Piv txwv li, cia peb ntxig ib qho kev nkag nrog ib txoj kab tawg rau hauv ib qho ntawm cov cell.

1. Pawg "Text" muaj PRINT muaj nuj nqi, nws cuam tshuam rau cov cim uas tsis tau luam tawm. Koj yuav tsum xaiv nws los ntawm cov npe.

2. Peb sau nyob rau hauv tib lub teb nyob rau hauv lub dialog box - yuav tsum tshwm sim ib tug cell designation uas muaj ib tug ntxiv cim. Nyem qhov "OK" khawm.

Qee cov cim tsis tuaj yeem raug tshem tawm los ntawm kev siv lub luag haujlwm, hauv cov xwm txheej zoo li no nws tsim nyog tig los hloov.

• Yog tias koj xav muab lwm yam hloov pauv cov cim tsis tau nyeem, siv SUBSTITUTE muaj nuj nqi. Txoj kev no kuj tseem siv tau rau hauv rooj plaub uas ua yuam kev hauv cov lus. Cov haujlwm yog nyob rau qeb "Text".
• Rau cov qauv ua haujlwm kom raug, koj yuav tsum tau sau peb qhov kev sib cav. Thawj daim teb muaj ib lub xov tooj nrog cov ntawv nyeem uas hloov cov cim. Cov kab thib ob yog tshwj tseg rau cov cim hloov, hauv kab thib peb peb sau tus cim tshiab lossis tsab ntawv. Ntau lo lus rov sau ntawv, yog li peb cov lus tsis txaus.

• Tus lej tshwm sim yog tus lej qhia tias tus cwj pwm ntawm ob peb qhov zoo ib yam yuav tsum tau hloov. Qhov piv txwv qhia tau tias tsab ntawv thib ob "a" raug hloov, txawm hais tias nws nyob hauv lo lus raug. Cia peb sau tus naj npawb 1 hauv qhov "Qhov tshwm sim tus lej" thiab qhov tshwm sim yuav hloov pauv. Tam sim no koj tuaj yeem nyem OK.

xaus

Tsab ntawv txiav txim siab txhua txoj hauv kev los tshem tawm apostrophe. Ua raws li cov lus qhia yooj yim, txhua tus neeg siv yuav muaj peev xwm tiv nrog txoj haujlwm yam tsis muaj teeb meem.