how to convert .txt file to excel file?
Posted: Wed Jun 09, 2010 10:05 am
how to convert .txt file to excel file?
(.txt file) [highlight=red](date and time have not separated)[/highlight]
20100602 094500; 19577; 19620; 19558; 19609; 895
20100602 094601; 19606; 19686; 19606; 19650; 825
20100602 094700; 19647; 19665; 19640; 19654; 617
(excel file) [highlight=red](date and time have separated)[/highlight]
2/6/2010 09:45:00 19577 19620 19558 19609 895
2/6/2010 09:46:01 19606 19686 19606 19650 825
2/6/2010 09:47:00 19647 19665 19640 19654 617
(.txt file) [highlight=red](date and time have not separated)[/highlight]
20100602 094500; 19577; 19620; 19558; 19609; 895
20100602 094601; 19606; 19686; 19606; 19650; 825
20100602 094700; 19647; 19665; 19640; 19654; 617
(excel file) [highlight=red](date and time have separated)[/highlight]
2/6/2010 09:45:00 19577 19620 19558 19609 895
2/6/2010 09:46:01 19606 19686 19606 19650 825
2/6/2010 09:47:00 19647 19665 19640 19654 617