RollNo |
Name |
Address |
12101 |
Nietha |
Mylapore,Chennai |
12102 |
Lavanya |
Adyar,Chennai |
12103 |
Ram |
Gopalapuram,Chennai |
To retain the commas in “Address” column, you can enclose the fields in quotation marks.
For example:
RollNo, Name, Address
12101, Nivetha, “Mylapore, Chennai”
12102, Lavanya, “Adyar, Chennai”
12103, Ram, “Gopalapuram, Chennai”
As you can see, only the fields that contain commas are enclosed in quotes. If you open this in MS Excel, It looks like as follows