cell displays formula instead of value

[Jeff Higgins]

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

 

[Beege]

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

Beege

 

[Jeff Higgins]

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

 

[Pete_UK]

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

 

[Jeff Higgins]

Pete_UK

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

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