![]() |
#1
|
|||
|
|||
![]()
My database exports address like this in one cell: 122 ARRABARRI AVENUE, MT OMMANEY, QLD, 4074
I need to break them into 5 cells. |
#2
|
|||
|
|||
![]()
Select the column containing all the addresses, go to the Data tab and click Text to Columns button. Select data type as Delimited, click Next, select the type of delimiter as Comma and click Next, select the Destination as a new sheet or the next empty column in the worksheet so you don't overwrite your data and click Finish.
Let me know if you need more assistance. |
#3
|
|||
|
|||
![]()
Thank you that worked great.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
kerkstrt | Excel | 1 | 10-26-2014 11:20 PM |
Link cells in word doc (table) to update from 2 separate docs - can this be done? | larrens | Word | 3 | 09-15-2014 11:20 PM |
![]() |
drhauser | Mail Merge | 2 | 12-14-2011 02:18 PM |
Separate Address Book (or Contact folder) | AlanW | Outlook | 3 | 05-24-2011 11:12 AM |
Any easy way to separate a Word document into separate files? | SamHelm | Word | 0 | 08-21-2010 05:29 AM |