Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

Breaking out data in one cell to seperate cells

Posted by Tim on January 07, 2001 5:28 PM
I have an excel spreadsheet the was written by another person. It's a list of names and adresses but the data is all in one cell. How can I reformat it to breakout the name, address, city, state, zip etc into their own cells so I can use it for mail merge?

Re: Breaking out data in one cell to seperate cells

Posted by Dave Hawley on January 07, 2001 8:54 PM


Hi Tim

Select the cell and go to Data>Text to columns...

Follow the Wizard. May take you some trial and error. If you get stuck just yell.

Good luck

Dave


Re: Breaking out data in one cell to seperate cells

Posted by Tim on January 09, 2001 10:46 AM

Dave,
that did the trick...thanks for your help.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.