creating a mailing list separating name, street address, city, state and zip code to export to excel for envelope printing

Hi there, @YaYa2. The way data appears in your Excel report depends on how it is customized in QuickBooks Desktop (QBDT).

Since the information is combined into a single column, let's test whether this is a company file issue by opening a sample company file. Then, run the same report and export it to Excel.

If you experience the same result, let's take a closer look at your company file using the Verify and Rebuild Data tool. Before starting, create a backup copy of your company's file to protect your data. 

Now, here's how to verify your company data:
 

1. Proceed to the Window tab, then Close All.
2. Click on File and select Utilities.
3. Choose Verify Data. Hit OK.
    

After that, follow these steps to rebuild your company data:
 

1. Go to the File menu, then choose Utilities.
2. Select Rebuild Data. Pick, OK.
3. Save your backup, and OK.
4. When the Rebuild has completed message appears, click OK.

If the issue continues, please ensure your Microsoft Excel is up to date, as outdated versions can affect how data is properly exported or read.

I am always here to help if you have further questions. Please click the Reply button below, and I'll get back to you.

Hi, @YaYa2.

Just checking in to see if the solution we shared worked for you. Did it fix the issue, or are you still having trouble?

Happy to help if you need any more assistance!