this is an ongoing issue and hence i normally do not export instead follow the below mentioned workaround which you may also try:
1) create a customized View / modify the existing view with all required fields in the view 2) Go to File --> Print Setup --> Table 3) Go to File --> Print Preview 4) now, when the data is displayed in a preview, I either copy, go to excel and paste the contents, or 5) Click on "Publish..." button and save the output in an html format. you may still open this html file via excel
you have included the "information Field" into the view and those black blocks that you see on the view is nothing other than the "enter keys" or the new line characters which we cannot do to remove them.
the only way that i think for now is to export into html format and try opening that in excel. however would try for myself and if i get to know of any workaround that solves this, i would definately post it for you