Transfer data from merged cells in excel [Closed]

Question

Ask a question Report Reply to this topic

Transfer data from merged cells in excel [Closed]

Princess z - Dec 24, 2008 at 11:14 AM - Latest reply: pseudonymph

- Apr 2, 2009 at 05:46 AM

Excel Ask a question Report Reply to this topic

Hello,

I have a worksheet form in excel and I would like to copy the informaiton on the form to another sheet in a different workbook in excel as well.
I can write a simple macro or record to copy and paste the information over but the problem is that the first form has a field for ex First name and the text box has 4 cells merged together so when I copy that merged cell and try to paste it into the other worksheet which has 2 cells merged for the same name column it doesnt work.
Please help me how I can concatenate the cells together and paste it into the other one.
URGENT reply required
Thanks

1 reply

Accepted Answer

+12

Helpful

If you select paste as.. "values and number formats" from the paste special menu you will be able to paste as values into merged cells.

Hope this helps!

Was this answer helpful? Yes No