#1
|
|||
|
|||
How do I separate an address into separate cells
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
|
|||
|
|||
Tku
Thank you that worked great.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get multiple cells in separate worksheet | 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 |
Can I use the filter function to separate letters into separate files? | 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 |