Yog tias koj xav tau tshem cov npe lossis cov lus ntawm cov ntaub ntawv los ntawm Lo Lus rau hauv Excel, koj tsis tas yuav theej thiab muab tshuaj txhuam cov ntaub ntawv ib leeg rau hauv nws tus kheej ntawm tes hauv daim ntawv nthuav qhia. Los ntawm kev ua kom zoo dua koj cov ntawv Word ua ntej, koj tuaj yeem yooj yim ntshuam tag nrho cov ntawv rau hauv Excel nrog tsuas yog ob peb nyem.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Hloov Cov Npe
Kauj Ruam 1. Nkag siab tias yuav hloov pauv cov ntaub ntawv li cas
Thaum koj xa cov ntaub ntawv mus rau Excel, qee cov cim yuav raug siv los txiav txim cov ntaub ntawv nkag mus rau txhua lub xovtooj hauv Excel daim ntawv nthuav tawm. Los ntawm kev ua ob peb kauj ruam txheej txheem ua ntej yuav khoom, koj yuav tuaj yeem tswj tau tias daim ntawv kawg yuav tshwm li cas thiab txo tus nqi ntawm phau ntawv hom ntawv uas koj yuav tsum tau ua. Qhov no muaj txiaj ntsig tshwj xeeb tshaj yog tias koj tau xa cov npe loj los ntawm Cov Ntawv Word rau hauv Excel.
Txoj hauv kev no ua haujlwm tau zoo tshaj plaws thaum koj muaj cov npe ntawm ntau qhov nkag, txhua tus qauv zoo ib yam (cov npe chaw nyob, xov tooj, email chaw nyob, thiab lwm yam)
Kauj Ruam 2. Luam theej duab cov ntawv rau ib qho uas tsis raug
Ua ntej pib txheej txheem hloov dua siab tshiab, koj yuav xav kom ntseeg tau tias txhua qhov nkag los tau ua ib yam nkaus. Qhov no txhais tau tias kho ib qho yuam kev cim kab cim lossis rov txhim kho ib qho nkag uas tsis haum rau lwm qhov. Qhov no yuav ua kom ntseeg tau tias cov ntaub ntawv hloov pauv kom raug.
Kauj Ruam 3. Muab cov cim ua piv txwv hauv koj daim ntawv Word
Kev tso tawm cov cim ua qauv ib txwm zais yuav pab koj txiav txim siab txoj hauv kev zoo tshaj plaws los faib cov npe nkag. Koj tuaj yeem tso saib lawv los ntawm kev nyem rau "Qhia / Nkaum Cov Kab Lus Cim" khawm hauv Tsev tab lossis nyem Ctrl+⇧ Ua haujlwm+*
Cov npe feem ntau yuav muaj ib kab lus cim ntawm qhov kawg ntawm txhua kab, lossis ib qho ntawm qhov kawg ntawm kab thiab ib qho nyob hauv kab uas tsis muaj kab nruab nrab ntawm nkag. Koj yuav siv cov cim los ntxig cov cim siv los ntawm Excel txhawm rau sib txawv ntawm cov cell
Kauj Ruam 4. Hloov kab lus cim nruab nrab ntawm txhua qhov nkag mus kom tshem tau qhov chaw ntxiv
Excel yuav siv qhov chaw nruab nrab ntawm kev nkag los txiav txim kab, tab sis koj yuav tsum tau tshem nws tam sim no los pab cov txheej txheem txheej txheem. Tsis txhob txhawj xeeb, koj yuav ntxiv nws rov qab me ntsis. Qhov no ua haujlwm zoo tshaj plaws thaum koj muaj ib kab lus cim ntawm qhov kawg ntawm kev nkag thiab ib qho nyob hauv qhov chaw nruab nrab ntawm kev nkag (ob kab sib law liag).
- Nias Ctrl+H qhib qhov Nrhiav thiab Hloov qhov rai.
- Ntaus ^p ^p rau hauv Tshawb nrhiav. Nov yog cov cai rau ob kab lus cim uake. Yog tias txhua qhov nkag yog ib kab nkaus xwb thiab tsis muaj kab uas nyob nruab nrab ntawm lawv, siv ib ^p xwb.
- Nkag mus rau tus cwj pwm delimiting rau hauv Hloov Chaw. Nco ntsoov tias nws tsis yog tus yam ntxwv uas tshwm nyob txhua qhov chaw hauv daim ntawv, xws li ~.
- Nyem Hloov Tag Nrho. Koj yuav pom tias cov ntawv nkag tuaj yeem sib sau ua ke lawv tus kheej, tab sis qhov ntawd tsis yog kev txhawj xeeb tam sim no tsuav tus cim qis nyob hauv qhov chaw raug (ntawm txhua qhov nkag)
Kauj Ruam 5. Cais txhua qhov nkag mus rau hauv cov chaw cais
Tam sim no koj cov ntawv nkag tau sib cais kom lawv tshwm nyob rau hauv kab tom ntej, koj yuav xav txheeb xyuas cov ntaub ntawv twg yuav tshwm sim hauv txhua daim teb. Piv txwv li, yog tias txhua qhov nkag yog lub npe ntawm kab thawj, txoj kev nyob ntawm kab thib ob, thiab lub xeev thiab tus lej zip ntawm kab thib peb, koj tuaj yeem ua tau
- Nias Ctrl+H qhib qhov Nrhiav thiab Hloov qhov rai.
- Tshem tawm ib qho ntawm ^p cov cim hauv Tshawb nrhiav.
- Hloov tus cwj pwm hauv Hloov Hloov mus rau tus lej,.
- Nyem Hloov Tag Nrho. Qhov no yuav hloov cov kab lus seem uas seem nrog tus cim cais, uas yuav cais txhua kab mus rau hauv ib daim teb.
Kauj Ruam 6. Hloov tus cim ua cim kom tiav cov txheej txheem txheej txheem
Thaum koj tau ua tiav ob qho Kev Pom-thiab-Hloov cov kauj ruam saum toj no, koj cov npe yuav tsis zoo li cov npe ntxiv lawm. Txhua yam yuav nyob rau tib txoj kab, nrog tus lej nruab nrab ntawm txhua daim ntawv. Cov kauj ruam Nrhiav-thiab-Hloov qhov kawg no yuav xa koj cov ntaub ntawv mus rau cov npe thaum khaws tus lej cim uas txhais cov teb.
- Nias Ctrl+H qhib qhov Nrhiav thiab Hloov qhov rai.
- Nkag mus ~ (lossis yam cim twg koj xaiv thaum xub thawj) rau hauv Tshawb nrhiav.
- Sau ^p rau hauv Hloov Chaw.
- Nyem Hloov Tag Nrho. Qhov no yuav tawg koj cov npe nkag rov qab rau hauv cov pab pawg sib cais los ntawm tus lej.
Kauj Ruam 7. Khaws cov ntaub ntawv ua cov ntawv yooj yim
Tam sim no koj cov ntawv tau ua tiav, koj tuaj yeem khaws cov ntawv ua cov ntawv. Qhov no yuav tso cai rau Excel nyeem thiab cais koj cov ntaub ntawv kom nws mus rau hauv qhov chaw raug.
- Nyem rau File tab thiab xaiv "Save As".
- Nyem rau "Save as type" drop-down menu thiab xaiv "Plain Text".
- Npe cov ntaub ntawv raws li koj xav tau thiab nyem Txuag.
- Yog tias Cov Ntaub Ntawv Hloov Kho qhov rai tshwm, tsuas yog nyem OK.
Kauj Ruam 8. Qhib cov ntawv hauv Excel
Tam sim no koj tau khaws cov ntawv hauv cov ntawv yooj yim, koj tuaj yeem qhib nws hauv Excel.
- Nyem rau File tab thiab xaiv Qhib.
- Nyem rau "All Excel Files" drop-down menu thiab xaiv "Text Files".
- Nyem Tom ntej> nyob rau hauv Text Import Wizard window.
- Xaiv "Comma" hauv cov npe Delimiter. Koj tuaj yeem pom yuav ua li cas cov ntawv nkag yuav raug sib cais hauv qhov saib ua ntej hauv qab. Nyem Next>.
- Xaiv cov ntaub ntawv hom ntawv rau txhua kab thiab nyem Ua Ntej.
Txoj Kev 2 ntawm 2: Hloov Rooj
Kauj Ruam 1. Ua ib lub rooj hauv Lo Lus nrog koj cov ntaub ntawv
Yog tias koj muaj cov npe cov ntaub ntawv hauv Lo Lus, koj tuaj yeem hloov nws mus rau lub rooj lus hauv Lo Lus thiab tom qab ntawv luam cov ntawv ntawd sai sai rau hauv Excel. Yog tias koj cov ntaub ntawv twb tau nyob hauv cov lus rooj, hla mus rau kauj ruam tom ntej.
- Xaiv tag nrho cov ntawv uas koj xav hloov mus rau hauv lub rooj.
- Nyem rau Insert tab thiab tom qab ntawd nyem rau Table Table.
- Xaiv "Hloov Cov Ntawv rau Rooj".
- Nkag mus rau tus lej ntawm kab ib kab ntawv hauv "Tus lej ntawm kab" teb. Yog tias koj muaj kab dawb paug ntawm txhua cov ntaub ntawv, ntxiv ib qho rau tag nrho.
- Nyem OK.
Kauj Ruam 2. Txheeb xyuas qhov kev teeb tsa ntawm koj lub rooj
Lo lus yuav tsim lub rooj raws li koj qhov chaw. Txheeb ob zaug kom ntseeg tau tias txhua yam nyob qhov twg nws yuav tsum yog.
Kauj Ruam 3. Nyem rau lub pob "+" me ntsis uas tshwm nyob rau sab saud sab laug ntawm lub rooj
Qhov no yuav tshwm sim thaum koj tab tom tuav tus nas hla lub rooj. Nyem qhov no yuav xaiv tag nrho cov ntaub ntawv hauv lub rooj.
Kauj Ruam 4. Nias
Ctrl+C. luam cov ntaub ntawv.
Koj tseem tuaj yeem nyem lub pob "Luam" hauv Tsev Tsev tab.
Kauj Ruam 5. Qhib Excel
Thaum cov ntaub ntawv tau theej, koj tuaj yeem qhib Excel. Yog tias koj xav muab cov ntaub ntawv tso rau hauv daim ntawv teev npe uas twb muaj lawm, ntsaws nws. Muab koj tus cursor tso rau hauv lub xovtooj uas koj xav kom lub cell sab saud sab laug ntawm lub rooj tshwm.
Kauj Ruam 6. Nias
Ctrl+V. muab tshuaj txhuam cov ntaub ntawv.
Cov tib neeg ntawm cov lus los ntawm Lo Lus rooj yuav raug muab tso rau hauv cov cell cais hauv Excel daim ntawv nthuav tawm.
Kauj Ruam 7. Cais cov seem uas seem
Nyob ntawm seb hom ntaub ntawv twg koj tab tom ntshuam, tej zaum koj yuav muaj qee cov qauv ntxiv uas koj yuav tsum tau ua. Piv txwv li, yog tias koj tab tom xa cov chaw nyob hauv nroog, lub xeev cov ntawv luv, thiab tus lej xov tooj tuaj yeem nyob hauv tib lub cell. Koj tuaj yeem muaj Excel faib cov no cia li.
- Nyem rau kab lus kab lus ntawm kab ntawv koj xav faib los xaiv tag nrho kab.
- Xaiv lub tab "Cov Ntaub Ntawv" thiab nyem rau "Text to Columns" khawm.
- Nyem Next> thiab tom qab ntawd xaiv "Comma" hauv thaj chaw Delimiters. Yog tias koj siv tus piv txwv saum toj no, qhov no yuav cais lub nroog los ntawm lub xeev lub npe luv thiab tus lej zip.
- Nyem Ua tiav kom txuag qhov kev hloov pauv.
- Xaiv kab ntawv uas tseem xav tau faib thiab rov ua cov txheej txheem, xaiv "Chaw" hloov "Comma" ua tus zauv cim. Qhov no yuav cais lub xeev cov ntawv luv los ntawm tus lej zip.