ExcelBanter - DE "concatonate" Undo it

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - DE "concatonate" Undo it (https://www.excelbanter.com/new-users-excel/174049-de-concatonate-undo.html)

DE "concatonate" Undo it

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

DE "concatonate" Undo it

On Tue, 22 Jan 2008 17:52:34 -0800, pcor
wrote:

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