txheem
Kab lus no tham txog txoj hauv kev uas koj tuaj yeem tshem tawm kab wrapping (carriage return or line break) hauv Excel cov ntaub ntawv. Tsis tas li ntawd, ntawm no koj yuav pom cov ntaub ntawv yuav ua li cas hloov nws nrog lwm cov cim. Txhua txoj hauv kev tsim nyog rau cov qauv ntawm Excel 2003-2013 thiab 2016.
Cov laj thawj rau qhov pom ntawm kab tawg hauv ib daim ntawv muaj ntau yam. Nws feem ntau tshwm sim thaum luam cov ntaub ntawv los ntawm nplooj ntawv web, thaum lwm tus neeg siv muab rau koj nrog ib daim ntawv ua tiav Excel, lossis yog tias koj qhib qhov no koj tus kheej los ntawm nias lub Alt + Enter.
Yog li, qee zaum vim tias txoj kab tawg nws nyuaj rau nrhiav cov kab lus, thiab cov ntsiab lus ntawm kab ntawv zoo li sloppy. Tias yog vim li cas koj yuav tsum xyuas kom meej tias tag nrho cov ntaub ntawv nyob ntawm ib kab. Cov txheej txheem no yooj yim rau kev siv. Siv qhov koj nyiam tshaj plaws:
- Manually tshem tawm tag nrho cov kab tawg kom coj cov ntaub ntawv ntawm daim ntawv 1 rov qab mus rau qhov qub.
- Tshem tawm cov kab tawg nrog cov qauv los pib ua cov ntaub ntawv nyuaj ntxiv.
- Siv VBA macro.
- Tshem tawm cov kab tawg nrog Text Toolkit.
Thov nco ntsoov tias cov ntsiab lus qub "Carriage return" thiab "Line feed" tau siv thaum ua haujlwm ntawm lub tshuab ntaus ntawv. Tsis tas li ntawd, lawv tau hais txog 2 txoj haujlwm sib txawv. Xav paub ntau ntxiv txog qhov no tuaj yeem nrhiav tau ntawm txhua qhov kev siv khoom siv.
Cov khoos phis tawj ntawm tus kheej thiab cov kev pabcuam sau ntawv tau tsim nyob ib puag ncig cov yam ntxwv ntawm lub tshuab ntaus ntawv. Yog vim li ntawd, txhawm rau qhia txog kab tawg, muaj 2 cov cim uas tsis tuaj yeem luam tawm: "Carriage return" (lossis CR, code 13 hauv ASCII table) thiab "Line feed" (LF, code 10 in the ASCII table). Ntawm Windows, CR + LF cov cim tau siv ua ke, tab sis ntawm * NIX, tsuas yog siv LF xwb.
xim: Excel muaj ob qho kev xaiv. Thaum importing cov ntaub ntawv los ntawm .txt los yog .csv cov ntaub ntawv, CR + LF cim ua ke yog feem ntau yuav siv. Thaum siv Alt + Enter ua ke, tsuas yog cov kab tawg (LF) yuav raug siv. Tib yam yuav tshwm sim thaum kho cov ntaub ntawv tau txais los ntawm tus neeg ua haujlwm ntawm * Nix operating system.
Tshem tawm kab tawg manually
Zoo: qhov no yog qhov yooj yim tshaj plaws.
tsis zoo: tsis muaj ntxiv nta.
Ua raws li cov kauj ruam nram no:
- Xaiv cov hlwb uas koj xav tshem tawm lossis hloov cov kab tawg.
- Nias Ctrl + H los qhib lub luag haujlwm “Nrhiav thiab Hloov”.
- Nyob rau hauv lub "Nrhiav" ntaus Ctrl + J, tom qab ntawd ib qho me me yuav tshwm hauv nws.
- Hauv teb "Hloov los ntawm” nkag mus rau txhua tus cim los hloov cov kab tawg. Koj tuaj yeem nkag mus rau qhov chaw kom cov lus hauv cov hlwb tsis sib koom ua ke. Yog tias koj xav tau tshem tawm cov kab tawg, tsis txhob nkag mus rau ib yam dab tsi hauv "Hloov los ntawm”.
- Nias lub pob “Hloov tag nrho”.
Tshem cov kab tawg nrog Excel cov qauv
Zoo: nws muaj peev xwm siv cov saw ntawm cov qauv rau kev ua cov ntaub ntawv nyuaj. Piv txwv li, koj tuaj yeem tshem tawm cov kab tawg thiab tshem tawm qhov chaw ntxiv.
Tsis tas li ntawd, koj yuav tsum tau tshem tawm cov ntaub qhwv los ua haujlwm nrog cov ntaub ntawv raws li kev sib cav ua haujlwm.
tsis zoo: koj yuav tsum tsim ib kab ntawv ntxiv thiab ua haujlwm pab.
- Ntxiv ib kab ntawv ntxiv ntawm sab xis. Sau npe nws "kab 1".
- Hauv thawj lub xov tooj ntawm kab ntawv no (C2), nkag mus rau ib qho qauv uas yuav tshem tawm cov kab tawg. Hauv qab no yog cov kev sib txawv sib txawv uas haum rau txhua kis:
- Haum rau Windows thiab Unix operating systems:
=SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),»»),CHAR(10),»»)
- Cov qauv no yuav tso cai rau koj hloov txoj kab tawg nrog lwm tus cim. Hauv qhov no, cov ntaub ntawv yuav tsis sib koom ua ke rau hauv ib qho tag nrho, thiab qhov chaw tsis tsim nyog yuav tsis tshwm sim:
=TRIM(SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),»»),CHAR(10),»,«)
- Yog tias koj xav tau tshem tawm tag nrho cov cim uas tsis tuaj yeem luam tawm, suav nrog cov kab tawg, cov qauv yuav los ua ke:
=CLEAN(B2)
- Duplicate cov mis hauv lwm lub hlwb ntawm kab.
- Yog tias tsim nyog, cov ntaub ntawv los ntawm cov thawj kem tuaj yeem hloov nrog qhov kawg tshwm sim:
- Xaiv tag nrho cov hlwb hauv kab C thiab nias Ctrl + C kom luam cov ntaub ntawv.
- Tam sim no xaiv cell B2 thiab nias Shift + F10 thiab tom qab ntawd V.
- Tshem cov kab ntxiv.
VBA macro tshem tawm cov kab tawg
Zoo: Thaum tsim, macro tuaj yeem rov qab siv tau hauv txhua phau ntawv ua haujlwm.
tsis zoo: Nws yog ib qho tsim nyog kom nkag siab VBA.
Lub macro ua haujlwm zoo ntawm kev tshem cov kab tawg ntawm txhua lub hlwb ntawm daim ntawv ua haujlwm.
Tshem tawm kab tawg nrog Text Toolkit
Yog tias koj siv Text Toolkit lossis Ultimate Suite rau Excel, koj yuav tsis tas siv sijhawm rau kev tswj hwm.
Txhua yam koj yuav tsum ua:
- Xaiv cov hlwb uas koj xav tshem tawm cov kab tawg.
- Ntawm Excel ribbon, mus rau tab “Ablebits Data”, ces mus rau qhov kev xaiv "Text Group” thiab nyem rau ntawm lub pob “Hloov” .
- Ntawm lub vaj huam sib luag “Hloov cov ntawv” xaiv xov tooj cua khawm "Convert line break to ", nkag mus “Kev Hloov” hauv daim teb thiab nias “Hloov”.
Ntawm no, txhua kab tawg yog hloov los ntawm qhov chaw, yog li koj yuav tsum tso tus nas cursor rau hauv daim teb thiab nias Enter.
Thaum siv cov txheej txheem no, koj yuav tau txais ib lub rooj nrog cov ntaub ntawv zoo.
