cell displays formula instead of value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Higgins - 19 Jan 2006 01:09 GMT

Hi,
Excel 2003 SP2
I have a new blank workbook,
and on a new blank worksheet
I format columns A - D as Text.

A1 = [This_]
B1 = [is_]
C1 = [text.]
D1 = [=CONCATENATE(A1, B1, C1)]

D1 now displays [=CONCATENATE(A1 ,B1, C1)]
instead if the expected [This_is_Text.]

Please help.
I have hours in this :((
Thanks
Jeff Higgins

Reply to this Message

Beege - 19 Jan 2006 01:14 GMT

Jeff
D1 should have been formatted as "general". Format it, re-type formula?
HTH

Beege

> Hi,
> Excel 2003 SP2
[quoted text clipped - 14 lines]
> Thanks
> Jeff Higgins

Reply to this Message

Jeff Higgins - 19 Jan 2006 01:34 GMT

> Jeff
> D1 should have been formatted as "general". Format it, re-type formula?
> HTH
>
> Beege

Beege,
I guess that makes sense, after all
=CONCATENATE(A1, B1, C1) is text.

After all this, I think I'll grab a big piece
of bubble gum and take a stroll.

Appreciate the help, thanks.
Jeff

Reply to this Message

Pete_UK - 19 Jan 2006 01:45 GMT

A shorter version of your formula can be written as:

=A1&B1&C1

& is known as the concatenation operator (i.e. it "joins" strings
together).

Pete

Reply to this Message

Jeff Higgins - 19 Jan 2006 01:55 GMT

Pete_UK

>A shorter version of your formula can be written as:
>
[quoted text clipped - 4 lines]
>
> Pete

Thanks, &appreciate the note.
Jeff
Sorry if I emailed you.

Reply to this Message