Excel Help Needed Urgently!

[d|b]

I have a some CSV data which I have opened in Excel and it looks like this:

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!

 

[fretted]

I have a some CSV data which I have opened in Excel and it looks like this:

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!

Highlight cell
Data->Text to Columns

 

[d|b]

Thanks very much