Hi all,
wanted to ask you for help/information how to resolve an issue I have when I open CSV file in Excel 2003.
I have CSV file with this structure:
CountryCode|CompanyName|Adress Line 1|Street Number
US|123 Company|Street 5, block D|25
This file can be opened by Excel, but in all the places where we can see a comma "," (in above example "Street 5, block D") Excel eats comma including all the text behind it. So the result in the Excel will be:
CountryCode|CompanyName|Adress Line 1|Street Number
US|123 Company|Street 5|25
Is this something in the configuration/settings of the Excel itself?
Thanks for your advices
LT
Bookmarks