Lisa

Your subject line states "very long row" but it looks like you meant "very long
column".

"etc." is not too descriptive of the actual data.

Is there a consistent number of entries for each employee in the column?

i.e. 8 rows, 9 rows?

Separated by a blank row or not at each employee?

Some consistency that would allow picking and transposing the data for each
employee to one row across columns?


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 14:27:00 -0700, Lisa wrote:

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!