Ask Your Question

Linking text from a merged cell.

asked 2015-01-17 09:24:27 +0200

dejayajay gravatar image

updated 2016-03-09 21:14:58 +0200

Alex Kemp gravatar image

I am trying to link (copy) text that is in a merged cell on one sheet, to a merged cell on another sheet (in the same workbook). In the destination cell, I have typed =, then the address of the source cell. All I get in the destination cell is the reference to the source cell IE: Sheet1.A1, instead of the text that is in Sheet1.A1.

If I un-merge both cells, everything works as it should. Unfortunately, this is no good for what I am trying to achieve, as I need both source and destination cells to be merged to certain sizes, so that they look appropriate, for data (text) entry on the source sheet, and for printing on the destination sheet.

Any ideas ? Thank you.

edit retag flag offensive close merge delete


Verify destination cell is not formatted as text @.

m.a.riosv gravatar imagem.a.riosv ( 2015-01-17 15:37:43 +0200 )edit

Thank you. That fixed it. Bless LO Ask.

dejayajay gravatar imagedejayajay ( 2015-01-19 02:27:12 +0200 )edit

I have another related question, but I'll post it as a new item.

dejayajay gravatar imagedejayajay ( 2015-01-19 02:44:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-02-21 20:58:52 +0200

elismyer gravatar image

Question answered in comments but not closed.

Verify destination cell is not formatted as text @. -m.a.riosv

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-17 09:24:27 +0200

Seen: 1,151 times

Last updated: Feb 21