In your report, if you have column headers, make sure that you line up the data field with the left-hand side of the column header.  Also, if you're exporting to Excel, your best bet is to use the "Excel - Data Only" export.

 

If you're trying to combine two fields together, one of the easiest ways is to put a text box on the report and put the fields inside the text box with a space between them.  If you put them in two separate fields outside of a text box, you'll get extra spaces between the two and it will look something like this:

 

Mr.     John Smith

Mrs.   Judy Jones

 

If you put them in a text block, they'll look like this:

 

Mr. John Smith

Mrs. Judy Jones

 

-Dell