Yuav Hloov Li Cas Cov Ntawv Text rau Excel

Cov txheej txheem:

Yuav Hloov Li Cas Cov Ntawv Text rau Excel
Yuav Hloov Li Cas Cov Ntawv Text rau Excel

Video: Yuav Hloov Li Cas Cov Ntawv Text rau Excel

Video: Yuav Hloov Li Cas Cov Ntawv Text rau Excel
Video: yuav coj li cas kom luag nyiam 2023, Cuaj hlis
Anonim

Kab lus no yuav qhia koj yuav hloov pauv "Notepad" file (.txt) mus rau Microsoft Excel ntawv (.xlsx) li cas Windows 10.

cov kauj ruam

Hloov Notepad rau Excel Kauj Ruam 1
Hloov Notepad rau Excel Kauj Ruam 1

Kauj Ruam 1. Qhib Microsoft Excel

Txhawm rau nrhiav nws sai, ntaus excel hauv Windows tshawb nrhiav bar thiab nyem rau ntawm lub cim uas yuav tshwm sim.

Hloov Notepad rau Excel Kauj Ruam 2
Hloov Notepad rau Excel Kauj Ruam 2

Kauj Ruam 2. Nyem rau ntawm File menu hauv lub kaum sab laug sab sauv ntawm lub qhov rais

Hloov Notepad rau Excel Kauj Ruam 3
Hloov Notepad rau Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Qhib

Hloov Notepad rau Excel Kauj Ruam 4
Hloov Notepad rau Excel Kauj Ruam 4

Kauj Ruam 4. Xaiv Cov Ntawv Cov Ntaub Ntawv los ntawm cov ntawv "Hom ntawv" nco-down ntawv qhia zaub mov

Hloov Notepad rau Excel Kauj Ruam 5
Hloov Notepad rau Excel Kauj Ruam 5

Kauj Ruam 5. Xaiv cov ntawv uas koj xav hloov pauv thiab nyem Qhib

Tom qab ntawd "Cov Ntawv Ntsuam Xyuas Ntsuas" yuav qhib.

Hloov Notepad rau Excel Kauj Ruam 6
Hloov Notepad rau Excel Kauj Ruam 6

Kauj Ruam 6. Xaiv hom ntaub ntawv thiab nyem Next

Hauv ntu "Thawj Cov Ntaub Ntawv", xaiv delimited (yog tias cov ntawv muaj cov ntaub ntawv cais los ntawm tus lej, tabs thiab lwm txoj hauv kev) lossis tsau dav (yog tias cov ntaub ntawv tau ua kab nyob hauv kab nrog qhov chaw nruab nrab ntawm txhua daim teb).

Hloov Notepad rau Excel Kauj Ruam 7
Hloov Notepad rau Excel Kauj Ruam 7

Kauj Ruam 7. Xaiv cov kab zauv zauv lossis dav thiab nyem Next

  • yog koj xaiv Delimited ntawm lub vijtsam dhau los, xaiv lub npov nyob ib sab ntawm lub cim (lossis "Chaw" yog cais los ntawm ib qho 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 cov ntaub ntawv kom raug.
Hloov Notepad rau Excel Kauj Ruam 8
Hloov Notepad rau Excel Kauj Ruam 8

Kauj Ruam 8. Xaiv kab ntawv hom ntawv

Xaiv qhov kev xaiv hauv qab "Kab Ntawv Cov Qauv" uas piav qhia cov ntaub ntawv zoo tshaj plaws hauv kab ntawv (xws li: Ntawv los yog Hnub tim).

Hloov Notepad rau Excel Kauj Ruam 9
Hloov Notepad rau Excel Kauj Ruam 9

Kauj Ruam 9. Nyem Ua tiav

Tom qab ntawd lub qhov rai "Save As" yuav qhib.

Hloov Notepad rau Excel Kauj Ruam 10
Hloov Notepad rau Excel Kauj Ruam 10

Kauj Ruam 10. Xaiv Excel Workbook (*.xlsx) los ntawm "Save as type" ntawv qhia zaub mov nyob hauv qab ntawm lub qhov rais

Hloov Notepad rau Excel Kauj Ruam 11
Hloov Notepad rau Excel Kauj Ruam 11

Kauj Ruam 11. Npe lub npe ntawv thiab nyem Txuag

Tam sim no cov ntawv sau tau khaws tseg ua phau ntawv Excel.

Pom zoo: