Forum Discussion

AlexUldis's avatar
AlexUldis
Experienced User
6 months ago

Export to Excel - Some fields contain line breaks

In the last month or two (since early Sept) I note that some fields exported to excel now contain 'line breaks' aka 'carriage returns'. My specific example is the Items Register [Detail] report, whe...
AlexUldis's avatar
AlexUldis
Experienced User
6 months ago

Hello Sai,

I am not using Alt+Enter, or entering the data. 

The Line Break is added during the export process from MYOB to excel. 

I was just explaining how to replicate the problem, but the problem is generated during the export process.

 

I have found a way to remove the Line Break during my further analysis in excel, but I don't think MYOB should be adding the line breaks to the exported data in the first place.  The fact that it only affects "Item Numbers" and "Names" starting with a "0", at that it only started occuring in the last 4 or 5 weeks, suggests to me that there is a bug in the export process.

 

Interchange1's avatar
Interchange1
Experienced User
6 months ago

Hi  

I am having the same issue with an export of employee card files.  A number of the lines have been broken up into 2 separate lines.  This seems to be happening in groups of employees, some are correct and some are broken,  and I haven't found out why.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.