6 txoj hauv kev los hloov qhov taw tes nrog lub semicolon hauv Microsoft Excel

Ntau cov neeg siv ntawm qhov kev pab cuam Excel tau ntsib nrog qhov teeb meem los hloov cov dots nrog commas hauv lub rooj. Qhov no feem ntau yog vim muaj qhov tseeb hauv cov lus Askiv hais lus nws yog kev coj los cais cov zauv feem ntawm ib tus lej los ntawm ib tus lej, thiab peb qhov xwm txheej, los ntawm, tsis nco qab. Qhov tsis zoo tshaj plaws, cov lej nrog lub dot tsis tau pom txog hauv Lavxias teb sab versions of Excel ua tus lej hom. Yog li no, qhov kev taw qhia tshwj xeeb ntawm kev hloov pauv yog qhov cuam tshuam. Cia peb saib yuav ua li cas hloov pauv cov ntsiab lus rau semicolons hauv Microsoft Excel ntawm ntau txoj kev.

Txoj hauv kev hloov pauv qhov taw tes rau ib lub comma

Muaj ntau ntau txoj kev ua pov thawj los hloov pauv qhov taw tes rau qhov tsis nco qab rau hauv Excel. Qee ntawm lawv tau daws tag siv cov kev ua haujlwm ntawm daim ntawv thov no, thiab siv rau lwm tus, kev siv cov kev pabcuam thib peb yog qhov yuav tsum tau ua.

Txoj Kev 1: Nrhiav thiab Hloov Cov Cuab Yeej

Qhov yooj yim tshaj plaws los hloov cov dots nrog commas yog coj kom zoo dua qhov muaj peev xwm uas cov cuab yeej muab tau. Nrhiav thiab HloovCov. Tab sis, koj yuav tsum tau ceev faj nws. Tom qab tag nrho, yog tias nws siv tsis raug, tag nrho cov ntsiab lus ntawm daim ntawv yuav hloov, txawm tias nyob hauv cov chaw uas lawv xav tau tiag tiag, piv txwv li, hauv hnub tim. Yog li, hom no yuav tsum tau siv kom zoo.

1. Nyob hauv kab "Tsev", nyob hauv pab pawg suav "Editing" rau ntawm kab xev Nyem ntawm khawm Nrhiav thiab HighlightCov. Hauv cov ntawv qhia zaub mov uas tshwm sim, mus rau yam khoom ntawd Hloov.



2. Qhov rai qhib Nrhiav thiab HloovCov. Hauv dab teb Nrhiav tau ntxig rau hauv cov phiajcim (.). Hauv dab teb Hloov - tsis pom qab kos npe (,). Nyem rau feem khawm "Xaiv".



3. Kev tshawb nrhiav ntxiv thiab hloov cov kev xaiv qhib. Yam txawv tsis dhau "Hloov nrog ..." nyem rau ntawm lub pob "Hom ntawv".



4. Lub qhov rais qhib hauv qhov uas peb tuaj yeem muab cov qauv ntawm sai los hloov, txawm nws yog ua ntej. Hauv peb qhov teeb meem, qhov loj tshaj plaws yog los tsim cov qauv ntaub ntawv cov naj npawb. Nyob hauv tab "Tooj" ntawm cov txheej txheem ntawm tus naj npawb hom, xaiv cov khoom "Numeric"Cov. Nyem rau feem khawm "OK".



5. Tom qab peb rov qab mus rau lub qhov rai Nrhiav thiab Hloov, xaiv tag nrho cov kab ntawv ntawm cov nplooj ntawv rau ntawm daim ntawv, qhov twg nws yuav tsim nyog los hloov qhov taw tes nrog lub chaw siab. Qhov no yog qhov tseem ceeb heev, vim tias yog tias koj tsis xaiv ntau yam, ces qhov hloov yuav tshwm sim thoob plaws daim ntawv, uas tsis tas yuav tsim nyog. Tom qab ntawv, nyem rau ntawm lub pob Hloov Txhua.

Raws li koj tuaj yeem pom, hloov chaw tau muaj kev vam meej.

Tshooj Lus: hloov tus cwj pwm hauv Excel

Txoj Kev 2: siv qhov haujlwm SUBSTITUTE

Lwm qhov kev xaiv los hloov lub sijhawm nrog lub chaw nco, yog siv SUBSTITUTE txoj haujlwm. Txawm li cas los xij, thaum siv txoj haujlwm no, qhov hloov pauv tsis tshwm sim hauv thawj cov roj ntsha, tab sis pom tshwm hauv kab ntawv cais.

