DE "concatonate" Undo it

[pcor]

I have the following info in col C
7820 Jeanne D'Arc blvd, Orleans, Ontario M1C2E9
I would like to leave 7820 Jeanne D'Arc blvdin col c
and place Orleans in col d
and Ontario in col e
and M1C2E9 in col f
I have about 1500 do do\Thanks

 

[Ron Rosenfeld]

I have the following info in col C
7820 Jeanne D'Arc blvd, Orleans, Ontario M1C2E9
I would like to leave 7820 Jeanne D'Arc blvdin col c
and place Orleans in col d
and Ontario in col e
and M1C2E9 in col f
I have about 1500 do do\Thanks

Select your data in column C

Data/Text to columns
Delimited
Next
Comma
Finish

Then select the data in Column E

Data/Text to columns
Delimited
Next
Space
Finish

Since there may be spaces before the data in Column E, you may find column E
blank and have to delete it.
--ron