Help with getting text from "Merged Cell"

T

tjhorne

I have a merged cell that spans from B:7 to B:18 (on worksheet named,
OperatingRevenue) and I am trying to get that text to display in
another worksheet (worksheet named, Upload) within the same xls file.

I am using the following function but it doesn't seem to work:

=+OperatingRevenue!B7:B18

Any ideas?

Thanks!

Todd H.
 
P

PCLIVE

Todd,

I'm not sure if you intended to have a "+" in your formula, but that could
cause a problem.
Try it with out the "+" symbol.

=OperatingRevenue!B7:B18

HTH,
Paul
 
F

Faz

This should work.
=B7

If you click on any merged cell, it should tell you what cell it is in
the Cell Reference box in the top left corner of the worksheet.
 
D

Duke Carey

Do not, repeat, DO NOT use merged cells. Use Format->Format
Cells->Alignment->Horizontal->Center Across Selection instead.

Merged cells cause all kinds of problems and offer very little that can't be
accomplished in other, simple ways.

Once you change from merged to Center Across Selection, just reference cell B2
 
T

tjhorne

I am trying to display the information in the merged cell into another
WORKSHEET within the same excel file.

I am referencing B7 within my formula(=+OperatingRevenue!B7) but it
doesn't seem to be working.

Anymore ideas?

Thanks!
 
T

tjhorne

Both of your suggestions seem to work fine. I think I'm having problems
with limitations within Excel. I have users entering text explanations
for financial results and I am looking to put this commentary in
another worksheet but I think Excel has limits on how much text it will
move over to another worksheet.

Can you confirm?

Thanks!
 
D

Duke Carey

There shouldn't be any limiation

If you have "unmerged" the cells then I'd follow the path of select the cell
with the text in it, copying it, navigating to the sheet where you want the
link and using Edit->Paste Special->Paste Link
 
Top