Cov txheej txheem:

Kuv yuav ua li cas thiaj tsim tau cov ntawv cim cim cim hauv Excel?
Kuv yuav ua li cas thiaj tsim tau cov ntawv cim cim cim hauv Excel?

Video: Kuv yuav ua li cas thiaj tsim tau cov ntawv cim cim cim hauv Excel?

Video: Kuv yuav ua li cas thiaj tsim tau cov ntawv cim cim cim hauv Excel?
Video: Cas Tsis Xaiv Koj - R-Lin Thoj New Song Original By Zaj Dub [Official MV] 2023 2024, Kaum ib hlis
Anonim

Txhawm rau txuag cov ntaub ntawv Excel ua cov ntaub ntawv comma-delimited:

  1. Los ntawm cov ntawv qhia zaub mov bar, Cov ntaub ntawv → Txuag li.
  2. Tom ntej no mus rau "Format:", nyem lub drop-down ntawv qhia zaub mov thiab xaiv " Comma Separated Values ( CSV )”
  3. Nyem "Save"
  4. Excel yuav hais ib yam dab tsi zoo li, "Qhov no phau ntawv ua haujlwm muaj cov yam ntxwv uas yuav tsis ua haujlwm…”. Tsis quav ntsej qhov ntawd thiab nyem “Txuas ntxiv”.
  5. Tawm Excel .

Hauv qhov no, kuv yuav ua li cas thiaj tsim tau cov ntaub ntawv comma delimited hauv Excel?

Nyem qhov " Cov ntaub ntawv " tab nyob rau sab saum toj ntawm lub vijtsam thiab xaiv "Txuag Raws li." Thaum Txuag Raws li qhov rais loads, ntaus lub npe ntawm koj. ntaub ntawv nyob rau hauv " Cov ntaub ntawv Lub npe” teb. Nyem rau ntawm lub xub-down ib sab ntawm "Txuag li hom." Xaiv "CSV ( Kev txwv tsis pub dhau ) (*.csv)" los ntawm cov npe uas muaj peev xwm ntaub ntawv hom.

Ib yam li ntawd, koj yuav khaws cov ntaub ntawv li CSV li cas? Qhib koj cov ntaub ntawv hauv koj qhov kev pab cuam spreadsheet.

  1. Nyem rau ntawm Cov Ntaub Ntawv thiab xaiv Txuag Raws li.
  2. Xaiv qhov chaw koj xav txuag cov ntaub ntawv, tom qab ntawd nyob rau hauv Txuag astype, xaiv CSV (Comma delimited). Nyem Txuag.
  3. Koj tuaj yeem pom cov lus hais tias qee qhov nta "tej zaum yuav ploj yog tias koj khaws nws ua CSV".

Raws li txoj cai, kuv yuav khaws cov ntawv nyeem li Excel li cas?

Cov kauj ruam los hloov cov ntsiab lus los ntawm TXT lossis CSV Cov Ntaub Ntawv rau hauv Excel

  1. Qhib Excel spreadsheet qhov twg koj xav txuag cov ntaub ntawv thiab nyem rau ntawm cov ntaub ntawv tab.
  2. Hauv Pawg Tau Txais Cov Ntaub Ntawv Sab Nraud, nyem Los Ntawm Cov Ntawv.
  3. Xaiv cov TXT lossis CSV cov ntaub ntawv koj xav hloov thiab nyem Import.
  4. Xaiv "Delimited".
  5. Nyem Next.

Dab tsi yog qhov delimiter hauv Excel?

nrog tus cim xws li lub cim (,). Cov cim no hu ua lub teb cais lossis tus lej . Thaum twg lub fieldseparator ( tus lej ) yog comma, cov ntaub ntawv yog incomma-separated (CSV) lossis comma-delimited hom. Lwm nrov tus lej yog tab.

Pom zoo: