Contact field line returns jump rows in Excel

[Guest]

I use table view in contacts and generate an Excel spreadsheet by dragging
onto the task bar and placing the highlighted data into a blank excel
spreadsheet. I have a problem with data in text files that have line returns.
Whenever the placed data encounters a line return, a new row is created in
Excel. How do I get the entire contact field in outlook to stay put in one
cell in Excel?

 

[Sue Mosher [MVP-Outlook]]

You'd have to remove the line feed or use a different export method.