So you also have a comma after the 5th field of the record and before
next record starts? Or is the date stuck to the name of the next
record?

Kostis

moussant wrote:
Thanks to both of you. I don't know what text to columns is (I just saw
import from text file) but I will go and explore as soon as I finish
this message.
Dave, not quite. It is an external file but unfortunately it does not
have 5 fields per row although it should. The external file is one
continuous, comma separated line. However, the five fields keep
repeating such as:
Name,Address,Phone,Email,Date,Name,Address,Phone,E mail,Date,Name etc.
So, when imported into Excel, they display the same way, in one long
line. I'm looking for a way to import and then display:
Name,Address,Phone,Email,Date
Name,Address,Phone,Email,Date
Name,Address,Phone,Email,Date
and thought maybe there was some way to "fix" the number of columns to
5 so that it would be forced to drop down to the next line (row) after
5 entries.
Thank you,
Gary