DE "concatonate" Undo it

  • Thread starter Thread starter pcor
  • Start date Start date
P

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
 
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
Click to expand...

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
 
Back
Top