| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| One should be able to "jump" over undo command in Excel | Excel Discussion (Misc queries) | |||
| "Undo/Redo" Feature NOT functioning | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| With autorecover on in Excel you lose your "undo" functionality. | Excel Discussion (Misc queries) | |||
Linear Mode
