#1   Report Post  
Nick Hodge
 
Posts: n/a
Default

Mindy

A carriage return is automatically the delimiter for the next *record*
(Rows) what you need is the delimiter between fields, (Columns). If there is
no delimiter to be seen in the file, then it is possible the fields are
'fixed width'. This option can be set on the first screen of the text import
wizard.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Mindy" wrote in message
...
Hello, I'm still trying to import a .txt file into excel. I just learned
that the text file is divided into records by a carriage return. My
problem
is in Excel I don't see a delimiter like a carriage return or enter. am I
missing something? Mindy



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import comma delimited text Lin Excel Discussion (Misc queries) 3 July 28th 06 04:07 PM
import select data from another workbook schoeller Excel Worksheet Functions 0 March 31st 05 03:13 AM
Import Excel Data from another workbook or file tamato43 Excel Discussion (Misc queries) 1 February 28th 05 05:26 PM
Automatic Data Import TxRaistlin Excel Discussion (Misc queries) 2 February 4th 05 10:43 PM
Importing Question! Otto Moehrbach Excel Discussion (Misc queries) 0 November 26th 04 07:04 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"