| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Moving Text from Excel to Word
I put text in an Excel cell and used alt+enter to add a return. When I copy
the cell to Word and convert the table to text, the returns appear as a bent arrow pointing back to the text. This arrow messes up the auto numbering. The only way I can figure to delete it is to manually select and delete each one. I can't even copy it into find/replace and replace all. Any suggestions? I suspect this character is the symbol for alt+enter for Excel. Thanks. -- Thanks in advance for all your help. PGP |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Moving Text from Excel to Word
Find: ^l (an "el"), Replace with ^p (single pagaraph return) or ^p^p (for a
blank line between paragraphs) ^L is equivalent to Manual line break, ^p is a Paragraph break. These are listed in the Find & Replace dialog box under More, Special. "PGP" wrote: I put text in an Excel cell and used alt+enter to add a return. When I copy the cell to Word and convert the table to text, the returns appear as a bent arrow pointing back to the text. This arrow messes up the auto numbering. The only way I can figure to delete it is to manually select and delete each one. I can't even copy it into find/replace and replace all. Any suggestions? I suspect this character is the symbol for alt+enter for Excel. Thanks. -- Thanks in advance for all your help. PGP |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
| Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
| Open word in text mode | Microsoft Word Help | |||
| Word applies direct format on File open | Microsoft Word Help | |||
| Excel worksheet in Word linked text boxes | Page Layout | |||
Linear Mode
