Stop Excel from Formatting Copied Data from Outlook

[Dan Holt]

I have a user with Office 2007 Pro Plus. She's attempting to copy and paste
information from MS Outlook 2007 into MS Excel 2007. When she copies data
from Outlook which contains an "address block", and then pasts that data into
a cell in MS Excel, Excel separates the "block" into multiple cells in the
spreadsheet. If she pastes the data into the formula bar, the entire "block"
appears in the single cell.

Is there a way to make the default behavior so the user can paste into the
cell directly and not have Excel "break out" the data?

Any assistance is appreciated.

 

[Dan Holt]

I've done some additional testing myself. I've created data in Word 2007,
OneNote 2007 and Outlook 2007 with the following formatting...

first last
street
city, state zip
phone

As expected, if copied and pasted into an Excel 2007 Worksheet cell, each
line is separated into a separate cell. For example "first last" goes in A1,
"street" goes in A2, "city, state zip" goes into A3, and "phone" goes into A4
if I right click in A1 and paste. However, if I select A1, click in the
formula bar and then right-click in the formula bar and paste, the entire
"block" appears in A1. My customer wants to change the default behavior to
allow her to click in A1 and paste, without "breaking out" the data "block".
Hope this clarification helps.