Stop Excel from Formatting Copied Data from Outlook
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.
|