Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel

Hōʻike kēia ʻatikala pehea e hoʻokomo ai i nā faila kikokikona. Hiki ke hoʻokaʻawale ʻia nā faila kikokikona e nā koma (.csv) a i ʻole nā ​​pā (.txt).

Import

No ka lawe ʻana i nā faila kikokikona, e hahai i kā mākou ʻōlelo kuhikuhi:

  1. Ma ka ʻaoʻao kiʻekiʻe Fillet (File) kaomi Open (Wehe).
  2. Mai ka papa kuhikuhi koho Waihona Kikokikona (Nā waihona kikokikona).
  3. No ka lawe ʻana i kahi faila…
    • CSV, koho i palapala me ka hooloihi . Csv A e kaomi i Open (Wehe). ʻO ia wale nō.
    • TXT, koho i palapala me ka hooloihi .txt ae kaomi ma Open (Wehe). E hoʻomaka ʻo Excel Wizard lawe kikokikona (Wizard of texts (import)).
  4. E koho i Hoʻokaʻawale ʻia (me nā mea hoʻokaʻawale) a paʻi Aʻe (ʻOi aku).Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel
  5. Wehe i nā pahu pahu a pau koe ka ʻaoʻao Kuhi (Tab) a kaomi Aʻe (ʻOi aku).Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel
  6. Press a pau (Makaukau).Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel

Hualoaʻa:

Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel

mea hoʻolilo

No ka lawe ʻana i kahi puke hana Excel i kahi faila kikokikona, e hana i kēia:

  1. E wehe i kahi palapala Excel.
  2. Ma ka ʻaoʻao kiʻekiʻe Fillet (File) kaomi E mālama i (Save as).
  3. Mai ka papa kuhikuhi koho Kikokikona (Kakau palena ʻia) (Nā waihona kikokikona (palena ʻia ka pā)) a i ʻole CSV (Wehe ʻia nā piko) (CSV (hoʻokaʻawale ʻia e nā koma)).Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel
  4. Press Save (Mālama).

Ka hopena: waihona CSV (wehe ʻia ka piko) a me ka faila TXT (wehe ʻia ka pā).

Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel Hoʻokomo a hoʻokuʻu aku i nā faila kikokikona i Excel

Waiho i ka Reply