Gary,

Have you tried Text-to-columns?

HTH
Kostis Vezerides


moussant wrote:
I have a page of data that every field is separeted by a comma with no
*unique* delimiter at the end of a record (5 fields). When I load in
excel it produces one VERY LONG row which I can not use. Is there some
way that I can *limit* the number of columns to 5 so that it will be
forced to start a new row (like a carriage return) after 5 field
entries? I guess it's obvious that I have almost no experience with
Excel - lol.
Thank you for your help,
Gary