data is imported from a text file as comma separated

There are 4 columns, however some data in column 2 have commas in the value.
this leads to excel
shifting the data into another columns

Eg. column 3 has dates in it. but due to that extra comma in the column 2,
the text in column 2 is shifted in the column 3 (date)
and so with column 4.

Is there a way to macro this?