Export test cases to excel breaks up text lines

Question

When I export a set of test cases to an Excel xls file, the text within each cell is realigned with the "carriage return" character breaking up several words of text into its own line, instead of leaving it as one paragraph.&nbsp; How do I work around this issue?&nbsp; It is difficult for my testers to deal with this format. For example, the text in the cell will be written in Zephyr as one block paragraph, such as:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Validate the amount offered is entered into the Amount field"&nbsp;In the exported file in Excel, it will appear as:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Validate the amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;offered&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;is entered into&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;the Amount field".&nbsp;I copied/pasted the text into a Word doc to see what formatting character was placed at the end of each phrase and it shows there is a carriage return character thus breaking it up within the cell.&nbsp;&nbsp;Any ideas on how to prevent this from happening?&nbsp; Going through thousands of cells to manually correct this is not an option.

misterb · Answer

I don't know how to prevent this happening but you might be able to fix it to some degree in Excel by using Find &amp; Replace (CRTL+H) and then in the Find box pressing CTRL+J, and placing a SPACE BAR into the Replace box or try leaving it blank.&nbsp; Slightly more info below and at this URL:&nbsp;
&nbsp;

Press&nbsp;Ctrl+H&nbsp;from the keyboard. As a result, the&nbsp;Find and Replace&nbsp;window will pop up. Now, go to the&nbsp;Find what&nbsp;field and press&nbsp;Ctrl+J. A dot&nbsp;(.)&nbsp;will show up in the box. Keep&nbsp;Replace with&nbsp;field blank. Finally, click the&nbsp;Replace All&nbsp;button.

Forum Discussion

Export test cases to excel breaks up text lines

1 Reply

Related Content

Test Cases export to excel

export ALL test cases

Test Case Export to Excel

Break Point

Export Test cases as xml files

Recent Discussions

JQL functions not available

Test planning / scheduling

jql query help

kanban boards

Atlassian Team24