Paste from Access
 

Excel and Access 2002 SP3

User copies a street address from a form in Access; she wants to paste it
into an Excel document. Previously created documents paste the entire
street address into a single cell. Now the address is pasted with each word
put into a separate cell.

We tried Paste Special and get the option to paste as Unicode Text or Text,
but either one still pastes each word in a separate cell. We copied her
document to a new spreadsheet (corrupt Excel document?) and got the same
results. We created a new, blank Excel document and pasted into it with the
same results.

The user opens an existing document and pastes it, and the text pastes
perfectly into a single cell as you would expect. She does not know what may
have changed from the old document to newly created documents.

Our only workaround so far is to paste into Word, then copy/paste from Word
to Excel and it works. Can anyone offer any insight into what has changed
here because we're stumped. Thanks in advance!