Moving Text from Excel to Word

P

PGP

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.
 
S

SVC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top