I have a some CSV data which I have opened in Excel and it looks like this:
This string contains 6 data points separated by ";"
All of the data points are currently in one cell.
Is there anyway that I can can automatically separate each of the data points into individual columns instead of having them all in one cell?
Thanks!
Code:
79034011991;08245;01.02.2009 00:30:11;213;240;Ðîñòîâñêàÿ îáëàñòü
This string contains 6 data points separated by ";"
All of the data points are currently in one cell.
Is there anyway that I can can automatically separate each of the data points into individual columns instead of having them all in one cell?
Thanks!