View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jeffrey W. Smith Jeffrey W. Smith is offline
external usenet poster
 
Posts: 9
Default One VERY LONG row... break it down?

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!