Copying Word Information/Pasting Into Excel

Disarmonious

Board Regular
Joined
Oct 31, 2016
Messages
138
Hello,

I have columns specifically designed for the user to type people's names. I'd like to know if it is possible to copy these names from a Word document, and then paste them into these cells. For design reasons, the cells are merged together to create a larger cell.

I'm getting an error message in Excel, even on short names. For
example, if I copy the name, Smith, John from my Word document, and I try pasting this name into the cell in Excel, I get this message; 'The data
you're pasting isn't the same size as your selection. Do you want to paste anyway?' - I select "OK", and then get this error message; 'We can't do that to a merged cell.' Anything I could do to get this to work for me?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005
fredfred
fred copied from word and pasted into cell E1
E1 copied and pasted into A1
which is A1:B5 merged

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,498
Messages
5,596,509
Members
414,073
Latest member
Contilly

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top