Comma Separated Values 1

[TeresaSalesPlus]

Hi,

I opened a .csv file in excel a couple days ago and each field appeared in its own column (good).

I re-opened the same file again, and now all the values are smooshed into the first cell of each row (bad).

Is there any way I can revert the file back to the way it was when I first opened it? Will I be able to save it in the right format?

Thanks,

TSP

 

[SkipVought]

Hi,

If your file has COMMA separated fields, it will OPEN in Excel.

Your SMOOSHED data probably has SEMICOLONS or something else separating the data.

To parse your data,

1. select the column containing the data

2. Data > Text to columns...

3. DELIMITER option

4. Select the appropriate delimiter(s)

5. Select each column's proper data type.

6 FINISH

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}