YUAV UA LI CAS KOM HLOOV IB QHO VUAG VOV MUS RAU IB QHO CHAW HAUV EXCEL

Nws yog paub tias nyob rau hauv lub Lavxias teb sab version ntawm Excel, tus voos vab yog siv raws li tus zauv separator, whereas hauv cov lus Askiv version tus taw tes yog siv. Qhov no yog vim lub neej ntawm ntau cov qauv hauv cheeb tsam no. Tsis tas li ntawd, hauv cov teb chaws Askiv, nws yog ib txoj kev cai uas siv lub vev thaus kev cais tawm, thiab nyob rau hauv peb lub teb chaws - ib lub sij hawm. Lawm, qhov no ua rau muaj teeb meem thaum ib tus neeg qhib ib qho ntaub ntawv tsim hauv qhov kev zov me nyuam nrog lwm qhov chaw. Nws tuaj cuag lub fact tias Excel tsis txawm xav txog cov qauv, raws li nws tsis to taub cov phiajcim. Hauv qhov no, koj yuav tsum tau hloov cov kev pab cuam hauv zos qhov chaw, lossis hloov cov cim hauv daim ntawv. Cia peb kawm saib yuav ua li cas hloov cov voos voog rau ib qho hauv daim ntawv thov no.

Hloov cov txheej txheem

Ua ntej koj pib hloov, koj yuav tsum xub nkag siab txog koj tus kheej seb koj ua li cas rau. Nws yog ib yam yog tias koj ua txoj haujlwm no tsuas yog vim koj pom qhov taw tes raws li lub separator thiab tsis npaj yuav siv cov lej no hauv cov lus teb. Nws yog ib qho tseem ceeb tshaj plaws yog tias koj xav hloov qhov kos npe rau qhov kev xam, raws li yav tom ntej cov ntaub ntawv yuav raug ua tiav hauv Askiv version of Excel.

Txoj kev 1: Nrhiav thiab Hloov Tuam

Qhov yoojyim tshaj uas yuav ua rau cov voj voos-to-dot transformation yog siv lub cuab yeej. "Nrhiav thiab hloov". Tab sis, tam sim ntawd nws yuav tsum tau sau tseg tias hom no tsis haum rau cov lus teb, vim cov ntsiab lus ntawm lub hlwb yuav hloov dua siab tshiab rau cov ntawv nyeem.

Ua kom muaj kev xaiv ntawm thaj chaw ntawm daim ntawv, qhov koj yuav tsum hloov lub viv ncaus rau hauv cov ntsiab lus. Ua ib txoj cai-nias. Nyob rau hauv cov ntsiab lus teb lag luam launched, xaiv cov khoom "Qib hlwb ...". Cov neeg siv uas xav siv lwm txoj kev xaiv nrog kev siv "kub tuav", tom qab xaiv, tuaj yeem sau qhov tseem ceeb ua ke Ctrl + 1.

Lub qhov rai formatting launched. Tsiv mus rau qhov tab "Tooj". Nyob rau hauv cov pab pawg ntawm cov tsis "Teeb Meem" txav mus rau txoj haujlwm "Cov ntawv nyeem". Yuav kom txuag tau qhov hloov tau, nias ntawm lub pob. "OK". Cov hom ntaub ntawv ntawm qhov xaiv tau yuav raug muab xa mus rau cov ntawv nyeem.

Rov ua dua, xaiv hom phiaj. Qhov no yog qhov tseem ceeb, vim hais tias tsis muaj kev xaiv ua ntej, qhov kev hloov yuav raug siv thoob plaws hauv thaj tsam ntawv, thiab qhov no tsis yog ib txwm tsim nyog. Tom qab cheeb tsam raug xaiv lawm, txav mus rau lub tab "Tsev". Ndliv lub khawm "Nrhiav thiab pom tseeb"uas yog nyob rau hauv lub cuab yeej thaiv Editing ntawm daim kab xev. Tom qab ntawd ib lub tshuab raj me me qhib uas koj yuav tsum xaiv "Hloov ...".

Tom qab ntawd, lub cuab yeej pib. "Nrhiav thiab hloov" nyob rau hauv tab "Hloov". Hauv teb "Nrhiav" teem lub cim ","thiab nyob tom teb "Hloov nrog" - ".". Ndliv lub khawm "Hloov Tag Nrho".

Cov ntaub ntawv qhib ib lub qhov rais qhib rau hauv daim ntawv tshaj tawm qhia txog kev hloov pauv tiav. Ndliv lub khawm. "OK".

