Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Word document provide input data which consists of a varyable number of lines
ending with paragraph mark and manual line break. Attepmting to copying the input data into a merged cell results in "Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?" On clicking "OK", the paste fails with an error message "cannot change part of a merged cell". Can the line endings (including paragraph character) be converted into Alt-Enter which Excel supports for manually entered multi-line data in single and merged cells? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Able to overwrite locked cell in protected sheet | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel |