How do formula's work in merged cells

[Wayne.Miller]

I have a spreadsheet that contains merged cells. I can't un-merge the
cells because this sheet is a form that is used by others.

I can't get the concantenate formula to work in a merged cell. For
instance, with
=CONCATENATE("Ship to ", "Bob")
one would expect the cell to show, Ship to Bob. However, it just shows
the formula. I get the same result with
="Ship to "&"Bob"

The formulas work just fine in un-merged cells. How do I get them to
work in merged cells? In practice, I want to concatenate text in
quotes with text in referenced cells.

I'm using Excel 2004 version 11.3 and Mac System 10.3.9.

Thanks,
Wayne

 

[Bob Greenblatt]

I have a spreadsheet that contains merged cells. I can't un-merge the
cells because this sheet is a form that is used by others.

I can't get the concantenate formula to work in a merged cell. For
instance, with
=CONCATENATE("Ship to ", "Bob")
one would expect the cell to show, Ship to Bob. However, it just shows
the formula. I get the same result with
="Ship to "&"Bob"

The formulas work just fine in un-merged cells. How do I get them to
work in merged cells? In practice, I want to concatenate text in
quotes with text in referenced cells.

I'm using Excel 2004 version 11.3 and Mac System 10.3.9.

Thanks,
Wayne

Formulas work fine in merged cells. Are you sure the worksheet is showing
data vs. formulas? What happens when you press control `? (That is control
plus the key to the left of 1 on the top row.) Are you certain that there
is not an apostrophe before the equal sign in the formula?

 

[Wayne.Miller]

Thanks, Bob!

I looked more closely on the problem after receiving your reply. It
turns out that the merged cells were formatted as TEXT. After changing
them to the number format, everything works fine.

Wayne