Yuav Ua Li Cas Luam Paste Tab Delimited Text Into Excel: 10 Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Luam Paste Tab Delimited Text Into Excel: 10 Kauj Ruam
Yuav Ua Li Cas Luam Paste Tab Delimited Text Into Excel: 10 Kauj Ruam

Video: Yuav Ua Li Cas Luam Paste Tab Delimited Text Into Excel: 10 Kauj Ruam

Video: Yuav Ua Li Cas Luam Paste Tab Delimited Text Into Excel: 10 Kauj Ruam
Video: Военные тактические часы-Топ-10 самых жестких военных ч... 2024, Lub peb hlis ntuj
Anonim

Excel feem ntau tuaj yeem txheeb xyuas cov ntawv uas sib cais los ntawm tabs (tab-delimited) thiab muab cov ntaub ntawv tso rau hauv kab sib cais. Yog tias qhov no tsis ua haujlwm, thiab txhua yam koj tau muab tso rau hauv ib kab lus, tom qab ntawd Excel tus lej cim tau teeb tsa rau lwm tus cim, lossis koj cov ntawv siv qhov chaw tsis siv tabs. Cov ntawv rau kab ntawv cuab yeej hauv Excel tuaj yeem xaiv qhov ua kom raug sai thiab faib cov ntaub ntawv rau hauv kab kom raug.

Cov kauj ruam

Luam Paste Tab Delimited Text Into Excel Step 1
Luam Paste Tab Delimited Text Into Excel Step 1

Kauj Ruam 1. Luam tag nrho koj cov ntawv tab-delimited

Tab-delimited ntawv yog hom ntawv khaws cia cov ntaub ntawv los ntawm daim ntawv nthuav tawm ua cov ntawv. Txhua lub xov tooj ntawm tes tau sib cais los ntawm qhov chaw nres tsheb, thiab txhua cov ntaub ntawv muaj nyob ntawm kab sib cais hauv kab ntawv. Xaiv tag nrho cov ntawv koj xav theej rau Excel thiab luam nws rau hauv koj daim ntawv teev cia.

Luam Paste Tab Delimited Text Into Excel Step 2
Luam Paste Tab Delimited Text Into Excel Step 2

Kauj Ruam 2. Xaiv lub cell hauv Excel uas koj xav muab lo rau

Xaiv lub cell sab saud sab laug uas koj xav kom koj cov ntaub ntawv dhau los tshwm rau hauv. Koj cov ntaub ntawv khaws tseg yuav sau cov cell hauv qab no thiab rau sab xis ntawm koj lub xov tooj pib.

Luam Paste Tab Delimited Text Into Excel Step 3
Luam Paste Tab Delimited Text Into Excel Step 3

Kauj Ruam 3. Muab tshuaj txhuam cov ntaub ntawv

Hauv cov ntawv tshiab ntawm Excel, thiab yog tias koj cov ntaub ntawv raug txiav txim siab kom raug nrog tab nres, cov cell yuav tsum sau kom raug nrog cov ntaub ntawv raug. Txhua lub tab nres yuav tsum txhais ncaj qha rau hauv lub cell tshiab rau cov ntaub ntawv. Yog tias txhua yam ntawm koj cov ntaub ntawv tshwm nyob rau hauv ib kab, muaj lub sijhawm zoo Excel tus lej txiav tau hloov pauv los ntawm tabs mus rau lwm yam, xws li tus lej. Koj tuaj yeem hloov qhov no rov qab mus rau tabs los ntawm kev siv Cov Ntawv rau Kab Cuab Yeej.

Luam Paste Tab Delimited Text Into Excel Step 4
Luam Paste Tab Delimited Text Into Excel Step 4

Kauj Ruam 4. Xaiv tag nrho kem ntawm cov ntaub ntawv

