Hi,

I have exported about 500 e-mails from outlook to excel. All of the e-mails
are the same. Here is a sample of what the exported information looks like
in Excel. Everything is in one field or cell and separated by two Enter key
strokes. Boxes which represent the enter key appear in excel as boxes but
did not show when I posted the data into this web page.

'Name: Chuck Wildeman

Address: 123 Main Street

City: Atlanta

State: GA

Zip: 30533

Is there a way to separate all of this data into separate field that all
appear in one row? So I would want it to look like the following:

Column B Column C Column D Column E Column F
Chuck Wildeman 123 Main St Atlanta GA 30533




--
Chuck W