LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Reed
 
Posts: n/a
Default How can I paste into a merged cell?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Able to overwrite locked cell in protected sheet [email protected] Excel Discussion (Misc queries) 0 June 20th 06 07:48 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
Select cell, Copy it, Paste it, Return to Previous cell spydor Excel Discussion (Misc queries) 1 December 30th 05 01:29 PM
How do I copy data in single cell format to a merged cell format Paul Excel Discussion (Misc queries) 1 June 27th 05 11:00 AM
excel - numbers as text Thuferhawat New Users to Excel 12 January 24th 05 09:29 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"