1. Xaiv lub xovtooj ntawm, uas yuav yog thawj zaug hauv kab ntawv kom pom cov ntaub ntawv hloov kho. Nyem rau feem khawm "Ntxig ua haujlwm", uas yog nyob rau sab laug ntawm qhov chaw nyob ntawm txoj haujlwm.



2. Cov nuj nqi ntawm tus tsim pib. Hauv cov npe uas tau nthuav tawm hauv lub qhov rais qhib, peb saib rau tus nqi LUAG LUAGCov. Xaiv nws thiab nyem rau ntawm lub pob. "OK".



3. Lub muaj nuj nqi sib cav qhov rais qhib tau. Hauv dab teb "Ntawv" koj yuav tsum nkag mus rau qhov kev sib koom tes ntawm thawj lub xovtooj ntawm kem uas cov lej muaj kab nyob. Qhov no tuaj yeem ua los ntawm xaiv cov cell no rau ntawm daim ntawv nrog nas. Hauv dab teb "Star_text" ntxig rau kis (.). Hauv dab teb "New_text" muab tso rau comma (,). Tus teb Entry_number tsis tas sau. Txoj haujlwm nws tus kheej yuav muaj qhov qauv: "= SUBSTITUTE (cell_address;". ";", ")"Cov. Nyem rau feem khawm "OK".



4. Raws li koj tuaj yeem pom, hauv tus xovtooj tshiab, tus lej twb muaj qee qhov tsis nco qab (dot). Tam sim no peb yuav tsum tau ua ib txoj haujlwm zoo sib xws rau txhua lub xaib hauv kem. Tau kawg, koj tsis tas yuav nkag mus ua haujlwm rau txhua tus lej, muaj ntau txoj hauv kev nrawm dua los ua tus hloov dua siab tshiab. Peb sawv ntawm sab qaum txoj cai ntawm lub cell uas muaj cov ntaub ntawv hloov siab. Ib lub cim ntsiag to tshwm sim. Tuav cov laug nas khawm, luag nws nqes rau hauv qab ciam teb ntawm thaj chaw muaj cov ntaub ntawv yuav tsum hloov dua siab tshiab.



5. Tam sim no peb yuav tsum cob hom kab ntawv rau cov xovtooj ntawm tes. Xaiv tag nrho cheeb tsam ntawm cov ntaub ntawv hloov pauv. Ntawm daim xov nyob rau hauv tab "Tsev" nrhiav rau lub cuab yeej "Tooj"Cov. Nyob rau hauv daim ntawv teev nco-down, hloov cov hom ntawv hloov mus rau tus lej.

Qhov no ua tiav cov ntaub ntawv hloov dua siab tshiab.

Txoj Kev 3: thov siv cov ntawv loj

Koj kuj tuaj yeem hloov tus taw tes nrog ib tus tsis nco qab rau hauv Excel siv macro.

1. Ua ntej tshaj plaws, koj yuav tsum pab kom macros thiab lub tab "Tus tsim tawm"yog tias lawv tsis suav nrog koj.



2. Mus rau hauv lub tab "Tus tsim tawm".



3. Nyem rau feem khawm "Pom Qhov Muag Pom Zoo".



4. Hauv kab ntawv qhov rai uas qhib, muab lo cov cai hauv qab no:

   Sub Comma_Replacement_ Macro
Kev Xaiv.Qhov Dab Tsi: = ".", Hloov: = ","
Xaus sub

   Kaw cov editor.



5. Xaiv thaj tsam ntawm hlwb ntawm daim ntawv uas koj xav kom hloov. Nyob hauv tab "Tus tsim tawm" nyem rau ntawm lub pob Ntsig.



6. Nyob rau hauv lub qhov rai uas qhib, ib daim ntawv teev macros yog nthuav tawm. Xaiv los ntawm daim ntawv Macro hloov commas nrog dotsCov. Nyem rau feem khawm Khiav.

Tom qab ntawd, kev hloov pauv ntawm cov ntsiab lus mus rau commas hauv xaiv cov hlwb raug ua.

Saib xyuas! Siv tus qauv no kom zoo zoo. Qhov tshwm sim ntawm qhov loj heev no yog tsis hloov, yog li xaiv tsuas yog cov hlwb uas koj xav thov nws.

Zaj lus qhia: yuav ua li cas thiaj tsim tau macro hauv Microsoft Excel

Txoj Kev 4: siv Notepad

Cov txheej txheem tom ntej suav nrog kev luam cov ntaub ntawv mus rau cov qauv sau ntawv ntawm Windows Notepad, thiab hloov lawv hauv cov program no.

1. Hauv Excel, xaiv thaj tsam ntawm cov hlwb hauv qhov koj xav hloov cov taw tes nrog comma. Txoj nyem. Hauv cov ntsiab lus teb ntawv qhia zaub mov, xaiv Luam.



