Automatic date/time aquisition for graphs

[DrD525]

Ok, I collect particle count data for a cleanroom which looks like th
following:

"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

"LASAIR110","04/05/19","17:18:49",2700.0,45.00,"V6.3",0,0,0,1,305,286,76,29,14,1,0,0,5.017,1.0000,0.000,0.000,0.000,0.000,0.000,2224


Is there any way excel can read the .txt file and automatically impu
the date/time into a spreadsheet? Thanks in advance

 

[Peo Sjoblom]

If it always start with the same string and you could use

=--SUBSTITUTE(SUBSTITUTE(MID(A1,FIND(",",A1)+1,21),","," "),"""","")

format as mm/dd/yy hh:mm:ss

of course this assumes that your examples are in 3 different cells




--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[jeff]

Hi,

I'm not sure I fully understand your question; if you
open the file from within Excel, and set as delimited
with comma, the date and time in fields 2 & 3
automatically are read.

Are you looking for an automatic timestamp for when
the file is read in?? That is possible with a simple
macro.

jeff