Qhov wikiHow qhia koj yuav ua li cas cog qoob loo cov ntaub ntawv pom hauv Microsoft Excel. Ua ntej txiav nws, cov ntaub ntawv ua tiav uas tsis tau txiav yuav tsum tau nkag mus rau hauv Excel daim ntawv nthuav dav ua ntej.
Kauj ruam
Txoj Kev 1 ntawm 3: Qhib Cov Ntawv Siv "LEFT" thiab "RIGHT" Formulas
Kauj Ruam 1. Qhib Microsoft Excel
Yog tias koj muaj cov ntaub ntawv nrog cov ntaub ntawv twb tau khaws tseg, ob npaug nias rau daim ntawv kom qhib nws. Txwv tsis pub, koj yuav tsum qhib phau ntawv ua haujlwm tshiab lossis phau ntawv ua haujlwm thiab sau cov ntaub ntawv ua ntej ntawm theem no.
Kauj Ruam 2. Xaiv lub npov koj xav siv los tso saib cov ntaub ntawv
Txoj hauv kev no yog qhov tsim nyog siv yog tias cov ntawv tau khaws cia hauv daim ntawv nthuav tawm.
Nco ntsoov tias lub thawv xaiv yog lub npov sib txawv los ntawm lub npov uas muaj lub hom phiaj ntawv
Kauj Ruam 3. Ntaus tus lej "LEFT" lossis "RIGHT" rau hauv lub thawv uas tau xaiv
Cov qauv "LEFT" thiab "RIGHT" tau tsim los rau tib txoj haujlwm. Txawm li cas los xij, tus lej "LEFT" qhia cov cim los ntawm sab laug ntawm lub npov ntawv, thaum lub mis "RIGHT" qhia cov cim los ntawm sab xis ntawm lub npov. Cov mis uas yuav tsum tau nkag mus yog "= DIRECTION (lub npov lub npe, tus lej cim los tso saib)" yam tsis muaj nqe lus. Piv txwv li:
- Cov mis = LEFT (A3, 6) yuav tso tawm thawj rau tus cim ntawm cov ntawv hauv lub npov A3. Yog tias lub thawv A3 muaj cov ntawv "Cov miv ntxim nyiam heev", cov ntawv txiav yuav pom zoo li "Cat" hauv lub thawv xaiv (qhov no, lub npov uas koj tau ntxiv cov mis ntxiv).
- Cov mis = RIGHT (B2, 5) yuav tso tawm tsib tus cim kawg ntawm cov ntawv hauv lub npov B2. Yog tias lub thawv B2 muaj cov ntawv "Kuv nyiam wikiHow", cov ntawv txiav yuav pom zoo li "kiHow" hauv lub thawv xaiv.
- Nco ntsoov tias cov chaw suav suav ua cim.
Kauj Ruam 4. Nias Enter tom qab koj ua tiav nkag mus rau tus lej
Lub thawv uas tau xaiv yuav cia li sau nrog cov ntawv luv ntawm cov ntawv.
Txoj Kev 2 ntawm 3: Txiav Cov Ntawv Siv "MID" Cov Qauv
Kauj Ruam 1. Xaiv lub npov koj xav siv los tso saib cov ntaub ntawv
Lub npov no yuav tsum txawv ntawm lub npov uas muaj lub ntsiab lus.
Nkag mus rau cov ntaub ntawv ua ntej hauv Excel daim ntawv yog tias koj tsis tau ua dua
Kauj Ruam 2. Ntaus cov mis “MID” rau hauv lub thawv uas tau xaiv
Tus lej "MID" siv lub hauv paus ntawm cov ntawv hauv lub thawv ntawv, tsis suav nrog pib thiab xaus. Txhawm rau nkag mus rau "MID" tus qauv, ntaus "= MID (lub npov lub npe, tus lej tus lej pib, tus lej cim los tso saib)" yam tsis muaj nqe lus. Piv txwv li:
- Cov mis = MID (A1, 3, 3) yuav tso tawm peb lub cim ntawm kab ntawv hauv A1, pib nrog tus cim thib peb ntawm cov ntawv (ntawm sab laug). Yog tias lub thawv A1 muaj cov ntawv "tsheb sib tw", cov ntawv txiav yuav raug nthuav tawm raws li "nqi" hauv lub thawv xaiv qhov chaw.
- Lub caij no, cov mis = MID (B3, 4, 8) yuav tso tawm yim cim ntawm kab ntawv hauv kab ntawv B3, pib ntawm tus cim plaub ntawm sab laug. Yog tias lub thawv B3 muaj cov ntawv "txiv tsawb tsis yog tib neeg", cov ntawv khaws cia yuav muab tso tawm raws li "qhib" hauv lub thawv xaiv qhov chaw.
Kauj Ruam 3. Nias Enter tom qab koj ua tiav nkag mus rau tus lej
Cov ntawv me me ntawm cov ntawv yuav raug ntxiv rau lub thawv xaiv.
Txoj Kev 3 ntawm 3: Muab cov ntawv cais ua ntau kab
Kauj Ruam 1. Xaiv lub npov nrog cov ntawv koj xav qhia
Lub thawv xaiv muaj cov ntawv nrog ntau tus cim ntau dua qhov chaw muaj.
Kauj Ruam 2. Nyem Cov Ntaub Ntawv
Qhov kev xaiv no nyob hauv cov cuab yeej nyob rau sab saum toj ntawm nplooj ntawv Excel.
Kauj Ruam 3. Xaiv Cov Ntawv rau Kab
Qhov kev xaiv no nyob hauv ntu "Cov Ntaub Ntawv Cov Ntaub Ntawv" ntawm "Data" tab.
Txoj haujlwm no faib cov ntsiab lus ntawm ib qho ntawm Excel cov thawv rau hauv kab sib cais
Kauj Ruam 4. Xaiv Dav Dav
Tom qab txhaj " Ntawv rau Kab "," Hloov Cov Ntawv rau Kab Wizard Step 1 of 3 "qhov rai yuav tshwm. Lub qhov rai no muaj ob txoj kev xaiv: "Delimited" thiab "Fixed Width". Qhov "Delimited" xaiv qhia cov cim xws li tabs lossis commas cais txhua lub thawv ntawv. Koj feem ntau yuav tsum xaiv "Delimited" thaum xa cov ntaub ntawv los ntawm lwm cov ntawv thov (piv txwv li cov chaw khaws ntaub ntawv). Qhov kev xaiv "Dav Dav" qhia tias cov thawv tau ua raws ntawm kab uas muaj qhov chaw nruab nrab ntawm txhua lub npov.
Kauj Ruam 5. Nyem Tom ntej
Lub qhov rai tshiab no qhia txog peb qho kev xaiv. Yog tias koj xav tsim kab delimiter, nyem rau txoj haujlwm xav tau ntawm tus kab zauv lossis kab ntawv cais. Yog tias koj xav tshem tus delimiter lossis cais cais, ob-nias kab. Txhawm rau kho nws, nyem thiab rub kab ntawm cov ntaub ntawv.
Kauj Ruam 6. Nyem Next
Lub qhov rai no muaj ntau txoj kev xaiv, uas yog "General", "Text", "Date", thiab "Don't import column (skip)". Koj tuaj yeem hla cov kev xaiv ntawm nplooj ntawv no, tshwj tsis yog koj xav hloov cov ntawv ntawv qub mus rau lwm hom ntawv.
Kauj Ruam 7. Nyem Tiav
Tam sim no koj cov ntawv yuav raug faib ua ob lossis ntau kab.