2. Qhib Phoo Ntawv. Peb muaj txoj cai nyem, thiab hauv cov npe uas tshwm, nyem rau ntawm qhov khoom Muab tshuaj txhuam.



3. Nyem rau ntawm cov khoom ntawv qhia zaub mov Kho kom raugCov. Hauv cov npe uas tshwm tawm, xaiv HloovCov. Los yog, koj tuaj yeem sau cov kev sib txuas tseem ceeb ntawm cov keyboard Ctrl + H.



4. Qhov tshawb nrhiav thiab hloov chaw qhib tau. Hauv dab teb "Dab tsi" muab xaus rau. Hauv dab teb "Tshaj" - tsis nco qab. Nyem rau feem khawm Hloov Txhua.



5. Xaiv cov ntaub ntawv pauv hauv Notepad. Txoj cai-nias, thiab nyob rau hauv cov npe, xaiv LuamCov. Los sis nias rau shortcut keyboard Ctrl + C.



6. Peb rov mus rau Excel. Xaiv cov kab rov qab ntawm cov hlwb uas qhov tseem ceeb yuav tsum tau hloov. Peb nyem rau nws nrog txoj cai khawm. Hauv cov ntawv qhia zaub mov uas tshwm hauv seem Ntxig Xaiv nyem rau ntawm lub pob "Tseg tsuas ntawv"Cov. Los sis, nias tus yuam sij ua ke Ctrl + V.



7. Rau tag nrho cov ntau ntawm cov hlwb, muab cov hom ntawv tus lej ib yam li peb tau ua dhau los.

Txoj Kev 5: hloov Excel chaw

Raws li ib txoj hauv kev ntawm hloov lub sijhawm mus rau khoom, koj tuaj yeem siv qhov kev hloov pauv ntawm Excel qhov chaw teeb tsa.

1. Mus rau hauv lub tab Cov ntaub ntawv.



2. Xaiv ib ntu "Xaiv".



3. Mus rau kis "Tshaj".



4. Hauv seem chaw Kho xaiv Xaiv uncheck cov khoom "Siv qhov system cais tawm"Cov. Nyob rau hauv kev ua teb "Separator ntawm seem thiab fractional" muab xaus rau. Nyem rau feem khawm "OK".



5. Tab sis, cov ntaub ntawv lawv tus kheej yuav tsis hloov. Peb luam lawv rau hauv Notepad, thiab tom qab ntawd muab tshuaj txhuam lawv rau hauv tib qho chaw nyob hauv txoj kev ib txwm.



6. Tom qab lub sijhawm ua haujlwm tiav, nws raug nquahu kom xa rov qab Excel chaw mus rau lub neej ntawd.

Txoj Kev 6: hloov chaw teeb tsa

Hom no zoo ib yam li yav dhau los. Tsuas yog lub sijhawm no peb thiaj tsis hloov ntawm Excel chaw. Thiab cov kev teeb tsa ntawm lub Windows.

1. Los ntawm cov ntawv qhia zaub mov Pib peb nkag mus "Tswj Vaj Huam Sib Luag".



2. Nyob rau hauv Pawg Tswj Xyuas, mus rau ntu "Moos, lus thiab cheeb tsam".



3. Mus rau hauv seem "Cov lus thiab cheeb tsam tus qauv".



4. Hauv qhov rai uas qhib, hauv tab "Tawm tswv yim" nyem rau ntawm lub pob "Cov Chaw Siab".



5. Hauv dab teb "Separator ntawm seem thiab fractional" hloov lub comma rau ib kis. Nyem rau feem khawm "OK".



6. Luam cov ntaub ntawv los ntawm Notepad rau Excel.



7. Peb xa rov qab dhau los lub chaw Windows.

Thaum kawg taw tes tseem ceeb heev. Yog tias koj tsis ua nws, ces koj yuav tsis tuaj yeem ua txoj haujlwm qub li qub nrog kev ua lej nrog cov ntaub ntawv hloov dua siab tshiab. Ib qho ntxiv, lwm cov kev pabcuam tau teeb tsa hauv lub khoos phis tawm tuaj yeem ua haujlwm tsis raug.

Raws li koj tuaj yeem pom, muaj ob peb txoj hauv kev los hloov qhov taw tes nrog lub comma hauv Microsoft Excel. Tau kawg, cov neeg siv feem ntau nyiam siv lub teeb ci tshaj plaws thiab yooj yim rau cov txheej txheem no. Nrhiav thiab HloovCov. Tab sis, hmoov tsis, hauv qee kis nrog nws txoj kev pab nws tsis tuaj yeem hloov kho cov ntaub ntawv kom raug. Tom qab ntawd lwm cov kev daws teeb meem yuav tuaj yeem cawm.