Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COPY DATA FROM ACCESS - PASTE IN EXCEL | Excel Worksheet Functions | |||
Can't Access Paste Special Anymore | Excel Worksheet Functions | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
can't sum up items i cut&paste from access to excel.. | Excel Discussion (Misc queries) | |||
Paste Access data into Excel spreadsheet | Excel Discussion (Misc queries) |