Separate data values with Commas or Semicolons in CSV - Excel

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 ?
03 Nov 2019 at 04:05 PM
0pnshow more

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:
16 Nov 2019 at 05:14 PM
0pnshow more
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2022 AnswerTabsTermsContact us