View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default One VERY LONG row... break it down?

No, there is NOTHING there... I went through and tried each delimiter
within Excel and none of the options did anything.

"David McRitchie" wrote:

Better to fix it at the source if you can,
you really should have each employee on it's own
row, and some kind of delimiter between each field.
There is the remote possible that such delimiters are present and you
don't see them -- do you have square bullets between data items.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Jeffrey W. Smith" wrote in message ...
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!