I've been trying that, but there are no punctuation marks (commas, tabs..)
In cell A1 is a name, A2 is address, A3 is city, A4 is state, A 5 is zip, A6
is name, A7 is address, etc.

"Jeffrey W. Smith" wrote:

Lisa,

You can try experimenting with the Data | Text to Column feature, using
different delimiters (Space, Tab, etc.)

HTH,

Jeff

"Lisa" wrote in message
...
I have imported general information for about 300 employees into Excel, but
it all went into just ONE row. Is there a way to break it out into the
appropriate rows? (Name, address, city, state, zip, age, gender, etc.)

Thanks!