Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2015, 05:09 PM
Austcart Austcart is offline How do I separate an address into separate cells Windows 7 32bit How do I separate an address into separate cells Office 2013
Novice
How do I separate an address into separate cells
 
Join Date: Jan 2015
Posts: 2
Austcart is on a distinguished road
Smile 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.
Reply With Quote
  #2  
Old 01-18-2015, 05:46 AM
thetraininglady thetraininglady is offline How do I separate an address into separate cells Windows 7 64bit How do I separate an address into separate cells Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 01-18-2015, 03:48 PM
Austcart Austcart is offline How do I separate an address into separate cells Windows 7 32bit How do I separate an address into separate cells Office 2013
Novice
How do I separate an address into separate cells
 
Join Date: Jan 2015
Posts: 2
Austcart is on a distinguished road
Default Tku

Thank you that worked great.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I separate an address into separate cells 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
How do I separate an address into separate cells 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


All times are GMT -7. The time now is 02:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft