View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Excel worksheet moved all data from multipl cells into one

Step 1 is make a backup copy of your file so you don't lose data while
figuring out the best way to do this.

You may be able to use (on the Excel menu) Data Text to Columns.
This function takes a single cell full of data and parses it into
columns according to parameters you select. This can be dicey, though,
because your data may differ from row to row.

Can you return to the other software package, and export the data
again? If you can specify CSV (comma separated values) output, the
commas will assist in importing the data into a sprdsht.

Dave O
Eschew obfuscation