Forum Home
Press F1
Thread ID: 16500	2002-03-10 07:02:00	Import delimited text into Excel	Guest (0)	Press F1

Post ID	Timestamp	Content	User
38572	2002-03-10 07:02:00	I have a delimited text file froma data logger. The data for each day appears on a new line separated by commas. ie. #2002-02-27 17:05:09#,20.8,0,53,0,302,4,0,1020,0,0 I need to import the data so that it recognises the commas as a column....	Guest (0)
38573	2002-03-10 07:36:00	First, for some reason your post came up on my computer as a blank screen. Searched for it by date and it was OK. If you don't get other replies it might pay to post again. I'd suggest you open Excel then select File, Open, Change file type to Text File (if it's a text file) and Open it. This should bring up the csv wizard. Select 'delimited', press 'Next' and under delimiters select 'comma'. If it's not how you want it, close without saving and try again.	Guest (0)
38574	2002-03-10 07:46:00	Thanks heather, it worked a treat.... why the help file didn't tell me that I don't know - it didn't have any entries for delimited... Thanks again.	Guest (0)
38575	2002-03-10 07:46:00	Thanks Heather, it worked a treat.... why the help file didn't tell me that I don't know - it didn't have any entries for delimited... Thanks again.	Guest (0)
1