Qhov kev zov me nyuam ua tau qhov kev hloov ntawm kev zeem muag rau cov ntsiab lus hauv qhov khwv xaiv. Qhov hauj lwm no tuaj yeem txiav txim siab daws. Tab sis nws yuav tsum nco ntsoov hais tias cov ntaub ntawv hloov nyob rau hauv no txoj kev yuav muaj ib hom ntawv nyeem thiab, yog li ntawd, yuav siv tsis tau nyob rau hauv lub laij.

Tshooj: Excel Character Hloov

Txoj kev 2: siv qhov ua haujlwm

Txoj kev thib ob yog siv tus neeg teb xov tooj SUBMIT. Yuav pib nrog, siv qhov kev ua no, peb yuav hloov cov ntaub ntawv hauv ib chav cais, thiab muab luam tawm mus rau qhov chaw ntawm thawj tus.

Xaiv lub nplhaib xov tooj ntawm sab xub thawj ntawm cov xov xwm ntau, uas yog xav kom hloov mus rau hauv cov ntsiab lus. Ndliv qhov icon "Ntxig rau kev ua haujlwm"muab tso rau sab laug ntawm lub mis bar.

Tom qab cov kev ua no, qhov kev ua haujlwm wizard yuav pib. Nrhiav hauv qeb "Kev Xeem" los yog "Daim ntawv teev npe tag nrho" npe "SUBMIT". Xaiv nws thiab nyem rau ntawm lub pob. "OK".

Qhov sib xyaw qhov rooj qhib qhov rooj. Nws muaj peb cov lus sib cav. "Cov ntawv nyeem", "Cov ntawv qub" thiab "Cov ntawv tshiab". Hauv teb "Cov ntawv nyeem" Koj yuav tsum qhia qhov chaw nyob ntawm lub xovtooj uas cov ntaub ntawv nyob rau hauv. Ua li no, muab tus cursor rau hauv daim teb no, thiab nias rau ntawm daim ntawv hauv thawj lub xovtooj ntawm qhov sib txawv. Tam sim ntawd tom qab no, qhov chaw nyob yuav tshwm nyob rau hauv cov lus sib cam. Hauv teb "Cov ntawv qub" teev tus cim tom ntej - ",". Hauv teb "Cov ntawv tshiab" muab ib qho taw tes - ".". Tom qab cov ntaub ntawv nkag, nyem rau ntawm lub pob "OK".

Raws li koj tau pom, cov kev hloov rau thawj lub cell tau zoo. Ib qho haujlwm zoo sib xws yuav ua tau rau tag nrho lwm cov qe ntshav ntawm qhov xav tau ntau yam. Zoo, yog hais tias qhov no yog me me. Tab sis yuav ua li cas yog tias nws muaj ntau lub hlwb? Tom qab tag nrho, qhov pom nyob rau hauv no txoj kev, nyob rau hauv cov ntaub ntawv no, yuav siv sij hawm ib tug lossis loj npaum li cas ntawm lub sij hawm. Tab sis, cov txheej txheem yuav ua tau kom yooj yim ntawm luam cov mis SUBMIT siv tus cim kos npe.
Muab tus cursor rau hauv qab nruab nrab sab xis ntawm lub xov tooj uas muaj qhov ua haujlwm. Ib daim ntawv sau pom tshwm hauv daim ntawv ntawm tus me me ntoo khaub lig. Clamp rau sab laug nas khawm thiab cab no hla mus tib seem mus rau thaj chaw uas koj xav hloov lub viv ncaus rau hauv cov ntsiab lus.

Raws li koj tau pom, tag nrho cov ntsiab lus ntawm cov hom phiaj yog hloov dua siab tshiab rau cov ntaub ntawv nrog cov dots es tsis txhob sau. Tam sim no koj yuav tsum luam daim ntawv no thiab paste rau hauv qhov chaw. Xaiv lub hlwb nrog mis. Nyob hauv tab "Tsev", nyem rau ntawm lub pob ntawm daim ntawv sau "Daim qauv"uas yog nyob hauv pawg pab pawg "Ntawv Teev Npe". Koj tuaj yeem ua kom yooj yim dua, uas yog tom qab xaiv qhov khwv kom tau hom kev ua tiav ntawm cov keyboard Ctrl + 1.

Xaiv qhov tseem ceeb. Nias rau kev xaiv nrog txoj kev nas khawm. Ib lub ntsiab lus qhia zaub mov tshwm. Hauv nws, nias qhov khoom "Qhov tseem ceeb"uas yog nyob hauv ib pab pawg "Insertion Options". Cov khoom no yog qhia los ntawm cov lej. "123".

Tom qab cov kev ua no, qhov tseem ceeb yuav raug muab tso rau hauv qhov tsim nyog. Nyob rau hauv cov ntaub ntawv no, cov hnub xaum yuav raug hloov mus rau hauv cov ntsiab lus. Tshem tawm hauv cheeb tsam uas tsis yog peb xav tau ntxiv, muaj cov qauv, xaiv nws thiab nias lub khawm txoj kev nas. Hauv daim ntawv qhia zaub mov, xaiv qhov khoom "Cov lus tseeb".

