Pasting tables – line breaks in Word and Excel
I wanted to copy a table in Microsoft Word 2010, and paste it into excel – however there was the small issue of some of the cells containing multiple lines of content, with lines separated by line breaks. when these were copied into excel, each line ended up in a separate cell of its own, not what I wanted.
I now know that some special characters can be entered into Microsoft Word find and replace boxes for example “^p” is the same as the line break. however these codes cannot be used in excel. that would be far too easy. No, there is a different code in excel which happens to be “ALT+010” so now there is a few stages to the process
- firstly select the table and find “^p” and replace with something that is not used like “@@”
- copy table and paste into excel
- now find the “@@” and replace with “ALT+010” which looks like a “.” but turns into line breaks within the cells.
- done.
Now I might be able to get done what I was planning.