What should I do to separate text values, that include Commas in case of comma delimited CSV or Semicolons in case of semicolon delimited CSV ? How to split text values or numbers with commas or semicolons, to keep the content appearing in correct column in Excel ?
To separate text content, that includes commas in case of comma separated CSV file, or that includes semicolons in case of semicolon separated CSV file, you have to add double quotes before and after this content. The presence of double quotes will split text values correctly, and will keep them appearing in relevant columns.
Comma separated CSV should look like:
Semicolon separated CSV should look like: