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
|