Zoltan_Gyimesi
Legendary Poster
Excel doesn\'t split cells automatically opening CSV file
Hi JDEList!
I have created CSV output from OneWorld following the instructions of ott-00-0047 documentation.
The file correctly created but opening the CSV file with Excel, loads the entire row into Column A instead of splitting the row into cells at the commas. So, I have to split Column A into several field manually using the Data / Text To Columns... Excel function. It's OK for me but is not for the end user.
I didn't find any setting in Excel to set up the splitting automatically when I open CSV file.
Any help, hint, guideline will be greatly appreciated.
Regards,
Zoltán
Hi JDEList!
I have created CSV output from OneWorld following the instructions of ott-00-0047 documentation.
The file correctly created but opening the CSV file with Excel, loads the entire row into Column A instead of splitting the row into cells at the commas. So, I have to split Column A into several field manually using the Data / Text To Columns... Excel function. It's OK for me but is not for the end user.
I didn't find any setting in Excel to set up the splitting automatically when I open CSV file.
Any help, hint, guideline will be greatly appreciated.
Regards,
Zoltán