Forum Discussion

AlexUldis's avatar
AlexUldis
Experienced User
4 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...
Isaiah_C's avatar
Isaiah_C
MYOB Moderator
4 months ago

Hi AlexUldis,

 

That's a bit odd, especially when it affects how your spreadsheets line up. You might want to give this a go. Instead of using Alt + Enter, try using the Tab key when entering data. It can help avoid those line breaks showing up in Excel. 

 

Hopefully one of our legends here in the Community also jumps in with another handy fix.

 

Regards,

Sai

Looking for something else?

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

Community home

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