auto import date/time from .txt file

D

D. Reid

is it possible for excel to automatically import date/time
info from a .txt file in the following format:

"LASAIR110","04/05/19","15:47:41",2700.0,45.00,"V6.3",0,0,0
,1,433,486,236,113,294,196,103,328,4.993,1.0000,0.000,0.000
,0.000,0.000,0.000,"22de",
"LASAIR110","04/05/19","16:33:15",2700.0,45.00,"V6.3",0,0,0
,1,458,432,163,55,107,55,46,139,5.007,1.0000,0.000,0.000,0.
000,0.000,0.000,2299,

thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic date/time aquisition for graphs 2
Problem formatting dates from CSV file 2
Paste to excel from word - auto format problem 1
Calculating Work Time 7
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule 0
Conditional Formatting 0
Re posting - Transpose employee data from Columns to Rows 0
Find then highlight in yellow 6

Top