Kev hloov ntawm cov ntaub ntawv rau qhov kev hloov ntawm daim av rau cov ntsiab lus tiav, thiab tag nrho cov ntsiab lus tsis tseem ceeb yog deleted.

Tshooj: Excel Function Wizard

Method 3: Siv Macro

Cov txheej txheem tom ntej ntawm kev hloov ua vam rau hauv cov ntsiab lus yog txuam nrog kev siv macros. Tab sis, qhov tshaj plaws yog tias yog vim, macros hauv Excel yog neeg xiam oob khab.

Ua ntej tshaj, koj yuav tsum pab kom tau macros, zoo li qhib lub tab "Tsim tawm", yog lawv tseem tsis tau qhib rau hauv koj qhov kev zov me nyuam. Tom qab ntawd koj yuav tsum ua cov yeeb yam nram no:

Txav mus rau tab "Tsim tawm" thiab nyem rau ntawm lub pob "Nrig txog kev pom tseeb"uas yog nyob rau hauv lub cuab yeej thaiv "Txoj Cai" ntawm daim kab xev.

Lub macro editor opens. Peb tso cov cai hauv qab no rau hauv:
Sub Macro_transformation_completion_point_point () Xaiv Ua Dab Tsi: = ",", Hloov: = "." Kawg kawg
Tag cov haujlwm ntawm tus editor nrog tus txheej txheem los ntawm txhaj khawm kaw nyob rau hauv cov ces kaum sab sauv.

Tom ntej no, xaiv qhov ntau yam uas yuav hloov tau. Ndliv lub khawm Macrosuas yog txhua yam hauv tib pab pawg ntawm cov cuab yeej "Txoj Cai".

Lub qhov rais qhib nrog ib daim ntawv teev cov macros muaj nyob rau hauv phau ntawv. Xaiv ib qho uas nyuam qhuav tau tsim los ntawm tus editor. Tom qab koj xaiv txoj kab nrog nws lub npe, nias ntawm lub pob Khiav mus.

Kev hloov pauv hloov hauv kev kawm. Kev tuav xam yuav hloov mus rau hauv cov ntsiab lus.

Tshooj: Yuav ua li cas los ua tus macro hauv Excel

Txoj kev 4: Tus nqis Excel

Cov nram qab no yog tib qho ntawm cov saum toj no, nyob rau hauv uas, thaum hloov cov lus qhua rau hauv cov ntsiab lus, qhov kev qhia yuav raug pom los ntawm qhov kev pab cuam raws li ib tug xov tooj, thiab tsis raws li cov ntawv nyeem. Ua li no, peb yuav tsum hloov lub tshuab cais tawm hauv cov tsev koom nrog nrog ib lub sijhawm rau ib lub sijhawm.

Nyob hauv tab "Cov Ntaub Ntawv", nias lub npe ntawm lub npe "Kev xaiv".

Nyob rau hauv lub qhov tsis cov qhov rai peb tsiv mus nyob rau hauv lub subsection "Qib Siab". Peb nrhiav kev thaiv chaw "Editing xaiv". Tshem lub thawv ntawv ntawm ib sab ntawm tus nqi. "Siv qhov kev kaw lus". Ces nyob hauv pawg lus "Separator ntawm tag nrho thiab feem ntu" hloov nrog "," on ".". Yuav tsum nkag mus rau hauv kev nqis tes nias ntawm khawm. "OK".

Tom qab cov kauj ruam saum toj no, cov hnub uas tau siv los ua kev cais rau cov zauv feem ntau yuav hloov mus rau ib ntus. Tab sis, qhov tseem ceeb tshaj plaws, cov kab lus uas lawv siv yuav nyob twj ywm numeric, thiab yuav tsis hloov dua siab tshiab rau cov ntawv nyeem.

Muaj ntau txoj hauv kev los hloov cov vauv rau cov ntsiab lus hauv Excel cov ntaub ntawv. Feem ntau ntawm cov kev xaiv no koom nrog hloov cov ntaub ntawv ntawm cov naj npawb rau cov ntawv nyeem. Qhov no ua rau qhov tseeb tias qhov kev zov me nyuam siv tsis tau cov kab lus no hauv cov lus teb. Tab sis kuj muaj ib txoj kev los hloov cov npluan rau hauv cov ntsiab lus, khaws cia cov qauv ntawv qub. Ua kom tau qhov no, koj yuav tsum hloov cov chaw ntawm qhov kev zov me nyuam nws tus kheej.