Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 10th 12, 04:20 AM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 1
Default 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   Report Post  
Old April 10th 12, 11:38 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split data in cells Neil Excel Discussion (Misc queries) 5 February 28th 08 10:05 PM
How do i split data into individual cells Kelly Excel Discussion (Misc queries) 1 February 25th 08 09:50 AM
how can I split one cell's data into two cells? Excel Worksheet Functions 3 May 15th 06 01:19 AM
how can I split one cell's data into two cells? Excel Discussion (Misc queries) 2 May 14th 06 10:54 PM
how can I split one cell's data into two cells? New Users to Excel 1 May 14th 06 10:49 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017