How do I separate this data ?

[radar2000]

Hi everyone.

I have an excel file which has a column of data that has been compiled together.

For example, the cell contains...

Bob,Jones,March,2000

I need it to separate into individual columns, such as...

A1 A2 A3 A4
Bob Jones March 2000

If anyone could help me out here, that would be appreciated.

Thank you.

 

[Aladin Akyurek]

On 2002-05-10 12:29, radar2000 wrote:
Hi everyone.

I have an excel file which has a column of data that has been compiled together.

For example, the cell contains...

Bob,Jones,March,2000

I need it to separate into individual columns, such as...

A1 A2 A3 A4
Bob Jones March 2000

If anyone could help me out here, that would be appreciated.

Thank you.

Data|Text to Columns

with "," as delimiter.