Yog tias koj cov ntaub ntawv tab-delimited tsis tau muab tso kom raug, koj tuaj yeem siv Excel Cov Ntawv rau Kab Ntawv cuab yeej los ua kom raug. Txhawm rau ua qhov no, koj yuav tsum xaiv tag nrho kab ntawv uas muaj tag nrho cov ntaub ntawv koj tau muab tso rau.

  • Koj tuaj yeem xaiv tag nrho kab ntawv nrawm los ntawm txhaj tsab ntawv rau saum.
  • Koj tsuas tuaj yeem siv Text to Columns ntawm ib kab lus ib zaug.
Luam Paste Tab Delimited Text Into Excel Step 5
Luam Paste Tab Delimited Text Into Excel Step 5

Kauj Ruam 5. Qhib Cov Ntaub Ntawv tab thiab nyem "Cov ntawv rau kab"

Koj yuav pom qhov no hauv Pab Pawg Cov Ntaub Ntawv hauv Cov Ntaub Ntawv tab.

Yog tias koj siv Office 2003, nyem rau Cov Ntawv Qhia zaub mov thiab xaiv "Text to Columns"

Luam Paste Tab Delimited Text Into Excel Step 6
Luam Paste Tab Delimited Text Into Excel Step 6

Kauj Ruam 6. Xaiv "Delimited" thiab nyem "Next"

Qhov no yuav qhia rau Excel tias nws yuav tab tom nrhiav tus yam ntxwv tshwj xeeb los cim cov kev faib ntawm tes.

Luam Paste Tab Delimited Text Into Excel Step 7
Luam Paste Tab Delimited Text Into Excel Step 7

Kauj Ruam 7. Xaiv tus ua cim uas koj cov ntaub ntawv raug cais los ntawm

Yog tias koj cov ntaub ntawv yog tab-delimited, khij lub npov "Tab" thiab khij rau lwm lub thawv. Koj tuaj yeem tshawb xyuas cov cim sib txawv yog tias koj cov ntaub ntawv raug cais los ntawm lwm yam. Yog tias koj cov ntaub ntawv tau faib los ntawm ntau qhov chaw tsis siv lub tab nres, khij lub npov "Chaw" thiab "Kho tus lej sib law liag ua ib qho" lub thawv. Nco ntsoov tias qhov no yuav ua teeb meem yog tias koj muaj chaw nyob hauv koj cov ntaub ntawv uas tsis qhia txog kev faib pawg.

Luam Paste Tab Delimited Text Into Excel Step 8
Luam Paste Tab Delimited Text Into Excel Step 8

Kauj Ruam 8. Xaiv hom ntawv ntawm thawj kab ntawv

Tom qab xaiv koj tus delimiter, koj yuav tuaj yeem teeb cov ntaub ntawv hom rau txhua kab uas tau tsim. Koj tuaj yeem xaiv ntawm "General", "Text", thiab "Date".

  • Xaiv "General" rau tus lej lossis sib xyaw ntawm cov lej thiab ntawv.
  • Xaiv "Ntawv" rau cov ntaub ntawv uas tsuas yog ntawv, xws li cov npe.
  • Xaiv "Hnub" rau cov ntaub ntawv uas tau sau hauv tus txheej txheem hnub tim.
Luam Paste Tab Delimited Text Into Excel Step 9
Luam Paste Tab Delimited Text Into Excel Step 9

Kauj Ruam 9. Rov ua dua rau kab ntxiv

Xaiv txhua kab hauv kab hauv qab ntawm lub qhov rais thiab xaiv hom ntawv. Koj tseem tuaj yeem xaiv tsis suav nrog kab ntawv ntawd thaum hloov cov ntawv.

Luam Paste Tab Delimited Text Into Excel Step 10
Luam Paste Tab Delimited Text Into Excel Step 10

Kauj ruam 10. Ua tiav tus neeg ua haujlwm

Thaum koj tau teeb tsa txhua kab ntawv, nyem Ua Ntej txhawm rau siv tus lej tshiab. Koj cov ntaub ntawv yuav raug faib ua kab raws li koj Cov Ntawv rau Kab teeb tsa.

Pom zoo: