How do I separate an address into separate cells

		Microsoft Office Forums > Microsoft Excel > Excel
How do I separate an address into separate cells

01-17-2015, 05:09 PM

Austcart

Windows 7 32bit How do I separate an address into separate cells

Office 2013

Novice

Join Date: Jan 2015

Posts: 2

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:19 AM.