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?

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

OzGrid Business Applications

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

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