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 |