| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Split data in cells
hi
i have a list of names and addresses that I would like to split out for mail merge purposes. How can I separate the address from the suburb state and postcode so they are each in to different columns Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Split data in cells
On Tue, 10 Apr 2012 03:20:10 +0000, Happychappers wrote:
hi i have a list of names and addresses that I would like to split out for mail merge purposes. How can I separate the address from the suburb state and postcode so they are each in to different columns Thanks One way: Use the Data/Text to columns wizard specifying the appropriate delimiter in your text string. Without comprehensive examples of the format of your data, I cannot give you any further advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split data in cells | Excel Discussion (Misc queries) | |||
| How do i split data into individual cells | Excel Discussion (Misc queries) | |||
| how can I split one cell's data into two cells? | Excel Worksheet Functions | |||
| how can I split one cell's data into two cells? | Excel Discussion (Misc queries) | |||
| how can I split one cell's data into two cells? | New Users to Excel | |||
Hybrid Mode
