Qhov wikiHow qhia koj yuav hloov pauv Notepad (.txt) cov ntaub ntawv mus rau Microsoft Excel ntawv (.xlsx) li cas Windows 10.
Cov kauj ruam
Kauj Ruam 1. Qhib Microsoft Excel
Ib txoj hauv kev nrawm los ua qhov no yog ntaus excel rau hauv Windows tshawb nrhiav bar thiab nyem Microsoft Excel.
Kauj ruam 2. Nyem rau File menu
Nws yog nyob rau sab saud sab laug ntawm Excel.
Kauj Ruam 3. Nyem Qhib
Kauj Ruam 4. Xaiv Cov ntawv sau los ntawm cov ntawv ua hom ntawv nco-down
Kauj Ruam 5. Xaiv cov ntawv uas koj xav hloov pauv thiab nyem Qhib
Qhov no qhib qhov Text Import Wizard.
Kauj Ruam 6. Xaiv hom ntaub ntawv thiab nyem Next
Hauv ″ Thawj hom ntaub ntawv ″ ntu, xaiv Delimited (yog tias cov ntawv sau muaj cov ntaub ntawv cais los ntawm tus lej, tab, lossis qee txoj hauv kev), lossis Tsau dav (yog tias cov ntaub ntawv tau ua nyob hauv kab nrog qhov chaw nruab nrab ntawm txhua daim teb).
Kauj Ruam 7. Xaiv tus deliminators lossis dav dav thiab nyem Next
- Yog koj xaiv Delimited ntawm lub vijtsam dhau los, khij lub npov nyob ib sab ntawm lub cim (lossis "Chaw" yog tias nws tau sib cais los ntawm qhov chaw) siv los cais cov ntaub ntawv.
- Yog koj xaiv Tsau dav ntawm lub vijtsam dhau los, ua raws cov lus qhia ntawm lub vijtsam los npaj koj cov ntaub ntawv kom raug.
Kauj Ruam 8. Xaiv kab ntawv hom ntawv
Xaiv qhov kev xaiv hauv qab ″ Column data format ″ uas zoo tshaj plaws piav qhia cov ntaub ntawv hauv kab ntawv (piv txwv. Ntawv, Hnub tim).
Kauj Ruam 9. Nyem Ua tiav
Qhov "Save As" window yuav tshwm.
Kauj Ruam 10. Xaiv Excel Workbook (*.xlsx) los ntawm ″ Save as type ″ menu
Nws nyob hauv qab ntawm lub qhov rais.
Kauj Ruam 11. Npe lub npe ntawv thiab nyem Txuag
Cov ntawv sau Notepad tam sim no tau khaws tseg ua phau ntawv Excel.