Lowetsani ndi kutumiza mafayilo amawu ku Excel

• Lowani
• Tumizani

Nkhaniyi ikufotokoza momwe mungatengere kapena kutumiza mafayilo amawu. Mafayilo amawu amatha kulekanitsidwa ndi koma (.csv) kapena ma tabu (.txt).

Lowani

Kuti mutenge mafayilo amawu, tsatirani malangizo athu:

1. Pa Advanced tabu Filamu (Fayilo) dinani Open (Otsegula).
2. Kuchokera dontho pansi mndandanda kusankha Zolemba Zolemba (Mafayilo alemba).
3. Kuti mutenge fayilo…
   • CSV, sankhani chikalata chokhala ndi zowonjezera . Csv Ndipo dinani Open (Otsegula). Ndizo zonse.
   • TXT, sankhani chikalata chokhala ndi zowonjezera .ndilembereni ndipo dinani Open (Otsegula). Excel idzayamba Wowonjezera Wolemba Zolemba (Wizard of texts (kulowetsa)).
4. Sankhani Malire (ndi olekanitsa) ndikusindikiza Ena (Zowonjezera).
5. Chotsani mabokosi onse kupatula omwe akutsutsana nawo Tab (Tab) ndikudina Ena (Zowonjezera).
6. Press chitsiriziro (Okonzeka).

Zotsatira:

Tumizani

Kuti mutumize bukhu lantchito la Excel ku fayilo yolemba, chitani izi:

1. Tsegulani chikalata cha Excel.
2. Pa Advanced tabu Filamu (Fayilo) dinani Sungani Monga (Sungani ngati).
3. Kuchokera dontho pansi mndandanda kusankha Mawu (Tabu yodulidwa) (Mafayilo amawu (tabu yosinthidwa)) kapena CSV (Comma delimited) (CSV (yolekanitsidwa ndi koma)
4. Press Save (Sungani).

Zotsatira: CSV file (comma delimited) ndi TXT file (tabu delimited).