| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to merge excel and word documents
I have tried to merge excel and word documents many times but it didn't work
out. please help!! Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to merge excel and word documents
If you are going from WORD to EXCEL - then to get everything to work correctly - put you stuff into a WORD Table, then remove any of the following with the find and replace function of WORD: Remove all "paragraph marks" (^p), "manual line breaks" (^l), any "tabs inside a cell" (^t). Then you should be able to paste into excel without any problems. You might have to "turn-on" non printing characters to be able to "see" the tab, paragraph, and manual line breaks indicators. Also you can find the above characters in the "FIND" popup menu - Select "MORE" tab - then "SPECIAL." Then for the replace - just press the spacebar and this will give you 1 space. *** Going from EXCEL to WORD you should be able to do a COPY and PASTE. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=526886 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you get Word to open documents in it's own window(s)? | Excel Discussion (Misc queries) | |||
| can I merge documents in excel like I can in Word | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| how do I use mail merge in excel for word documents | Excel Discussion (Misc queries) | |||
| How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
Hybrid Mode
