How do I separate an address into separate cells

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-18-2015, 05:46 AM

thetraininglady thetraininglady is offline

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

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.

« Previous Thread | Next Thread »

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 06:47 AM.