Formula to transfer text from merged cells to single cell?

G

Guest

How can I create a formula to automatically transfer text from merged cells
on one worksheet to a single cell on another worksheet? This would operate
like a summary sheet with the data transferred automatically. I tried the =
and clicking on the merged cells but I keep getting a zero.
 
P

PCLIVE

When you just click on the merged cell that contains text, does that text
show up in the formula line? It sounds like the cells may not actually be
merged. It appears that the text may just be wider than the cells width and
being displayed into the cell next to it. Check this out. The only way I
can get a "0" to appear when using the =Sheet1!A1 formula, is when A1 is
actually empty. If A1 and B1 are merged with text in it, and I use that
same formula, the text appears as expected.

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula from a single cell to a merged cell 4
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Sharing workbooks limitations - Merged Cells 12
some text shows in merged cells but not all 2
Merged cells and formula data sources 10
Count with merged cells 2
copy formulas over merged cells 2
Merge Cell Cut & Paste 1

Top